Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hello, I am trying to run a batc

Status
Not open for further replies.

Liam1

Programmer
Nov 7, 2002
43
GB
Hello,

I am trying to run a batch file from Access. I'm not very good at VBA, but what I would like to do is:

Return a code to my Access database when the application closes.
e.g
Shell(File.Bat)
*BTEQ Opens*
*do something for 5 minutes*
*BTEQ Closes
now my bit:
a variable is populated/created upon the called application's closure, that will allow me to trigger another function.

Is this even possible?

Thanks in advance,

Liam1
 
Hi,

Have your Batch program create/build/close a log file.

In your loop, test for the existance of the log file. Once the batch program finishes and releases the log file, it will show up.

:)

Skip,
Skip@TheOfficeExperts.com
 
Look at this FAQ

....It's sounds like you need to suspend the code until a shelled process is complete.
 
OOOps...guess you need the faq #

faq707-2542
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top