[AccessD] Launching a dos program from Access 97

Thanks guys. I messed with for quite awhile but go it with the batch file as
per Heenan. All is well in my world tonight...beer time.

On 2/27/06, Heenan, Lambert <Lambert.Heenan at aig.com> wrote:
>
> This should be simple enough. Evidently prethin.exe needs to find files in
> the current folder (which needs to be C:\fmv), so all you really need is a
> batch file...
>
> @Echo Off
> C:
> CD \FMV
> Prethin
>
> ... The batch file above will take care of setting the current folder, and
> you would launch it like this...
>
> Dim strComspec as String
> Dim strBatch as  string
> Dim nProgId as Long
>
>    strComspec = Environ("COMSPEC")
>    strBatch = "X:\SomeFolder\LaunchPrethin.BAT"
>    nProgid = Shell(strComspec & "/C  " & strBatch )
>
> HTH
>
> Lambert
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Boogie Loogie
> Sent: Monday, February 27, 2006 8:06 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Launching a dos program from Access 97
>
>
> still working on it...on back burner for a couple of hours. I have
> deadline
> on something else right now. I will let you know how I do and post a
> working
> code here (If I get there from here) Thanks again.
>
> On 2/27/06, Gustav Brock <Gustav at cactus.dk> wrote:
> >
> > Hi Tim
> >
> > You are welcome. But did you find a method?
> >
> > /gustav
> >
> > >>> boogieloogie at gmail.com 27-02-2006 13:43:07 >>>
> > Thanks Gustav
> >
> > On 2/26/06, Gustav Brock <Gustav at cactus.dk> wrote:
> > >
> > > Hi Tim
> > >
> > > Just guessing ... create a batch file that will launch and run the
> > > application. You may need to use CD to make the folder of the app
> > > the current folder. When success with this, use Shell() to launch
> > > the batch file.
> > >
> > > If that fails, try with a shortcut or pif file.
> > > Also, you may try using Shell() with the START command. Type START
> > > /? on the command line for help on this.
> > >
> > > /gustav
> > >
> > > >>> boogieloogie at gmail.com 26-02-2006 22:23 >>>
> > > Hi Gustav
> > >
> > > I should have explained myself a bit better. The particular program
> > > will not fire by using
> > >
> > > Dim ProgLaunch
> > > ProgLaunch = Shell("C:\fmv\prethin.exe", 1) will crash it. For some
> > reason
> > > certain files are not fired when starting this way. I have no access
> > > to the code nor the programmer of the dos program.
> > >
> > > Some how I have to fire c:\windows\system32\cmd.exe change to the
> > > fmv folder then launch prethin.exe from there.
> > >
> > > Any ideas?
> > >
> > > Thanks
> > >
> > > Tim
> >
> > --
> > 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
>



--
AllSportsMarket - the NASDAQ of sports

http://www.allsportsmarket.com/Index.asp?affiliate=3875