Linked Pictures

[ASherbuck]

Hello,

Here's the dilemma:

On a form designated for data entry, FrmDataEntry, I would like the user to be able to select an image from a folder within the DBs directory. I've been looking at the mvps write up on it, I snagged that link from a post here I found through searching, but I really don't understand it.

I am to create a module with that code in it? and then how do I make use of it on the form?

The only goal is to have a quick way for whoever is doing data entry to quickly locate and save the C:\System\Images link in a table field so it can be used later. Ideally a user clicks a browse button, selects the image and the location on the HD is placed in the text box. They save their record and move onto another.

I currently have it set up so they only have to put the image name in the text box and when they save the record it automatically adds the C:\System . . . to the beginning of what they put in the box. It's not as flexible as I would like and of course leaves lots of room for user error.

Any ideas how I can make better use of it or any help explaining that code?

 

[wiklendt]

yup. i can help.

i can't remember where i found this, but i reverse-engineered where everything went and adapted it to my own needs and now it works like a dream. watch out - the only thing that's not ideal about this is that the linked pictures are referenced abolutely (e.g., C:/Documents and Settings/User/My Documents/MyDatabaseProject/images/, rather than relatively (e.g, ./images/)

but that doesn't worry me right now - and this was otherwise SUCH an elegant way to handle images on my ddb... as far as i can remember it didn't require too much fiddling on my part to work in my ddb - it was almost as easy as copy/paste.

 

[ASherbuck]

This is really good. I can definately get this to work well. Thank you very much