Access 2007-2016
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
 

News      User Comments     History     Notify Me

8/8/2012 2:21:42 PM
Access 2010 Beginner 6
By Richard Rost   Richard Rost on Facebook Richard Rost on Twitter Richard Rost on Google Plus Richard Rost on LinkedIn Email Richard Rost

 
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

Access Assistance Available Comment from William B @ 3/17/2018
On lesson Beginner 6 Mr Rost explains how to put pictures into a employee file. this is the response i get from my computer. When attempting to do so.

Microsoft Access                                                                       X

There isn't enough memory to complete the Automation object operation on the Bitmap Image object.

Close unneeded programs and try the operation agian.
For more information on freeing memory, search the Microsoft Windows Help index for memory, troubleshooting.


This should not be a issue in my eyes because this computer has a tara byte hard drive, with 16gb ram, and core processor of 4.20 GHz. the pic size is 1.70 MB




Reply from Alex Hedley:

Did you try reboot?
Backup of db and then a compact and repair?
Repair of office?
Show Just This Thread        Post Reply
Images Comment from modi waggeh @ 5/12/2016
Hi Richard, will the picture be remain in access, if I delete the original image on my local computer? And how to use file path to OLE object?


Reply from Alex Hedley:

I would advise against storing the picture in the db.
If you have it will remain in that, otherwise if you link and delete it won't show up anymore

See more in the Imaging Seminar
Show Just This Thread        Post Reply
I went back through the lessons and cannot find wh Comment from Marianne Bennett @ 4/6/2016
I went back through the lessons and cannot find where you taught how to build a mailing label report.  Could you guide me to that particular lesson?


Reply from Alex Hedley:

Did you try the search or the Outlines?
There are a couple, check out the list.
Show Just This Thread        Post Reply
Overlapping Windows Comment from Bernardo Ito @ 3/8/2016
Hi Richard,
My question is regarding the way Access displays the information.
I would like to be able to  make Access let me have multiple forms, tables or queries open so I can work with them at the same time. (As you did in Lesson 3 Level6 Beginner at Time Index: 02:15, when you used two Forms at the same time). However, my Access only let me have one Form open covering all the screen.
I already tried with Access Option|Current Database| Document Windows Options-Overlapping windows. But it doesn't seem to work.
Could you help me out to  change the way Access Displays the information?


Reply from Alex Hedley:

When you try and open two forms is it still opening as a tab?
Show Just This Thread        Post Reply
Input Mask Comment from Dean Cumbo @ 2/9/2016
Richard, when trying to do the input mask for the SSN i click save and it jumps to highlite LastName and states that there i cannot define a field more than once.  any suggestions


Reply from Alex Hedley:

Check the names of the Fields haven't been changed in error
Show Just This Thread        Post Reply
Perhaps this is covered elsewhere but how do you Comment from James Comninellis @ 1/15/2016
Perhaps this is covered elsewhere, but how do you create an envelope report that has the right spacing btwn fields. For example, I want to send a letter to someone in St. Louis but also some in Marylandville Heights. How do I make a city field that will accommodate a long and short city name without awkward spaces?


Reply from Alex Hedley:

String Concat Tip
Use + to not show nulls
Show Just This Thread        Post Reply
Change the Dollar Sign in the Currency Comment from Meenakshi Sundaram @ 12/18/2015
How can I change the Dollar Sign in the Currency field according to their respective currency sign.


Reply from Alex Hedley:

This should be picked up by the locale of the machine that the user has set
Show Just This Thread        Post Reply
inserting pictures Comment from Louise Randa @ 10/29/2015
I had problems inserting pictures as well, but i found the cause. Maybe it can be of help to others having issues. To use the drag and drop or the right click insert object, i needed to be in Form view. That was the only way for me to add pictures
Show Just This Thread        Post Reply
bmp not showing on forms Comment from Omar A @ 10/10/2015
They do not. However, since using the path file name and then referencing that with an image box does not bloat the database, I will be doing that from now on. Thank you.


Reply from Alex Hedley:

It's the preferred method, I'll take another look into why it might be happening.
Show Just This Thread        Post Reply
bmp not showing on forms Comment from Omar A @ 10/8/2015
I've been having the same problem as everyone else in that .bmps are not showing on forms. I've followed every step given (including the pathname in the field), and the only solution was David's. That is, creating an OLE object field-->right clicking-->insert object-->create new-->bitmap-->paste your image in paint-->exit paint. That works fine, and I realized that in the field it then says "bitmap image". However, if we do it the way you demonstrated, it says "package". I feel whatever is causing that is the culprit. Any ideas?


Reply from Alex Hedley:

Strange, bitmaps should show by default, you usually need other software installed for showing other image types
Do other types work for you?
Show Just This Thread        Post Reply
Benefit of Copy Pasting Controls Comment from Joe Beniacar @ 9/17/2015
Hi Richard, what is the benefit of copying + pasting controls with the same names from 1 Form to another?


Reply from Alex Hedley:

It means you don't need to add names, formatting etc.
Show Just This Thread        Post Reply
Pictures Comment from Justin R @ 9/14/2015
Using Windows 10 and not a fan.  Can't find paint so I took a screen capture and cropped it in excel.  Then dragging that image in the OLE field and that works well.


Reply from Alex Hedley:

Have you tried just pressing the windows key and typing paint, it searches right there and then.
Show Just This Thread        Post Reply
Access 2010 Beginner 6 Comment from Peter D @ 9/6/2015
Having trouble finding your database to download


Reply from Alex Hedley:

There's a link to the Student Databases in the footer.
Or you can use the search in the header.
Show Just This Thread        Post Reply
Displaying an Image Comment from Steven Mcgavin @ 7/20/2015
Working with your PCResale database I am having trouble inserting the .bmp picture.  I am using Windows 8.1 and Office 365, the anual subscription office. The pictures show up as an icon and file name. When I double click on the icon it opens up in MSPaint and the   picture is displayed. I've tried the suggestions but it still won't display in the form. I don't know what to try next. Do I need to worry about or just continue with your lessons?


Reply from Alex Hedley:

I don't have a 8.1 box at hand to test, can anyone help out?

There's no reason why you can't continue.

The Imagaing Seminar goes into a lot more detail which could be of use.
Show Just This Thread        Post Reply
Extra Lines Comment from Christy Osterkamp @ 2/20/2015
Figured it out for myself, sorry.  The Number of records is not necessarily the next autonumbered record.  

Never mind:)
Show Just This Thread        Post Reply
Extra lines Comment from Christy Osterkamp @ 2/20/2015
If I am not jumping ahead, can you tell me why I just added more lines to the table, but they do not appear on the corresponding Form?  I thought we could add data to either/or.


Reply from Alex Hedley:

Which Form?
Is it bound to a Table or Query?
If it's a Query is it limited by a Criteria?
Show Just This Thread        Post Reply
Can you copy and paste fields from Access Database Comment from Robert Field @ 1/31/2015
Can you copy and paste fields from Access Database to another Access Database like you did from one table to another table in this lesson?


Reply from Alex Hedley:

Yep just highlight in design mode and copy and paste
Show Just This Thread        Post Reply
Zoom in on Form Comment from Phil @ 1/28/2015
I'm on A2010 and working with a form in Design View.  I would like to zoom to see my placements better (as you do from time to time during the course) but cannot find a zoom utility.  An online search suggested shift + F2 but this did nothing.  Another suggested changing display resolution but that seems silly.  Can you advise?  Thanks in advance. PT


Reply from Alex Hedley:

I think that's the video that is zoomed not the Form.
I don't think there is an option like you can in Word/Excel.
Show Just This Thread        Post Reply
Tab View - Window View Comment from Steve Reed @ 1/21/2015
In Beginner level 6, putting together an Employee Table, how do you switch from Tab View to Window View?


Reply from Alex Hedley:

This is covered in Beginner Level 1 and 2

File | Options
Current Database
Document Window Options
Overlapping Windows
Tabbed Documents

Choose one, click ok, you will be asked to close and re-open the db for it to take effect.
Save your db and do so.
Show Just This Thread        Post Reply
Toolbox Comment from Vannak H @ 1/1/2015
Richard, I just found it.  Office 2013 is a bit different.  It's in the Design, Controls, I just had to click on the down arrow key to see more of it.  Took me a while to find it.  Thanks again.
Show Just This Thread        Post Reply
Toolbox Comment from Vannak @ 1/1/2015
Richard,

Where is the Toolbox (start 07450) in Access 2013  (MS Office 2013).  I don't see it.  Please help!


Reply from Alex Hedley:

Is your ribbon expanded?
Show Just This Thread        Post Reply
Order By Two Fields Comment from wendi keith @ 12/24/2014
In Access, how do you make a birthday list. In order by month and year. Everything I try orders by the year first.


Reply from Alex Hedley:

In the Query Designer drag the Field you want ordered to the first column, it goes by that order
Show Just This Thread        Post Reply
Access 2013 Memo Field Missing Comment from Farrel Lazarus @ 12/5/2014
Im working with Access 2013 ... I have notice that when using notes there is no Memo ... What should I do.
Thanks Farrel


Reply from Alex Hedley:

Farrel they've changed the names of some Data Types in 2013.
You now have "Short Text" and "Long Text" instead of "Text" and "Memo"
Show Just This Thread        Post Reply
Image Not Displaying in Access Comment from CHARALAMPOS @ 11/8/2014
I have tried jpg and bmp but to no avail. Can I upload to you my small database and 2 or 3 photos in bmp format so you can see what is the problem?


Reply from Richard Rost:

Access itself doesn't handle displaying images. It uses whatever your default Windows image handling program is to display them. If images aren't displaying properly in Access, chances are you have some other 3rd-party program set up as your default image handler that doesn't get along with Access. The easiest fix is to make sure that you have Microsoft Paint set up as the default handler for BMP, GIF, and JPG images. This is a Windows setting. You want to make Paint the application that opens images by default. You can do this by right-clicking on any BMP, GIF, or JPG 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 installed that's trying to "handle" your image files which is causing problems in Access.


If you want us to look at your database for you, feel free to submit it to the TECHHELP team. However, be warned that 90% of the time it's a separate problem on your PC, not your database.
Show Just This Thread        Post Reply
Image Not Displaying in Access Comment from CHARALAMPOS D @ 11/8/2014
I have photoshop and Lightroom but for the purpose of the access learning I have chosen "paint" as my default program but no result.


Reply from Alex Hedley:

What file type are they?
png / JPEG / jpg / bmp
Could you try a bmp, these shouldn't have a problem, then try a few other types
Show Just This Thread        Post Reply
Image Not Displaying in Access Comment from CHARALAMPOS DEMIRIS @ 11/6/2014
Same problem for me. The images that I insert in a pictures frame in a Form appear as icons with the file name and not as pictures. It works in Design mode but then I can't pick a different picture for every employee


Reply from Alex Hedley:

What image editing software do you have on your machine?
This can sometimes make a difference.
Show Just This Thread        Post Reply
Comment from FARAAZ SIDDIQUI @ 10/8/2014
Hi...When I am trying to right click the OLE Object Box. The Insert tab is de-activated in the drop down bar. I cannot click on it... Following happened to me in the form view (while following the previous video lesson 4) as well. I ended up cutting and pasting image straight from paint in my form view. Now in my labels...following image is not showing as well.
Show Just This Thread        Post Reply
When you copy existing fields from one form to ano Comment from Tareq Salloum @ 10/1/2014
When you copy existing fields from one form to another one, does Access know automatically to change the source table where it gets the field information from?


Reply from Alexander Hedley:

Hi Tareq,
The CONTROL SOURCE of the TextBox or Control that you copy will copy over but the Form's RECORD SOURCE won't change, you will have to set that manually yourself.
If you have already set the RECORD SOURCE of that Form and it contains a FIELD that matches the FIELD of the Control you have copied it will show that value.
Show Just This Thread        Post Reply
Comment from shawn mccune @ 7/10/2014
I like knowing how to copy and paste labels between tables. This saves time and reduces work.
Show Just This Thread        Post Reply
Nav Forms Comment from Leon Van Niekerk @ 7/7/2014
Hi Richard

In Access Beginner 7 No1 @ 10.18.

When I add a second report it is adding the new report underneath and not next to the new one. How do I correct that?


Reply from Richard Rost:

I'm not exactly sure - can't tell from your description. Make sure you're dropping it in the right place.

I wouldn't worry too much about this, however, because I almost NEVER use Navigation Forms, and in the next lesson you'll be learning a BETTER way to make menus.

Show Just This Thread        Post Reply
Comment from David Sprecher @ 4/30/2014
On the subject of images not displaying Microsoft have some advice:
http://office.microsoft.com/en-au/access-help/what-to-do-when-you-see-file-names-instead-of-images-in-your-access-database-HA001150411.aspx?redir=0
Show Just This Thread        Post Reply
images Comment from David S @ 4/30/2014
I don't think that works.  I think you have put in an unbound image i.e. the image is part of the form design and does not change with each record.
Show Just This Thread        Post Reply
images Comment from BJ @ 4/28/2014
Rick -- I emailed you earlier about a problem I was having in placing images into Access Forms.  By accident, I discovered how to insert an image into my MS Access 2013 forms without having to deal with the warning I received earlier "A problem occurred while Microsoft Office Access was communicating with the OLE server or ActiveX control".  In the deign tab of the 2013 ribbon, there are a number of buttons, one of which is "image".  If one clicks on this button and drags the cursor to the form (in design view), the cursor changes to a little plus sign.  By dragging the cursor, a box is drawn and a window opens for one to select the desired image.  Once selected and an "OK" button is pressed, the image appears in the box.  I still don't understand why the original method doesn't work and what the error message means, but at least I can now place images into the database form.


Reply from Richard Rost:

Good. I'm glad you figured it out.
Show Just This Thread        Post Reply
Insert picture in OLE Comment from BJ @ 4/27/2014
I am having trouble with inserting an image into the picture frame in the access form.  I am using access 2013.  I followed your tutorial (Access 2010 Beginner 6) to the letter, but when I try to drag and drop the image into the picture frame, I get the message "A problem occurred while Microsoft Office Access was communicationg with the OLE server or ActiveX control".  Then it gives me instructions that I do not understand ("Close the OLE server and restart it outside of Access" -- how do I do this).  Also, there seems to be no insert capability with 2013 -- is this true?  If I right click the picture frame, a drop down box opens that gives a lot of formatting commands for the picture frame box, but there is no insert function.  Can you help me with this?  I have tried to insert bmp images, jpg images, and png images.  I would greatly appreciate any adivce you can give me.  Thank you.


Reply from Richard Rost:

I just tried it with Access 2013, and it worked perfectly fine for me the first time. It may be an issue on your system. First, try rebooting. If that doesn't help, UNINSTALL and reinstall Office. The OLE on your system may be corrupted.

Show Just This Thread        Post Reply
Comment from David Sprecher @ 4/21/2014
Sorry for this excessive posting but I have now found a work around (altho there must be an easier way).  Right click on empty container, chose insert object, chose "Bitmap Image" option BUT chose option "Create New".  That will take you to a blank sheet in Paint. Using the "Paste" tool, chose "Paste From" and then navigate to the file you want to use (jpg's are fine).  It will then load into Paint and the record at the same time.  Ignore the screen dots they will clear when you click away.
This is all essential for me as I need to create a database of many actors, images are essential and bitmaps are rather large files for this purpose.
Hope you're not sick of these posts!
Show Just This Thread        Post Reply
Comment from David Sprecher @ 4/21/2014
Cancel my last post.  That only works in design view to insert a picture and that self same picture is then on each record.  Needs more thought.  Sorry.
Show Just This Thread        Post Reply
Comment from David Sprecher @ 4/21/2014
I have had same problem as everyone else BUT I have resolved it (Access 2013).  If you create the picture frame by using the "image" tool on the Design tab (just to the left of the "Insert Image" tool and to the right of the bound object frame)then the picture displays fine.  In fact in that case you can insert a jpg and save on a LOT of space and some time.

Hope that is helpful.
Show Just This Thread        Post Reply
grid lines Comment from David Sprecher @ 4/21/2014
Great courses, thank you.  I am on Access 2013.  In design view I have the grid as squares with lines but no dots between.  I have searched in vain for a fix in Options. Thank you.
Show Just This Thread        Post Reply
Comment from David Preston @ 1/2/2014
Addendum to my previous question.

If I create a company logo (bmp) - I am able to place the image on the name badge.  However, I still cannot get a bmp to display on the picture field (dragging or choosing a bmp file). However, if I say, create a new bmp file; then MS word opens; if I have paste from any other image file (jpg or bmp) into my NEW bmp file, then it works!!

Very strange. Any thoughts?
Show Just This Thread        Post Reply
Comment from David Preston @ 1/2/2014
Dear Richard, just finished Beginner Level 6.  I cannot get a bmp file to display on a form.  It shows as an icon with the name of the file below. Have tried several bmp files; made sure that default program to open bmp files was MS Paint; ensured that in the properties, Display type is Content (not icon). I am using Access 2013.  Any other thoughts would be appreciated. Displaying images is very important for my applications. Any thoughts would be appreciated. tx
Show Just This Thread        Post Reply
Comment from Salam @ 1/2/2014
Only if you show it in "Form View" then you can see the "insert button" active, I noticed that.
As far as dragging a picture and drop it in the box, well... it didn't work for me either, not sure if there some setting I missing or what, I am using MS ACCESS 2013
Show Just This Thread        Post Reply
Comment from Geni Gellhaus @ 12/17/2013
my pictures have a yellow triangle which usually means an error has occurred.  I have pulled the photo from my desktop as I followed along on the (jpg & bmp)tutorial...created the whole nine yards following along and still the triangle appears in the box instead of a photo.  I can dbl click on photo and it opens up in photo gallery...then I close photo and close db and it will tell me file can't be saved because of error.
Show Just This Thread        Post Reply
still displays as an icon Comment from Lee L @ 12/9/2013
I am having the same problem as others in the past. I have created a small24 bitmap photo and cannot get it to display in the picture area. Was this problem ever resolved for any of the other questioners?
Show Just This Thread        Post Reply
Objectives Comment from Raul Pendas @ 9/7/2013
Rick, I click on a button and my all objectives are gone. I do not see tables, form and querry etc.
How I get back to see on my left side the tables, form and querry?



Reply from Richard Rost:

Raul, I'm not sure what you mean by "objectives." If you're missing the Navigation Pane on the left, you may have collapsed it (in which case it will show up as a bar that you can just click on) or hidden in (in which case, you need to check your startup options under File > Options).
Show Just This Thread        Post Reply
Insert button Comment from Mai Nguyen @ 8/17/2013
The insert button is not even active. I couldn't drop any type of picture in the picture box either.


Reply from Richard Rost:

Without seeing your database, I can't tell you what's wrong.
Show Just This Thread        Post Reply
Trying to insert a form Comment from James Probe @ 8/12/2013
I am trying to insert a form in a form and got this alert,
cannot sort on menu, ole, or hyperlink object [(EmployeeF),(Picture)]. What did I do wrong, Thanks, Jim


Reply from Richard Rost:

Sounds like you're trying to sort on an OLE field, which you can't do. I don't know why you're getting this message when you're trying to insert a subform. Some versions of Access can't have OLE objects in subforms. Try removing the field and see if the error goes away.
Show Just This Thread        Post Reply
Paint Logo Comment from Spencer Black @ 8/4/2013
I've installed Adobe Photoshop on my computer, and I'm getting a Photoshop .bmp logo, even after turning the images to bitmaps.  Then I right-clicked on the image on my desktop to pick "open with" and changed my default file type for .bmps from Photoshop to Paint.  Now I get a paint logo showing the .bmp file.


Reply from Richard Rost:

That sounds about right. I like to use Paint for BMPs too.
Show Just This Thread        Post Reply
label not displaying Comment from Srinath Nandyal @ 7/4/2013
Richard

I have "Notes field" with the caption "Notes". When I view it in Form view the word "Notes" does not display. What am I doing wrong?
Srinath


Reply from Richard Rost:

I assume that's your LABEL that's not displaying? Have you tried to move it? Did you set it's VISIBLE property to NO? Without seeing the database it's hard to tell.
Show Just This Thread        Post Reply
Grid lines and dots Comment from Lyn Mallet @ 6/28/2013
Hi Richard  When you are referring to grid, your example shows as dots, how do I change my grid to dots rather than grid in squares.  Thanks


Reply from Richard Rost:

See THIS post.
Show Just This Thread        Post Reply
Custom Sort Order Comment from Tracy Wilson @ 6/19/2013
Hi Rick, Lets say I want to sort Ranks (they are not alphabetical but have a hierarchy of their own).  I added a number to the front of them in the drop down list so I could sort them by number, but how do I DISPLAY them in the report WITHOUT the number being visible?


Reply from Richard Rost:

Use three fields. Have an ID, a SortOrder, and the RankName. In a query, you could create a concatenated field for your display value in the combo box but still only show the RankName in your report.

DisplayValue: SortOrder & ". " & RankName

Show Just This Thread        Post Reply
Record Source Comment from Martie Jacobs @ 6/4/2013
Beginner 6 Lesson 3: As I followed along in  creating EmployeeF, I realised that I mistakenly created a report. So I copied and pasted the design from EmployeeR into EmployeeF but now the EmployeeF does not have a table source. How would I select the source at this stage?


Reply from Richard Rost:

Open up the form properties and change the RecordSource to your table.
Show Just This Thread        Post Reply
Select all fields Comment from Mo Khan @ 5/3/2013
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 @ 4/23/2013
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 @ 4/22/2013
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:  Required
  Your Email:  NOT Public
  Subject:
  Comments:

 

Sorry about this step. It's just to keep the spam bots away:
  Verify: What is 6+8:
  
  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.

NOTE: If you don't leave your name and email address, DON'T expect a reply. I can't promise a personal reply to everyone who posts here. I TRY my best, but I cannot guarantee it. If you don't leave your real name and email address, I won't even bother. I usually just hit DELETE. -Richard

 

 

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

11/20/2018Microsoft Access Developer 12
8/25/2018NEW: Access Dev 9, 10, 11
8/25/2018Microsoft Access Developer 11
8/25/2018Microsoft Access Developer 10
8/25/2018Microsoft Access Developer 9
8/23/2018Access Dev 11 is ONLINE
8/17/2018Access Dev 10 is ONLINE
8/15/2018Access Tip: Search Form
8/15/2018Access Tip: Locked v. Enabled
8/15/2018Access Dev 9 is ONLINE
 

Learn
 
Accessindex
Excelindex
Wordindex
Windowsindex
PowerPointindex
Photoshopindex
Visual Basicindex
ASPindex
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
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
Gift CDs
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP