472,110 Members | 2,289 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,110 software developers and data experts.

How to make unique hyperlink URL for each form record?

I am looking to set up a hyperlink control on a form to retrieve letters
that correspond to a record on a form. That is, there may be 100 form
records, and I would like each of those form records to have a hyperlink
button or control on it. that when pushed, pulls up the unique Word document
associated with that form record. In this example, there would 100 unique
letters associated with 100 unique form records. I tried working with this,
but can not get the control to access UNIQUE letters. I am using Access
2000.

Thank you,

- Phil
Nov 13 '05 #1
3 4405
"Phil" <p.*****@comcast.net> wrote in message news:<cpYCc.110491$HG.67523@attbi_s53>...
I am looking to set up a hyperlink control on a form to retrieve letters
that correspond to a record on a form. That is, there may be 100 form
records, and I would like each of those form records to have a hyperlink
button or control on it. that when pushed, pulls up the unique Word document
associated with that form record. In this example, there would 100 unique
letters associated with 100 unique form records. I tried working with this,
but can not get the control to access UNIQUE letters. I am using Access
2000.

Thank you,

- Phil


So you have a field in your table that holds the path to the letter.
Then you just format that field in your form as a hyperlink. What do
you mean "unique" letters? You're getting the same one? Sounds like
you're putting a label or unbound field on your form instead of a
bound field.
Nov 13 '05 #2
Thank you. I am quite new at this, but after adding a column in a table for
the URLs, it worked OK. I thought I could just put something like "View
Letter" on the form, and make that a pointer directly to a document I have
in Word. It appears I must have a list of URLs in an Access table.

If there were 100 records, I would go through 100 occurrences of each form
when it displays each record. What I wanted was that when you clicked on
"View Letter", it would pull up the correct letter for that record. This
means a unique URL or file location for each Access record. It is slow to
enter the URLs in the table, but this is the only way I know how to make
this work.

- Phil

"Pieter Linden" <pi********@hotmail.com> wrote in message
news:bf**************************@posting.google.c om...
"Phil" <p.*****@comcast.net> wrote in message

news:<cpYCc.110491$HG.67523@attbi_s53>...
I am looking to set up a hyperlink control on a form to retrieve letters
that correspond to a record on a form. That is, there may be 100 form
records, and I would like each of those form records to have a hyperlink
button or control on it. that when pushed, pulls up the unique Word document associated with that form record. In this example, there would 100 unique letters associated with 100 unique form records. I tried working with this, but can not get the control to access UNIQUE letters. I am using Access
2000.

Thank you,

- Phil


So you have a field in your table that holds the path to the letter.
Then you just format that field in your form as a hyperlink. What do
you mean "unique" letters? You're getting the same one? Sounds like
you're putting a label or unbound field on your form instead of a
bound field.

Nov 13 '05 #3
"Phil" <p.*****@comcast.net> wrote in message news:<43jDc.113757$eu.51359@attbi_s02>...
Thank you. I am quite new at this, but after adding a column in a table for
the URLs, it worked OK. I thought I could just put something like "View
Letter" on the form, and make that a pointer directly to a document I have
in Word. It appears I must have a list of URLs in an Access table.

If there were 100 records, I would go through 100 occurrences of each form
when it displays each record. What I wanted was that when you clicked on
"View Letter", it would pull up the correct letter for that record. This
means a unique URL or file location for each Access record. It is slow to
enter the URLs in the table, but this is the only way I know how to make
this work.

- Phil


One way to find the letters... Use the OpenFile API from
http://www.mvps.org/access/api/api0001.htm
to prompt you to browse for/"open" the file, and then just grab the
path to the file, and store that in your database. If all the files
are in the same location it should be pretty easy.
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Tony Clarke | last post: by
7 posts views Thread by Bob Sanderson | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.