Access 2000 - hyperlink location

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I make a hyperlink field point to a specific location on a network
server as default, so the use can just enter the filename eg scan001.pdf
rather than entering the whole path.

I am using Windows XP and Access 2000.

Many thanks in advance.
 
suppose you want to use as a default location "\\servername\databasefiles\"
and you have set it up so that you only store the filenames and not the
entire path. Then you'd use code such as the following to permit your users
to open the files.



dim strPath as string
strPath = "\\servername\databasefiles\"

Application.FollowHyperlink strPath & Me.FilenameControlNameOnYourForm
 
Back
Top