Open an external folder using access 2000

[Breeves22]

Hi all

I have no idea if this is possible and doing a general search on the internet yeilded no results so i thought i would ask here.

In the database i am creating there will be a need to open up a folder stored on the computer to edit a file contained inside. This file is updated on a weekly basis and when this happens a new file is created so it is not practical to use a command that opens directly to the file. Is it possible to use a command button on access to open a folder in an external window

[TheSmileyCoder]

Simplest solution is:

application.FollowHyperlink ("C:\myFolder\")

You can also use access to open a filebrowser with a default starting location (your folder), and then select the file you wish to import.

[Breeves22]

Thankyou for that. Problem is now solved

:)