Pictures in Access

rubenhu

New member
Local time
Today, 12:16
Joined
Jun 18, 2007
Messages
2
I have Access 2003 and have trying for some time to insert pictures. I have followed the instructions step by step as outlined in the BIBLE and nothing. I recently acquired a new computer and the problems still persists. Can anyone help.
 
What is the issue? I just quickly selected an Image Control from the toolbox, dragged it onto a form, randomly picked an image, and it was fine. You're going to have to be a lot more specific.
 
That is exactly what I do, however the picture does not shows. I have also tried several formats and still nothing.
 
Can you post an example DB where you are trying to do this? Since Image Control is a basic control, there should be no issue with it.
 
The ONLY things that come to mind are:

1. The image is in a format you didn't choose to support when you first installed OFFICE.

2. You are somehow not defining the .Picture property with the file name of the image - if your image control is not set for embedded. Search this forum for "Pictures" and "Images" and "Image Controls" because this topic has been addressed many times.
 
I believe I have the same problem that you are having. For some reason I can't use jpegs of giffs. Bitmaps seem to be the ony thing that will import into my databases. I'm not sure if thats a setting or something, but I just use mspaint to convert my images to bmp format.
 
Motley, re-install Office and choose the option that lets you change the features. You need to install the picture handlers for .jpg and .gif formats. You can choose to install (or not install) just about every kind of converter you normally need with MSO. I'm thinking you didn't choose that particular pair of image options.

ruben, if you have an image in a separate file, try this.

Open the form in design mode. Open the image control properties. Load the name of the file to the .Picture property. Set the .Embedded to FALSE - you want to link in this test I am describing. In the picture's other properties, select one that maintains aspect ratio but also allows resizing. Switch the form to form view. As long as you don't have something in the Form_Current routine that would wipe out the .Picture, you should be able to see the picture with the file name you just loaded. Now, this is a test to see if you have a more serious problem or if it was just a bad set of options.

Oh... addendum. Make sure that the control is neither disabled nor locked. Look at every property of the control. If you don't understand it, use the F1 key get the question-mark help cursor and click on the name of the property that is confusing you.
 
Good call Doc. I'll have to call our IT guys. They lock our PC's down. Thanks for the info....Gregg
 
Just by way of amplification, you can use the MS Office disk to install, remove, repair, or change the features of your office installation. Four choices. You want the last one.
 

Users who are viewing this thread

Back
Top Bottom