Can Access create a new folder in windows?

[geeves1293]

Hi all,

Can Access create a new folder in windows?

Thanks

Geeves1293

 

[Steve Schapel]

Geeves,

In VBA you can use this method:

MkDir "C:\YourNewFolder"

 

[Tom Wickerath]

Hi Geeves,

Sure, just use something like this to create a folder named MyNewDir that is
child to your current folder:

MkDir CurrentProject.Path & "\MyNewDir"

You can download a working example from here:
http://www.seattleaccess.org/downloads.htm

See the download for October 2006, "Compilation of Tools". The example can
be found in the ProcError section of the RearrangePFA function, in the
basRearrange module.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________