Software

Ask something
Discussion Locked

Pictures in Access

0 helpful
3 replies

by gcheels 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I would like to put pictures in a access table and view them on a form. There will be a picture for each records (like an employee picture for each employee record). Is there an easier way to do this other than clicking on Insert-Object from the menu, then browse for the file. I would like to bypass the menu options and go directly to the dialog box (and have it automatically point to the folder the images are stored in)...ie, I also don't want to have to specify what type of pictures it is (MS Powerpoint, MS Excel, MS Photo Editor, etc). I'm thinking that a button below the image would work fine. Thanks.

3 replies

by illilli

Create a form with a picture object on it. Create a table with fields such as PictureID, Picture Name and Picture FilePath. Picture FilePath should contain the full file path to the picture.

Create another form with a combo box that has a query that gets the PictureID and Picture Name.

In this combo box's After_Update:

1. Find the full path and file name.
2. Open the form with the picture object in it.
3. Set the picture object to the file path of your picture.

This is a brief overview of how to view pictures with a form. I'm pressed for time now, but I can give you a more detailed example if you need it later.

This discussion is closed to new replies.