Open Directory

B

BW

Is there an easy way to have access open a folder on a network share?

Background-- I have an database that creates a folder on a network share for
each project that is created in it. This is a folder were users can store
draft documents and other data that isn't required in the database. I
would like to have a link on my form that will automatically open this
folder up.

Example - Project 1 for customer A the link should open up the folder.
\\fs1\projects\CustomerA\Project1

Thanks
BW
 
A

Allen Browne

Try:
FollowHyperlink "\\fs1\projects\CustomerA\Project1"

If you want more control over the switches for the Windows Explorer, you
could shell it like this:
Call Shell(environ("windir") & "\explorer.exe /e, /select, _
""\\fs1\projects\CustomerA\Project1""", vbNormalFocus)
 
B

BW

Thanks

works great

BW

Allen Browne said:
Try:
FollowHyperlink "\\fs1\projects\CustomerA\Project1"

If you want more control over the switches for the Windows Explorer, you
could shell it like this:
Call Shell(environ("windir") & "\explorer.exe /e, /select, _
""\\fs1\projects\CustomerA\Project1""", vbNormalFocus)
Click to expand...
 
E

eos

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George
 
E

eos

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George
 
E

eos

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George
 
Top