
March 20th, 2004, 05:59 PM
|
|
Registered User
|
|
Join Date: Mar 2004
Posts: 12
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Hyperlink dynamically
This is what I need to do, and have no idea how its done.
Hope someone can help?
"I need to create a hyper link dynamically (selecting a part of the hyperlink string from a field in the Access DB) within Access and put it on a form or report. What is the best appraoch for this??
So the steps are: select a field from a table and then concatenate a folder name (just a hardcoded string) with that (just retrieved) field. The result of the concatenation will be my hyperlink (looks something like this: "c:\test\bill.pdf"). And then this link will be shown in the form. When running it and clicking on it, it should popup the pdf
This is urgent.
Cheers
|