[AccessD] Running Dir from Batch file in MS Access

[Jim Lawrence]

Cool. 

Jim

----- Original Message -----
From: "jack drawbridge" <jackandpat.d at gmail.com>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Sunday, March 12, 2017 4:30:36 PM
Subject: Re: [AccessD] Running Dir from Batch file in MS Access

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