browse dialog

[tray]

I have a employee type form, where pictures of the employees are linked to a
subfolder called images.
The form has a text box (FileLocation) to enter the location of the image,
for example, the user will enter:
c:\employee\images\DoeJohn.jpg into the text box.

The user will take a picture from a floppy, rename it (from the default
numerical filename the digital camera uses)
and put it in the c:\employee\images\ folder, and then enter the location as
described above.

The user has a hard time working with windows explorer. I thought it was
fairly easy myself, but they want it
easier.

I'm looking for ideas on how to perhaps put a Browse button on the form,
which will open to the images folder,
then they can select the file they want and have it appear in the
FileLocation box.

Anyway, any ideas on how I can streamline/simplify the process would be
appreciated.

Thanks,Tray

 

[tray]

by the way, I first tried an OLE field, which worked great for the user. I
thought I could get away with the bloat because I only had 150-200 records.

But I found out that the people who advise against this know what they're
talking about. My DB grew to 467MB! It was very sluggish also, of course.
Just for comparasion, after exporting all pictures to the \images folder,
and only having a link text field, the DB is now only approx 7mb, including
all forms.

It probably grew so large because the user was deleting and not compacting.
I trid to repair/compact once I saw how large it was, but Access choked
everytime. Finally gave up and just exported what I could.

Tray