Access 2000 - hyperlink location

R

Richard

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.
 
D

Daniel

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
 
Top