Visual Basic Code to open a folder in Code builder

E

Ebitari

am running some code in an Access Database that I am building. I need a
code that will open a folder from a form. I am currently using the following
code in the 'On Click' Event Procedure in the code builder:

Application.FollowHyperlink "O:\EWGPP\NA-233 Task Order & Invoice Tracking\"
& "Invoice" & " " & [Invoice Number], True

This works and opens the folder, however, when I copy a file to the folder
it does not show up until I go out of the folder and go back in. It does not
seem to be opening the folder with the right settings because I can't see
files immediately when I copy them to the opened folder.

Is there a better Visual Basic code to use to open a folder?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top