display JPEG file on an access form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to create a field on an access form that is linked to a jpeg
file in a directory on my disk. When I select that record, I want Access to
automatically display the jpeg file in my form.

Any help would be appreciated. Is there a good book that explains how to to
this. I have looked at several and none of them really explain how to do
this.

Thanks
 
hi,
forms have a picture property built in. if you enter the
jpeg's file path into the picture property, this will set
the jpeg as the forms background.
if you don't want the jpeg as background on the form,
then use the immage control from the toolbox. set the
image control's picture property to the jpeg's file path.
the above two methods will display the jpeg until you
change the file path.
i don't quite understand what you mean by "when i select
that record...".
Sounds like you want to associate different jpeg's with
different records. if that is the case, you would have to
put the jpeg's file path in the table with the record.
When you call the record to the form, you would use code
to change the image control's picture property to the new
file path.
 
Go to the table design view. Add the desired field name, the properties would
be set to OLE object. Now go the form add the field you just created. Now on
the appropriate record use the insert option from the top menu and insert a
"Object" change to from file, browse find file and select. Do not forget to
check the "link to box" this way whenever you change the file the field will
auto update.

Discussion groups are best. I must have read a dozen books, but they are not
so good, if you do not ask the right questions. Good luck

Steve
 
Back
Top