Images in forms

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

Guest

Hello all

I have a database form which I would like the end user to be able to insert
2 graphic files. The end user however, does not have access to design view
so I would need to have them to click a button and browse to the graphic in
question.

Is this possible?

I've searched through help files and created an OLE field in a table, but
now don't know what to do with it...

Any help would be greatly appreciated.

Merry Christmas
 
Follow this link to get the universally accepted way for an Access
application to browse for a file.
http://www.mvps.org/access/api/api0001.htm

I would be very hesitant however to store that graphics in an OLE field in
an Access table. My experience is that this will lead to significant
database bloat, and eventually database corruption. Instead I would move
the graphic file(s) into a image directory on the server and change the
files name to something that you can guarantee is unique. I typically use
the current Date Time for the new filename and keep the old file extension.
Then in the database you simply store the new filename. If it is necessary
you could store the old filename and the location that it was copied from
too.
 
Back
Top