[AccessD] Running Dir from Batch file in MS Access

[Jim Dettman]

Jack, 

I have a "waitwhilerunning" function that I can share.    All it needs is a windows handle,  so you can shell to a batch file if you want to.

 Would have posted earlier, but I'm not in the office till tomorrow and could not post it till then.

 Also have examples of calling batch file along the lines of what  Jim B said

Jim

Sent from my iPhone

> On Mar 12, 2017, at 7:30 PM, jack drawbridge <jackandpat.d at gmail.com> wrote:
> 
> Hi Guys,
> 
> Some success. I found a function (LaunchApp32) at Access world forums
> https://access-programmers.co.uk/forums/showpost.php?p=533820&postcount=6
> 
> It involves some API declarations, but runs my bat file. The big difference
> seems to be waiting for processes to finish.
> 
> At the moment, I'm passed this issue.
> 
> Thanks for responses.
> 
> jack
> 
> 
> On Sun, Mar 12, 2017 at 6:56 PM, jack drawbridge <jackandpat.d at gmail.com>
> wrote:
> 
>> Jim B,
>> 
>> Haven't worked  with bat or cmd for years (if I ever knew). My bat file
>> works if I type the bat file name into the command window  and I'm in the
>> directory where the bat file is stored.
>> 
>> The bat file does not create the output file when I try to run it from
>> Access shell as shown in earlier post.
>> 
>> The user has 1000's of images (all jpg) in various folders. I thought
>> running a Dir to build a file of the names of the jpgs would be a starting
>> point. Also, that running it from Access or scheduler or ??? might hide
>> some of the command prompt activity etc.
>> 
>> I'm looking to get a list of all jpgs that I can use to compare things
>> within Access. The user modifies and manipulates the jpgs, and needs to
>> know current files at any time.
>> 
>> Options welcome.
>> jack
>> 
>> 
>> 
>> On Sun, Mar 12, 2017 at 6:19 PM, Rocky Smolin <rockysmolin at bchacc.com>
>> wrote:
>> 
>>> I think you might be able to run a bat from the Shell command
>>> 
>>> Rocky
>>> 
>>> 
>>> -----Original Message-----
>>> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
>>> jack drawbridge
>>> Sent: Sunday, March 12, 2017 1:09 PM
>>> To: Access Developers discussion and problem solving
>>> 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
>>> 
>>> --
>>> AccessD mailing list
>>> AccessD at databaseadvisors.com
>>> http://databaseadvisors.com/mailman/listinfo/accessd
>>> Website: http://www.databaseadvisors.com
>>> 
>> 
>> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com