Choose File, Store Address of File

[Sal]

I want to have a button that opens a 'file' window (similar to when you click
'open' in any MS application), but when you double-click on a file the
ADDRESS of the file is stored in a field (ie hyperlink?).

What I'm trying to achieve is finding an image to attach to a record but not
embedding the image (due to space) but storing the address instead.

 

[Douglas J Steele]

http://www.mvps.org/access/api/api0001.htm at "The Access Web" is the best
way to invoke the File Open dialogue.

 

[Sal]

Thanks, that half helps. I was looking to store the address of the file in a
field rather than open the file... it there a way of doing that?

 

[Rick Brandt]

Thanks, that half helps. I was looking to store the address of the
file in a field rather than open the file... it there a way of doing
that?

That code will not "open the file". It will return to your code the path and
file name that is selected. Your code is then free to do with that whatever you
want. In Windows that dialog is most often used to open a file so it is
referred to as the "Open File Dialog", but it certainly can be used for lots of
other things.

 

[Sal]

Great, thank you!

That code will not "open the file". It will return to your code the path and
file name that is selected. Your code is then free to do with that whatever you
want. In Windows that dialog is most often used to open a file so it is
referred to as the "Open File Dialog", but it certainly can be used for lots of
other things.