View Single Post
  #14 (permalink)  
Old 12-10-03, 09:40
secutanudu secutanudu is offline
Registered User
 
Join Date: May 2003
Posts: 41
I downloaded the driver guide - thanks that was a help. But I am running into a problem. I tested the function you gave me above and it worked great. But when I tried to apply it to a slightly more complicated shell command, the app i ran with the shell command froze just after opening it. I am calling a program called axys32.exe, which creates a text file. When it is called, it is supposed to run a script (hence "taxlots.scr") and return a text file. The 4 variable names after it are 4 paramaters that I need to pass to axys32. This shell command works fine if i use it separate from the LaunchApp32 function. If i call it on its own it runs fine, but I need to wait for it to finish before i run the DoCmd.TransferText line. When I call it from with the LaunchApp32 function, axys32.exe freezes immediately after it opens, and the script never runs. Any ideas?

Here is the code:

If LaunchApp32("s:\axys3\axys32.exe taxlots.scr " & _
acatFilenameUtah & " " & acatFilenameLocal & " " & _
accountFilename & " " & settledAcatFilename) = True Then

DoCmd.TransferText acImportDelim, "SettledSpec", "tblDailySettled" _
, "s:\axys3\taxlots\settledAccounts.txt"

End If
Reply With Quote