Insert picture using a command button

J

Jennie

I am creating a database that will require a picture to be inserted for each
record. I would like to have a command button on a form that will link to the
program that has the pictures and then have the picture inserted into a
designated area on the form. Is there any way to do that? Oh, yeah, and I am
using Access 97.
 
A

AndresW

Jennie

Save the image files to a folder on your harddrive.

In the RecordSource of your form include a field (say, pathImage) that
stores the filename and path to the image file. In the 'designated area' of
your form, you put an image control (in design view: Insert >> Picture)

On the OnCurrent event of the form, set the Picture property to the value of
pathImage

MyImageControl.Picture = pathImage

Andrew Wrigley
 
J

Jennie

Thanks!

AndresW said:
Jennie

Save the image files to a folder on your harddrive.

In the RecordSource of your form include a field (say, pathImage) that
stores the filename and path to the image file. In the 'designated area' of
your form, you put an image control (in design view: Insert >> Picture)

On the OnCurrent event of the form, set the Picture property to the value of
pathImage

MyImageControl.Picture = pathImage

Andrew Wrigley
Click to expand...
 
J

Jennie

One more question, is there a way to do it without going into design view? I
don't want every person using the database going into design view. If
possible, I would like to have a designated area in the form where the
picture is inserted and then a comman button that navigates how to get the
picture.
 
Top