unique link to a unique record in a form?

D

Debbie S.

I know how to insert a hypertext link in a form, but how do I do that such
that it links to a unique file for each individual record in the form, rather
than one link for the entire form? Thanks in advance. -Debbie
 
J

Jerry Whittle

You need a hyperlink field in the table used as the record source for the
form. Then you need a text box on the form for the hyperlink field.
 
J

Jeff Boyce

Debbie

I can't tell from your description whether you have inserted "a hypertext
link in a form" (i.e., hardcoded a single link for the form) or have a
hypertext data type field in a table that you are displaying in the form.
If the latter, you could simply add a hypertext link in each record.

You may be encountering an issue with Continuous Forms vs. Single Forms...
but you didn't mention which of these you are using.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
D

Debbie S.

Right, but how I do tell the text box where to choose the file from for each
record?
 
D

Debbie S.

What I am trying to do is put a hyperlink into the form such that in each
individual record, the hyperlink will go to a file (such as a pdf or word
document) that is unique to that record. At this point I understand that I
need to put field in the table that is the record source for the form and
call it something like "file" or whatever I want to call it, and make it a
hyperlink data field. What I don't know how to do is make the hyperlink data
field link to the files I want them to link to for each individual record.
 
J

Jerry Whittle

You will have to insert the appropriate hyperlink into the hyperlink field.
In Access 2003 at the form or table, right click on the hyperlink field. Go
down to Hyperlink then select Edit Hyperlink. Follow the prompts to find the
file.
 
D

Debbie S.

I figured it out. Thank you for your help!

Jerry Whittle said:
You will have to insert the appropriate hyperlink into the hyperlink field.
In Access 2003 at the form or table, right click on the hyperlink field. Go
down to Hyperlink then select Edit Hyperlink. Follow the prompts to find the
file.
Click to expand...
 
Top