Link to Stored Files

[Guest]

I have a table that assigns a number to documents as they come in, using auto
number. I would like to save those documents by the Autonumber. I can do
that myself by just naming the document the number and storing it in the
file. I would like a hyperlink or other link to open the file at a later
time. The name would be the same as the autonumber, but I don't know yet if
all the file extensions will be the same. For example, I could make them all
pdfs but it would be more convenient just to keep them in whatever format
they start out in.

The files are stored in a folder called "Database\FILES". The database is
stored in the Database Folder.

Any suggestions?

 

[John Vinson]

I have a table that assigns a number to documents as they come in, using auto
number. I would like to save those documents by the Autonumber. I can do
that myself by just naming the document the number and storing it in the
file. I would like a hyperlink or other link to open the file at a later
time. The name would be the same as the autonumber, but I don't know yet if
all the file extensions will be the same. For example, I could make them all
pdfs but it would be more convenient just to keep them in whatever format
they start out in.

The files are stored in a folder called "Database\FILES". The database is
stored in the Database Folder.

Any suggestions?

I'd really recommend NOT using Autonumbers for this purpose. They can
and will have gaps in the numbering, and if you should ever need to
Replicate your database they will become random - you'ld have files
named 31182416 and -1813442619 (note the - sign!)

That said, you can construct a Hyperlink field from its components and
store that hyperlink.

John W. Vinson[MVP]