Access 2007-2013
Access 2000-2003
Seminars 		Tips & Tricks
Access Forum
Course Index Insider Circle 		Collapse Menubar
 
Tutorials   News   Tips   Templates   Forums   Help   Logon   Order  
 

News      User Comments     History     Notify Me

8/8/2012 2:21:42 PM
Access 2010 Beginner 6
 
 This Microsoft Access video tutorial picks up where Level 5 left off. This class covers finding customers with missing address info, creating an employee form with a picture, creating employee name badges, and more. Topics include:

- Missing Address Info
- Is Null and Is Not Null Scenarios
- OLE Objects
- Storing Pictures in a Database
- Align / Size to Grid
- Stretch, Clip, Zoom Images
- Employee Name Badges
- Adding a Company Logo
- Bound v. Unbound Image Controls

Click here for more information on Access 2010 Beginner Level 6, including a course outline, sample videos, and more.

Permanent Link
Course Link: Access 2010 Beginner 6
Keywords: access 2010 beginner 5 address is null is not null ole objects pictures images align to grid size
Page Tag: whatsnew
Post Reply

Select all fields Comment from Mo Khan @ Fri 5/3
How did you select all the fields from the field list? Its been bugging me all day.

Reply from Richard Rost:

Click on the first one. Hold down the SHIFT key. Click on the last one.
Show Just This Thread        Post Reply
Is Format Painter available in Access 2007 Comment from Patricia Clark @ Tue 4/23
Is Format Painter available in Access 2007?  I can't find it.

Reply from Richard Rost:

Yep. It's been in there since at least Access 2000. I don't have 2007 installed anymore so I can't tell you exactly where it is, but in 2013 it's on the Form Design Tools > Format tab.
Show Just This Thread        Post Reply
This is the fun part for me Comment from Patricia Clark @ Mon 4/22
This is the fun part for me...I like making things look pretty.  You sure make it easy.  Thanks
Show Just This Thread        Post Reply
pictures render properly on my desktop Comment from Mike Rand @ 3/31/2013
Me too. I'm having a similar problem.  Both *.jpg and *.bmp pictures render properly on my desktop but when I drag them to the picture field they appear as only an icon.  I can send you a "Prnt Scrn" or my PCResale Customer Database file, oi that would be helpfull.
Show Just This Thread        Post Reply
OLE objects Comment from Nick WILLIAMS @ 1/17/2013
I tried the procedure shown in this lesson but it didn't work. First I converted the JPEG via Painter into a .bmp file.  The resulting file is big - 22.9 MB.  When I tried to paste it into the box on the form (form view) I got this message:  
"MS Access can't read the OLE object because communication was interrupted. If the OLE server application is located on a network server, make sure your server is connected to it."
Not sure what that means; my home computer is connected to a WiFi router and network.  
I also tried the other route: right click in the box --> new Access menu --> create   from file --> browse, etc.  But I got the  same message.  
thanks, Nick

Reply from Richard Rost:

As I mentioned in the lessons, Access itself doesn't handle images. It relies on whatever your computer's default application is for that image type. You can determine what this is by double-clicking on an image file from Windows Explorer (or My Computer) and whatever app opens up the image is your default handler. Any time Access gives you that error message, it's having a hard time communicating with the handler app. You can try CHANGING that app by right-clicking on the image file and selecting OPEN WITH... Pick another program like Microsoft Paint or MS Photo Viewer. Sometimes other 3rd-party apps like Photoshop or even your web design editor can "take over" handling of JPGs and Bitmaps, which is bad.
Show Just This Thread        Post Reply
Image Not Displaying Comment from Ron F @ 12/17/2012
Richard, did what you said and still not successful.  Talked to the IT Department here and they think it could be a problem with the Network.  They will look into it.  Just as long as I know HOW it should be done and not that I or you are doing something wrong.  Thanks for your help!
Show Just This Thread        Post Reply
Image Not Displaying Comment from Ron @ 12/15/2012
In Level 6, Lesson 4, for inserting picture into the form. I followed your steps as given but the best that will come out after I changed a jpg to a bmp to a small picture (kind of like an Icon) with the file name listed under it. Tried other ways but keep getting the same results. The form will print but the picture remains small showing the picture file name. Can you help as I know that I will have the same problem in Lesson 5 for ID's. Thanks

Ron, make sure that you have Microsoft Paint set up as the DEFAULT HANDLER for BMP images. This is a Windows setting. You want to make Paint the application that opens BMP images by default. You can do this by right-clicking on any BMP file, selecting OPEN WITH, and then selecting Paint. Make sure to set this as the DEFAULT app (open with this app every time). The steps are roughly the same, but slightly different with each version of Windows. You may have some other application install that's trying to "handle" BMP files which is causing problems in Access. You can also TRY to do the same thing with GIF and JPG images.
Show Just This Thread        Post Reply
bitmap not displaying on report Comment from Eli T @ 12/14/2012
I can copy the picture from the Form and paste it to the Report, but it doesn't show up automatically.

Reply from Richard Rost:

I've done it a million times in my databases, but I'd have to see a copy of your database to tell you why it's not working for you. JPGs and GIFs can sometimes be a pain with Access, but BMPs always work.
Show Just This Thread        Post Reply
bitmap not displaying on report Comment from Eli Tilahun @ 12/11/2012
I used paint, changed the picture to a bitmap. It displays on the Form, however it doesn't display on the report (label).

Reply from Richard Rost:

It should. As long as you're using the same control type, and it's still bound to the same field, and that field is in your report, it should work.

Make sure the field that stores the picture is in the underlying record source for the report. You should just be able to copy and paste that picture control from the form directly to the report.

Also, make sure you're in PRINT PREVIEW mode. Pictures don't generally show up in the default "report" view.
Show Just This Thread        Post Reply
Is Null Comment from Vannak Hou @ 12/9/2012
If you were to put "Is Null" on the same line in the "or" right across in each field, does it affect anything?  You put "Is Null" in each of a different place under the "OR" section.  It's like a step ladder.  Are you suggesting that is a good way of writing a code/program? Index Time:  12:40-12:50.

Reply from Richard Rost:

If you go straight across one row, you're making an AND condition. So FirstName Is Null AND LastName Is Null AND CompanyName Is Null.

If you go DOWN one "OR" row each column, then it becomes an OR condition. So you get FirstName Is Null OR LastName Is Null OR CompanyName Is Null.

It all depends on your needs.
Show Just This Thread        Post Reply
convert the bitmap file to a smaller size Comment from Wanda W @ 11/28/2012
I'm trying to insert a picture in my form, it's an inventory list form, and I converted the file to Bitmap and I get this error message when I drag the bitmap file over: "Microsoft Access can't read the OLE object because communication was interrupted.  If the OLE server application is located on a network server, make sure your computer is connected to it".  It is on a network server and it is connected, I have confirmed this.  The original picture was a 2.3 Mb jpeg and when I converted to a bitmap it became a 20.5 Mb file.  Would the larger file size be an issue?  I know we have limitations on our server with emailing files larger than 10Mb, but this is not email.  Would the file size be the issue?  Can I convert the bitmap file to a smaller size?

Reply from Richard Rost:

I would guess that the error is caused by the size of your file. Yes, that's pretty big. First, try the JPG directly. It might work. JPG and GIF files work OK on some systems, they just don't work reliably on ALL systems.

Second, you might want to consider a different technique for displaying your images. I have a whole seminar on ACCESS IMAGING. Basically, storing images in your database works OK for small files, and when you don't have a lot of them, but for BIG files (or lots of files) the best solution is to just store the image on your network (or PC) drive and save the path/filename in your database.

I cover several different methods for doing this in the seminar, and there's also a TIP VIDEO that explains a good technique too.

Oh, and yes, it's sometimes possible to shrink the size of a bitmap. Get it on your screen and perform a screen capture of it (press PRINTSCREEN, paste into PAINT). You'll lose some resolution if it's a HUGE file, but that's usually good enough.
Show Just This Thread        Post Reply
Comment from Srinath Nandyal @ 10/1/2012
A minor correction. When you moved Last Name next to First name, you did not change the label of First name to First and Last Name
Show Just This Thread        Post Reply
Comment from Tom Cermak @ 9/21/2012
Display type is set to "Content" still the same.  I tried inserting it (as opposed to the drag and drop) no luck there either.

Reply from Richard Rost:

I'd have to see your database to tell you for sure. I've never known Access 2010 to do that. Older versions were horrible with displaying images, but 2010 has always worked great.
Show Just This Thread        Post Reply
still displays as an icon Comment from Tom Cermak @ 9/21/2012
I used paint, changed the picture to a bitmap, but it still displays as an icon.

Reply from Richard Rost:

Make sure you don't have the "display as" set to ICON. Beyond that, I'm not sure... I've never encountered an Access database that couldn't display a bitmap.
Show Just This Thread        Post Reply
Comment from  Karen @ 8/20/2012
I'm creating an order form that has a Customer, a Pickup and a delivery contact. Sometimes my customer is also the pickup or delivery, sometimes its three different contacts. How do I set up my order form to pull information for all three contacts. Understanding relationships between tables do I need to set up a master "Contact" table and then seperate "Customer", "Pickup" and "Delivery" tables or can I pull from just the "Contact table"?

Reply from Richard Rost:

Ideally, you would want 2 different tables here. One for your "contact" as you call it, and then a second table to store the related information (customer, pickup, delivery). This is a classic one-to-many relationship. I have NOT covered this yet as of Access Beginner Level 6. I will be covering it in Access Expert Level 1. If you want to learn it now, you can see Access 201 (for 2003) or my Access Relationship Seminar.
Show Just This Thread        Post Reply
Comment from  Selby @ 8/9/2012
Dear Richard, Thanks for your help, your the best, Regards Selby
Show Just This Thread        Post Reply
Access 2010 Beginner 6 Comment from Brent @ 8/9/2012
Level Seven is in production after Search Seminar right? you said you were going to jump right over to the search seminar after level 6.
Show Just This Thread        Post Reply

Add Your Comments or Subscribe
 
If you just want to subscribe to get email updates when the News is updated, then enter your name and email address and check the Notify Me box below. If you would optionally like to add your comments below to be posted, they are welcome.
 
  Your Name:  Shown
  Your Email:  NOT Shown
  Subject:
  Comments:

 

Sorry about this step. It's just to keep the spam bots away:
  Verify: What is 9+2:
  
  Notify me when the News is updated.
  Remember Me for my next comments
  
 
 
Please do not use this form for Customer Service inquiries! If you have questions about your account, shipping info, courses you've ordered, need passwords, etc. please use the Customer Service Center instead.

I value your comments. They will be displayed on this page (above). Your name will be displayed, but your email address will not be. As always, I promise to never give away your personal information to anyone else, ever.

 

 

You may want to read these articles from the 599CD News:

5/14/2013Access Tip: Many-to-Many Relationships
5/14/2013Access Expert 5 Handbook Ready
5/10/2013Access Tip: Email Using Outlook
5/10/2013Microsoft Access Expert 5
5/2/2013Access Amort Handbook
4/29/2013Microsoft Access Expert 4
4/28/2013Access Tip: Toggle Button Colors
4/27/2013Access Expert 4
4/23/2013New Access Tip: Conditional Format Expression
4/15/2013New Access Tip: Grid Lines v. Dots
   
Learn
 
Microsoft Accessindex
Microsoft Excelindex
Microsoft Wordindex
Microsoft Windowsindex
Microsoft PowerPointindex
Adobe Photoshopindex
Visual Basicindex
Active Server Pagesindex
Online Seminars
More...
Customers
 
 Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
 Info
 
 Latest News
New Releases
User Forums
Tips & Tricks
Search Our Site
Waiting List
Production Schedule
Collapse Menus
 Help
 
 Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
 About Us
 
 Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
 Order
 
 Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
 Contact
 
 Live Chat
General Contact Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey