Recent content by JesseH

I have the call shell command with the parameter below Quote MDString = "cmd.exe /c \\Drawing\d\Progra~1\AutoCA~1\aclt.exe \\drawing\d\acadwork\m2cp.dwg /b \\Drawing\D\ACAD.scr" EndQuote It works fine. The problem is that the cmd.exe does not close and soon we have hundreds of cmd.exe running...

I would like to find an Excel VBA training course on CD. Does anyone know of any good ones that they would recommend. I write VBA for Access so I am not at ground zero. Thanks

I am creating a file to be passed to another application. The problem is that when the file is opened exclusively by the other application, Access closes down in an error condidtion (we are using a max time in a scheduler). Once that happens, we are toast. Question, using code, is there any...

Dear cmmrfrds, I was searching Amazon to find books that cover the scripting you are referring to. I found Microsoft Windows 2000 scripting and Self Paced Guide. Are these appropriate for the scripting you are referring to? Can you suggest some titles?

Dear cmmrfrds, I was searching Amazon to find books that cover the scripting you are referring to. I found Microsoft Windows 2000 scripting and Self Paced Guide. Are these appropriate for the scripting you are referring to? Can you suggest some titles? Thanks Jesse

How do you write variable length comma delimited files using access. For example, LI,RB2861,124,CA,0 LI,RB2746,440,CA,0 AI,409999,609932, 385005,100,Favorite Market,2222 Main Street,,Santa Monica,CA,90404,1, 1,0,11242003 IH,409999,609932,,,11242003,10001,11242003 II,RB1718,1,2,CA,3200,,0...

If I run a transfer text manually. it works. I do a "Import external files, Text, advanced options, and select the import file specifications. It Imports the file just fine. If I put it in a macro the file has records, but no data whatsoever. There is another transfer text that works just...

I am using the transfer text command with import specifications. I am geting no data (none). I have deleted the import spec completely and re-entered it. Same results. The import file has a blank as a first character and I have used "Filler1" with the "Skip" option. I have even removed the...

I made a change to an existing import file. The problem is that there is a schema.ini file that describes the file. I can not find it to modify it. Can you tell me how to find it. If you would, be specific with the instructions. I can not find the advanced button MS refers to. Thanks in...

Thanks for all your help. We have found the problem. The problem deals with deletion stubs and its interval setting. It was set to 90 days and we were running it hourly. Needless to say, it was getting big, fast. The interval was changed to 2 days and that appears to have solved the...

We are running Lotus Database and importing excel spreadsheet via an agent hourly. The data itself is a constant size, but the overall size of the data keeps increasing in size until it becomes unmanageable by the system. Currently running UPDALL, Fixup, and Compact every evening with no...

We have hundreds of spool files that we need to scan to find a particular string. Is there any utility that can scan all the spool files in an outqueue for a string? Thanks

I am getting this error when I try to update a file on the AS400. Do you know what is causing this? Also, some files can be updated using a query and some can not, Do you know what causes this? Remainder of Message: [IBM][ISeries Access ODBC Driver][DB2 UDB] SQL7008 - Tcust in BPCSFv60 not...

I need to execute a function only if it is a particular hour of the day, i.e., I need to excute a function only between the hours of 14 and 15 (2 to 3 pm). Does anybody have any ideas. I have messed around with the time varible but I can not make it work.

Thanks PHV, we are using Access 2000. The database is too unwieldy to compact on exit. I was trying to compact weekly.