Recent content by Andyrue

Fixed I got it working. The problem was I had to use absolute paths everywhere, even within my batch file and within my python program. It doesn't make alot of sense since everything is in the same folder, but it's working now. There was never anything wrong with my VBA code, minus the fact...

Taking the shell call out of the if statement and just trying to execute it with: Shell "c:\directory\import.bat", vbNormalFocus doesn't work. It flashes the command prompt and doesn't work. If I make the command prompt stay open, it opens with the current working directory set to My...

The name of the folder is actually "directory" the real full path is "C:\directory\import.bat" It was different, but for simplicity sake I moved everything so there would be no spaces. I had the shell print out a dir listing to a file and it listed everything in My Documents. It doesn't make...

Ok, I didn't write the code, I'm only trying to modify it. This is the line it errors on...has nothing to do with what I've done. Err_Command0_Click: MsgBox Err.Description Resume Exit_Command0_Click <--------Highlighted Yellow End Sub

I don't know. I have a button that runs this function and it just pops up an alert box saying "Type mismatch". I'm going to guess it errors on the "if len(dir(strPath))>0 " line because if I change strPath to "C:\directory" it doesn't error This is what I have that says Type Mismatch. If...

I tried replacing "runcommand" with my shell call and I get a "type mismatch" error.

ok, just tried this. Same result. I'm noticing when I don't put the full path name though I get a "File not found" error in access. I've double and triple checked the file name and I am absolutely sure that it is spelled right and in the same directory as everything else. Why might it do...

Yes, the batch file runs perfect if I execute it outside of access. It has only one command. runImport.py no paths or anything since the file is in the same folder as the batch file.

Yes, I've tried just test.bat and just /test.bat, and any possible combination I could think of. It just opens the command prompt with the current path being "C:\Documents & Settings/Andrew" it's not making any sense.

Access 2003 Problem Ok, this is my first time tinkering with VBA. What I have is a method that does some stuff and then when it is done, I want it to run a .bat file that simply runs a python program. I spent hours trying to get the Shell command to run it, but it would just keep flashing the...