473,238 Members | 1,939 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,238 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 4538
"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Tony Clarke | last post by:
Hi, I'm trying to write a system thats used for about 50 clients that uses html forms and php to log details. The problem is that when a client loads the form page it's given a value which is...
1
by: schuderfloss | last post by:
I have a unique ID field in a table of products. And rather than store the full hyperlink/URL address I decided just to store the unique ID. I would like to have a button in a form that contains a...
0
by: mstanley71 | last post by:
Hi All, I have a problem, I'm using Access 2002 SP3. and am trying to use a button on each form to link back to a hyperlink on a table based on a combo box selection on the same form record..ie...
7
by: Bob Sanderson | last post by:
I have a php page which contains the code: echo "<tr>"; echo "<th>$JobNumber</th>"; echo "<td>$Description</td>"; echo "<td>$NSN</td>"; echo "<td>$Manufacturer</td>"; echo...
0
by: steve | last post by:
Hi all, Come across a situation I cannot figure how to work out. Im relatively new to access but have looked around and tried everything to my knowledge. I've developed an application whereby...
3
mnemosyne
by: mnemosyne | last post by:
hi i'm trying to figure out how to have a hypertext link in a form use the information entered from a separate field in order to link to a word document EXAMPLE Link to Report is a hyperlink that...
22
by: mforema | last post by:
Hey Everybody, I have an URGENT REQUEST (I need a reply within 24 hours, or I lose my job) I need help writing vba code for a command button. I want this button to locate a hyperlink in a table (the...
5
LAD
by: LAD | last post by:
Using Access 2003 on Windows 2000. My Skill Level: Med Low (Some VBA, okay with Access) Form: Single View - based on Query of single Table to sort by field. Application: Dealers email 'contract...
1
KevinADC
by: KevinADC | last post by:
Note: You may skip to the end of the article if all you want is the perl code. Introduction Many websites have a form or a link you can use to download a file. You click a form button or click...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

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.