Hyperlinks entered by user

[DorisL]

I would like to create a form that the users could enter a file name of a pdf file stored on their network. When entered it would then become a hyperlink for that record. The pdfs are stored in the same directory so all that would change would be the file names for new records.

Since the "Insert hyperlink" command is only available in the design view, is this possible from the user input?

 

[Carol]

Go into your table on which you want to store the file and create a new field with a Data Type of Hyperlink.

You can then call this field from within your form. An easy way I have found to use this is to already have the Directory setup in the field by using the fields default value.

Please remember that you must use the full path to the file.

 

[DorisL]

Carol,
Thanks for your reply.
I thought about using the default value for the field but when the user types in the new file name, won't that overwrite the path?

Can I use "Path" & [Enter file name]& ".pdf" in the default value? Or do I have to use a separate input box?

Sorry about being so dense. I'm new at this stuff.
Thanks

 

[Carol]

I usually put the full path in of a dummy file stating "No PDF Available". This then becomes the default for all the files and is stored in the same directory where all the actual files will be stored. As the files are added, the users can just type-over over the actual file name, but not the full path, which at times can be long (especially if it is residing on a server).

[This message has been edited by Carol (edited 07-24-2001).]

 

[DorisL]

Thanks a lot. I'll give it a try!