Having User Link Pictures

[J. Trucking]

Hello All,

I have read some of the posts on this topic but am still unsure how I
accomplish the following. What I have is a heavy equipment database
that stores information about individual pieces of equipment. The
data is entered in and displayed on a form. I would like to have a
picture of each piece of equipment displayed on the individual forms.
I have read that linking the pictures are better than embedding them
(DB size) which makes sense. What I would like to have, is a pcture
window, a browse button, and a text box displaying the directory
location of the photo. So if a unit doesnt have the picture, the user
can take a picture, store it on the server, and then open the Unit's
form, hit the browse button, and upload the photo (or link to the
photo). I have looked around the newsgroup but didnt see any posts
which had the browse button so that the user could input the
directory. I hope someone could show me in the right direction for
this. My apologies if a topic already exists on this.

Thanks in advace,

John

 

[Douglas J. Steele]

For Browse For Folder capability, check
http://www.mvps.org/access/api/api0002.htm at "The Access Web".

For the standard Windows File Select dialog, check
http://www.mvps.org/access/api/api0001.htm

And I don't know what examples you've already seen, but check out the sample
imaging databases at http://accdevel.tripod.com

They illustrate three approaches to handling images in Access, and the
download includes an article discussing considerations in choosing an
approach. Two of the approaches do not use OLE Objects and, thus, avoid the
database bloat, and some other problems, associated with images in OLE
Objects.

If you are printing the images in reports, to avoid memory leakage, you
should also see MVP Stephen Lebans' http://www.lebans.com/printfailures.htm.
PrintFailure.zip is an Access97 MDB containing a report that fails during
the Access formatting process prior to being spooled to the Printer Driver.
This MDB also contains code showing how to convert the contents of the Image
control to a Bitmap file prior to printing. This helps alleviate the "Out of
Memory" error that can popup when printing image intensive reports.