Automating routines in Access

[AJD10]

I'm used to developing code in Access with GUI with real users.
Now I need a few things done automatically
1. Check Folder A for files.
2. Move those files to Folder B.
3. Get a list of all those files (I used a quick batch)
4. Run functions to import files (set up in Modules)
5. run functions to export reports (set up in Modules)

We have a scheduler that can kick off Access. But, then what? How do I do #1 and #2? How do I make sure all these occur in sequence?

Thanks!

 

[jsteph]

You should look into FileSystemObject, this has what you need,
--Jim