Access 07 unc path to file

[Dave]

Hello, I am running a access front end with a sql backend and i have a text
box I would like to double click and open the file related the data on the
current page.
the ID of the job file and the folder is the same.

for example \\server\share\jobfile\jobnumber is what I want to enter in the
text box, and double click property on the text box will open the
corresponding file on the share.

is there a way to open the folder this way? i have no idea how to use vba
and I am not very good at macros either aside from simple macros.

any assistance is apprecaited.

[Alex Dybenko]

Hi,
you can use shell("explorer \\server\share\jobfile\jobnumber") to open
folder in explorer
--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

Post by Dave
Hello, I am running a access front end with a sql backend and i have a text
box I would like to double click and open the file related the data on the
current page.
the ID of the job file and the folder is the same.
for example \\server\share\jobfile\jobnumber is what I want to enter in the
text box, and double click property on the text box will open the
corresponding file on the share.
is there a way to open the folder this way? i have no idea how to use vba
and I am not very good at macros either aside from simple macros.
any assistance is apprecaited.