[AccessD] Running Dir from Batch file in MS Access

[jack drawbridge]

Thanks Jim D,

Always interested in seeing some code and examples.

The launchApp32 seems to be working (fingers crossed).

jack

On Sun, Mar 12, 2017 at 8:07 PM, Jim Dettman <jimdettman at verizon.net> wrote:

> 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
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>