By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,225 Members | 1,434 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,225 IT Pros & Developers. It's quick & easy.

Create Hyperlink based of a specific field in the same row

P: 4
How do I create Hyperlink based of a specific field in the same row?

In Excel it done like this:
=HYPERLINK("[http://www-hcr/Application/Pcr/App_GUI.aspx?PirPcrId=" &A273&"]", A273)

where the anything inside the " " is the value it's looking for in that particular cell.

How do I do a similar thing in Access?
Aug 20 '08 #1
Share this Question
Share on Google+
5 Replies


ADezii
Expert 5K+
P: 8,679
Assuming the Field's Data Type is Hyperlink, and a Field on a Form is Bound to this Hyperlink Field, the parallel functionality would be:
Expand|Select|Wrap|Line Numbers
  1. Me![txtHyperlink] = "The Bytes IT Community" & "#" & "HTTP://www.Bytes.com"
Aug 20 '08 #2

P: 4
Assuming the Field's Data Type is Hyperlink, and a Field on a Form is Bound to this Hyperlink Field, the parallel functionality would be:
Expand|Select|Wrap|Line Numbers
  1. Me![txtHyperlink] = "The Bytes IT Community" & "#" & "HTTP://www.Bytes.com"

Sounds like this function is only available in the "Forms' object.
I'd like to use it in the "Table" object.
I've specified the field as Hyperlink in the design view.
In the Table view: I right click on the hyperlink field and chose Edit Hyperlink.
A window pops up and below asks to insert the address where I type in:
http://www-hcr/Application/Pcr/App_GUI.aspx?PirPcrId=255

"255" on the end is variable that I would like for it to change automatically based on the neighbouring field on the left on the same row.

What do I type in there for it to "see" the value that's on the left field?
Aug 21 '08 #3

ADezii
Expert 5K+
P: 8,679
Sounds like this function is only available in the "Forms' object.
I'd like to use it in the "Table" object.
I've specified the field as Hyperlink in the design view.
In the Table view: I right click on the hyperlink field and chose Edit Hyperlink.
A window pops up and below asks to insert the address where I type in:
http://www-hcr/Application/Pcr/App_GUI.aspx?PirPcrId=255

"255" on the end is variable that I would like for it to change automatically based on the neighbouring field on the left on the same row.

What do I type in there for it to "see" the value that's on the left field?
You could not do this in the Table directly, you would need to run an Update Query to Update the Hyperlink Field depending on a value in the previous Field. Give me some concrete examples as in:
Expand|Select|Wrap|Line Numbers
  1. If <Previous Field> = 255 Then Hyperlink Field = http://www.Bytes.com
  2. If <Field Name> = 127 Then Hyperlink Field = http://www.MSN.com
  3. If <Field Name> = 255 Then Hyperlink Field = http://www.UnitedAirlines.com
  4. If <Field Name> = <any other value> Then Hyperlink Field = ???????????
  5. ...
Aug 21 '08 #4

P: 4
You could not do this in the Table directly, you would need to run an Update Query to Update the Hyperlink Field depending on a value in the previous Field. Give me some concrete examples as in:
Expand|Select|Wrap|Line Numbers
  1. If <Previous Field> = 255 Then Hyperlink Field = http://www.Bytes.com
  2. If <Field Name> = 127 Then Hyperlink Field = http://www.MSN.com
  3. If <Field Name> = 255 Then Hyperlink Field = http://www.UnitedAirlines.com
  4. If <Field Name> = <any other value> Then Hyperlink Field = ???????????
  5. ...
the link I gave you is from our intranet:
=HYPERLINK("[http://www-hcr/Application/Pcr/Investigate.aspx?PirPcrID=" &B284&"]", B284)

" &B284&"]" forms the search entry field on the intranet form to look up a particular number.

In my database this variable is looking for a value in the field B284 which is on the same row.

http://www-hcr/Application/Pcr/Investigate.aspx?PirPcrID=" forms the base hyperlink

what and where do I type in place of " &B284&"]" to see the value in B284 in Access?
Aug 25 '08 #5

ADezii
Expert 5K+
P: 8,679
the link I gave you is from our intranet:
=HYPERLINK("[http://www-hcr/Application/Pcr/Investigate.aspx?PirPcrID=" &B284&"]", B284)

" &B284&"]" forms the search entry field on the intranet form to look up a particular number.

In my database this variable is looking for a value in the field B284 which is on the same row.

http://www-hcr/Application/Pcr/Investigate.aspx?PirPcrID=" forms the base hyperlink

what and where do I type in place of " &B284&"]" to see the value in B284 in Access?
  1. What is your Table Name?
  2. What is the Name of the previous Field in the Table, that would complete the HyperLink Address?
  3. What is the Name of the Field containing the Base Hyperlink?
Aug 25 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.