Display bound picture in a one-page-per-record form. Newbie questi

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

Guest

I'm an oldie to access and very new to access programming

I have the file name of pictures stored in a field, and then a
"PicturePathAndFile" expression in q query that prefixes the file name with
it's path.
I have already been successful displaying the pictures in a report using the
following event proceudure upon the detail section "on Format" event.

Me.imageBoxName.picture = me.picturepathandfile

But having trouble guessing how to do the same in a one-page-per-record
form.

I tried using the above "on Enter" form event but that didn't work.
(returned "invalid outside procedure" error.

Any help on the best way to do this or what I did wron would be appreciated.

Fred
 
Try creating a table if pictures with two (or more) columns. One a text
field to hold the file name and one an Ole field. Create a form and paste the
images and file names in - you can do this automatically but its a
pain/interesting excercise.

The extra columns would be foreign keys to other data in your report. Then
add the new table to your report. Realistically you would want to have the
images in a seperate database linked to your report database because it will
get very large quickly and is more likely to get corrupted. Large binaries
and databases are not usually a good combination.
 
Back
Top