Create Hyperlink based of a specific field in the same row

[theine]

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?Pi rPcrId=" &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?

[ADezii]

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:

Me![txtHyperlink] = "The Bytes IT Community" & "#" & "HTTP://www.Bytes.com"

[theine]

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:

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?Pi rPcrId=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?

[ADezii]

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?Pi rPcrId=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:

If <Previous Field> = 255 Then Hyperlink Field = http://www.Bytes.com
If <Field Name> = 127 Then Hyperlink Field = http://www.MSN.com
If <Field Name> = 255 Then Hyperlink Field = http://www.UnitedAirlines.com
If <Field Name> = <any other value> Then Hyperlink Field = ???????????
...

[theine]

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:

If <Previous Field> = 255 Then Hyperlink Field = http://www.Bytes.com
If <Field Name> = 127 Then Hyperlink Field = http://www.MSN.com
If <Field Name> = 255 Then Hyperlink Field = http://www.UnitedAirlines.com
If <Field Name> = <any other value> Then Hyperlink Field = ???????????
...

the link I gave you is from our intranet:
=HYPERLINK("[http://www-hcr/Application/Pcr/Investigate.asp x?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.asp x?PirPcrID=" forms the base hyperlink

what and where do I type in place of " &B284&"]" to see the value in B284 in Access?

[ADezii]

the link I gave you is from our intranet:
=HYPERLINK("[http://www-hcr/Application/Pcr/Investigate.asp x?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.asp x?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?