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="...
theine
Last Activity: Sep 16 '08, 08:04 PM
Joined: Aug 20 '08
Location: Auckland
-
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"...Leave a comment:
-
I've set up to validate each cell entry to prevent duplicate entries. Tested it by typing in the repeated number and a unique number both gave me the correct results.
When I copy and paste into the validated cells, it doesn't validate the entries.
Why's this?Leave a comment:
-
Create Hyperlink based of a specific field in the same row
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?
No activity results to display
Leave a comment: