Can I access the file system?

Bob Pierce · April 4th, 2007, 10:26 AM

I've successfully got an Access VBA system working for my design business that handles job details, time recording, purchase orders etc. It works a treat but with one limitation - although I can create a new job record with one click, I can't create the job folder and subfolders in the Windows file system that each job needs. Is this possible with Acess VBA?

robzyc · April 4th, 2007, 10:42 AM

Certainly is,

You need to reference the "Microsoft Scripting Runtime" (under Tools > References) in VBA.

This allows you to create a "FileSystemObject".

For example, to create a folder:

Code:

Dim fso as New FileSystemObject
fso.CreateFolder "C:\My New Folder"
fso.CreateFolder "C:\My New Folder\A Subfolder"

I hope this helps, if you get stuck then give me a shout.

Best Regards,
Rob

Bob Pierce · April 4th, 2007, 10:59 AM

That's great, thanks. One question, my available references are:
Microsoft Script Control 1.0
Microsoft Scripting Runtime
Microsoft Scriptlet Library

Which should I choose?

robzyc · April 4th, 2007, 11:02 AM

Choose the "Microsoft Scripting Runtime".

Bob Pierce · April 4th, 2007, 11:16 AM

Thanks Rob. This opens up exciting new avenues!

robzyc · April 4th, 2007, 11:19 AM

No problem, good to hear.

Just be EXTREMELY careful with the "DeleteFile" method!