"Relative" Hyperlink

G

Guest

I want to automate a hyperlink to a folder that contains scanned patient lab
test image files; t:\scans\"patient record ID #". [lab tests] property is
set to a hyperlink with the default value of t:\scans\. The file names are
the patient record ID #'s so I want the hyperlink field to give an address
based on the that record's patient ID #. I can get it to show as an
expression using ="t:\scans\"&[recordID] but I can't get it to work as a
hyperlink. I really need your help and it will be appreciated.
 
A

Arvin Meyer

Dan Sweetwood said:
I want to automate a hyperlink to a folder that contains scanned patient lab
test image files; t:\scans\"patient record ID #". [lab tests] property is
set to a hyperlink with the default value of t:\scans\. The file names are
the patient record ID #'s so I want the hyperlink field to give an address
based on the that record's patient ID #. I can get it to show as an
expression using ="t:\scans\"&[recordID] but I can't get it to work as a
hyperlink. I really need your help and it will be appreciated.
Click to expand...

Labels also have a hyperlink property so you don't need to use an actual
hyperlink. Here's some code:

Me.Label1.HyperlinkAddress = "t:\scans\" & Me.Text2
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
G

Guest

Arvin,

Thank you very much! I will get right on it.

Arvin Meyer said:
Dan Sweetwood said:
I want to automate a hyperlink to a folder that contains scanned patient lab
test image files; t:\scans\"patient record ID #". [lab tests] property is
set to a hyperlink with the default value of t:\scans\. The file names are
the patient record ID #'s so I want the hyperlink field to give an address
based on the that record's patient ID #. I can get it to show as an
expression using ="t:\scans\"&[recordID] but I can't get it to work as a
hyperlink. I really need your help and it will be appreciated.
Click to expand...

Labels also have a hyperlink property so you don't need to use an actual
hyperlink. Here's some code:

Me.Label1.HyperlinkAddress = "t:\scans\" & Me.Text2
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Same record/Primary key in multiple tables 0
Best Way to Scan 2
Adding a field to a subquery 1
Link information in one table to another table 2
Hyperlink Image 3
How to Partially Populate New Record 1
Problem with Subquery 2
need help linking tables 2

Top