Capture File Path into table field

[magmike]

I am trying to be able to relate documents to records, without using
the OLE Object Field. In creating a record for the document, I'd like
to be able to browse to the file, and somehow capture the path,
inserting it into a table field for later use.

I like using the OLE Object field to relate a record, as you can see a
thumbnail, double click on it, and it opens, but then I cannot use the
path data for other things, like sending emails with attachments.

Is there a way to do this?

Thanks in advance,
magmike

 

[Tom Wickerath]

Here is an image demo that you might find helpful....

http://www.accessmvp.com/TWickerath/downloads/ImageDemo.zip


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Ken Sheridan]

I've always found Bill Wilson's BrowseForFileClass class module efficient and
easy to use. You can get it from:


http://community.netscape.com/n/pfx...libraryMessages&webtag=ws-msdevapps&tid=22415


In fact you'll find it used in an 'images on demand' demo file of mine in
the same library:


http://community.netscape.com/n/pfx...libraryMessages&webtag=ws-msdevapps&tid=23913


Ken Sheridan
Stafford, England