Using the File Browser popup from within Access

[SBendBuckeye]

When you click the Database open button on the toolbar in Access it pops up a file browser. I would like to use that and set a default path first.

Does anyone know the properties or enumerated constant to use to get at the Access default subdirectory for new files, etc?

Thanks in advance for any help!

 

[MikeLoon]

On the Tools menu, click Options, and then click the General tab.


In the Default database folder box, type the path for the folder you want to display as the default working folder.
For example, type c:\work.

 

[SBendBuckeye]

Thanks, is there a way to reference that via VBA?

 

[mp9]

You can use CurDir to return the current working directory (which is what you default to when you click the database open button). Also, you can use ChDir to change the current working directory, so this is how you can set the default path, i.e

ChDir "C:\Temp"

HTH.

http://www22.brinkster.com/accessory/