files directory

[Dannyc989]

hey folks, could someone please provide me with a bit of code to combat the following...

I have a textbox on a form, and I want this to be filled with a directory to a folder which will contain more folders and files related to this folder... I just want a simple browse and string save.

Also if possible could I have a similar thing for opening the folder from clicking another button please..

Many Thanks

 

[llkhoutx]

Search for the "common dialog." That's what you want, it's simpler with each newer version of Access.

 

[smig]

The common dialog is an API to system routines.

 

[llkhoutx]

That doesn't matter. The code for referencing the API is included with the common dialog code, which can be modified to fit a user's needs. Dannyc989, check it out.

 

[Dannyc989]

just being a complete novice here... I have had a look and just want to confirm a couple of things. .

I want to save the directory path for a specfic folder and not a document will this still work???

 

[llkhoutx]

You can modify the arguments such that you pick only a folder.

 

[smig]

That doesn't matter. The code for referencing the API is included with the common dialog code, which can be modified to fit a user's needs. Dannyc989, check it out.

I know it can be used in Access.
I use it
Just wanted to clarify some more about it.