Linking documents to a record

B

bvdahl

Hello,

I would like to save documents on the server and link them to the
appropriate record on my form. What is the best way of doing this? There can
be several different files linked to a single record.

If I could have a hyperlink at the form that opened the file I wanted to
look at, that would be ideal.

Baard
 
B

bvdahl

Well,

I was thinking more along the lines of a button opening a file browser to
let the user select a file to add to the record. It should also be possible
to add more than one file to a single record.

Maybe I am asking too much of access?

Baard
 
K

kingston via AccessMonster.com

If you create a hyperlink field, the user can drag and drop the file into the
field and Access will store the file location. If you want to store more
than one file, you'll have to create more fields or add a new table with a
one-to-many relationship to the single record.
Well,

I was thinking more along the lines of a button opening a file browser to
let the user select a file to add to the record. It should also be possible
to add more than one file to a single record.

Maybe I am asking too much of access?

Baard
Create a field that holds the hyperlink (e.g. \\Server\Folder\File.txt or
http://www.accessmonster.com) and put it in the form or use the command:
Click to expand...
[quoted text clipped - 11 lines]
Click to expand...
 
B

bvdahl

That is just perfect.

Thank you for taking the time

Baard

kingston via AccessMonster.com said:
If you create a hyperlink field, the user can drag and drop the file into the
field and Access will store the file location. If you want to store more
than one file, you'll have to create more fields or add a new table with a
one-to-many relationship to the single record.
Well,

I was thinking more along the lines of a button opening a file browser to
let the user select a file to add to the record. It should also be possible
to add more than one file to a single record.

Maybe I am asking too much of access?

Baard
Create a field that holds the hyperlink (e.g. \\Server\Folder\File.txt or
http://www.accessmonster.com) and put it in the form or use the command:
Click to expand...
[quoted text clipped - 11 lines]
Baard
Click to expand...
Click to expand...
Click to expand...
 
Top