[AccessD] Running Dir from Batch file in MSAccess

James Button jamesbutton at blueyonder.co.uk
Sun Mar 12 17:18:16 CDT 2017


I'll add some notes to the bat file usage - or maybe .cmd 

Firstly  you can setup a single bat (or .cmd) file and feed it parameters on the
call

As in a command  dir %1 %2 >%3
And the call will be "ee.bat ""folder"" ""options"" ""outputfile"""

Secondly - remember that is a bat process - so you will need to have a
sufficient delay or wait process to allow it to work

Thirdly note the doubled "" within the outer bounding " pair
Foldernames  etc. that contain spaces need to be bounded

And - finally, look at the FOR command and it's options 

JimB 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jack
drawbridge
Sent: Sunday, March 12, 2017 8:09 PM
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Subject: [AccessD] Running Dir from Batch file in MSAccess

Jim,

I was trying to respond and say I agree that its a fast method. However,
the person I'm trying to help is not familiar with vba.
I got a flag on your email saying it is marked as spam??
So I'm starting again.

I am not  experienced with Bat file from Access. I have had no luck with
google nor the forums I participate in.

I was trying to get a list of image files (jpg) and felt a simple Access
form with a Shell cmd would hide most everything.

But as always Simple has various meanings!!!

jack
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list