JPEG or GIF images in Access?

[noob23]

Is it possible to insert/view JPEG or GIF images in a form? Or do they have to be BMP images?

I have tons of images that I need to put into an Access 2000 database, and then each image must be displayed on it's corresponding record's form. All of the images are either JPEG or GIF. Can I use them, or do I need to convert them to BMP?

Please help! Thank you.

 

[Oldsoftboss]

Download the sample db at http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=46329
Should do what you want
Dave

 

[noob23]

Thanks, but I need to have the picture on the Form itself, not on a Report. It is a product database and each record/item has it's own picture. When the user navigates from record to record, each form should display the image that corresponds to the item/record.

I hope I am being clear enough. Do you understand what I'm trying to say?

Also, I'm not sure if I can do this with JPEGs or GIF, or if it can only be done with BMPs.

Please help. Thank you.

 

[John.Woody]

Use the Insert Image control from within the toolbox. You can then use either Jpegs or Gifs. I store the pics in a folder and link them to the form by setting the path and picture name as the form opens i.e.

Forms!F_MemberPicture!image1.Picture = "C:\Mi_Pics\image1.jpg"

hth
John

 

[noob23]

Yes, I know how to do it that way, but this has to be done dynamically. The user will simply insert the name of the image into a field, and then the picture will be displayed on the form corresponding to that name. Know what I mean? This has to be VERY easy for the users.

Any suggestions?

 

[John.Woody]

If the images are all in one folder it makes life easier. Put the image control on your form and update the image file in the On Current event of the form. I make a button visible or not according to whether the record has an image, this button opens a second form loading the image. This speeds up the opening of the main form.

hth
John

 

[noob23]

Thank you, but I'm very new to this. I don't really understand how to do what you are saying. Can you offer any more detailed explanation? Step by step? I'm learning this as I go along.

Thanks.

 

[Oldsoftboss]

Did you download the Db I indicated ?
It is a form, has a button to open the windows select file dialog,making it very simple for your user to select the file without the chance of spelling mistakes, able to choose many formats, stores the file name in a table, updates as you scroll through the records...
Seems to do what you want ???

I have included it again here for you to have a look at.
I added the zoom in and zoom out buttons to show what else can be done. If you dont need them the image can be placed anywhere on your form and not a subform
Good Luck.
Dave

 

[John.Woody]

Slightly different Slant.

PicLocations holds the path to all of the pictures

Members Holds member information
MemberPics Holds the Picture Name.

The Photo button only becomes visible if the member has a photo stored. Clicking the photo button then loads the picture form and displays the picture.

HTH
John

 

[noob23]

Thanks guys! I'll try these out and let you know if they work. I sure hope so!!

 

[Oldsoftboss]

noob23

Good luck, if you need anything different, just ask!
Dave