unc path via text box doubleclick

[dmhwarfab]

I have a access07 db with a sql 05 be. I would like to be able to open a network share using the unc path (\\server\share\file) when I doubleclick on the text box in which the path is stored. I am not a programmer, just anetwork guy who can make some simple databases. any help would be appreciated.

 

[KenHigg]

I wonder if you could put that in a shell() function?

 

[CitizenKane]

The best option here is to set the property 'Is Hyperlink = yes" which means if there is a UNC path in the text box you only need to click it once to open the folder. You will find this property if you right click the text box and select properties, on the format tab scroll down to the bottom and make sure this property says yes

Hope This Helps

 

[boblarson]

The other way is to use

FollowHyperlink Me.YourTextBoxNameHere

in the event you want.

 

[dmhwarfab]

It Works! thanks folks!

 

[EddiRae]

Bob, I have similar question, but I want to find a document and place a hyperlink in a textbox and when clicking on the hyperlink in the textbox, it opens the document.

What would be the easiest?