Search results for query: *

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...

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...

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.

I would like to 'compact and repair' the database using VBA code so that I would not have to rely on the user to do this. Can anybody provide the code necessary to do this. Thanks in Advance. JesseH

I am required to learn Lotus script. I am a visual learner so I am trying to find a video course. I have found two. One from Planet Learn for $389.00 and one from Netwind Learning Center for $249.00. Any experience with either one of these? Can you suggest another one? I have many years...

I need to execute a procedure defined as an on_click from an "On open event". If the name of the onClick is "cmdPrint_Click()", how do I execute it. gosub cmdprint_click does not work. Gosub cmdprint_click() does not work. Goto does not seem to work either. Any ideas. Thanks JesseH

I copied and pasted data from the internet to excel. It looks good. The numeric data is "type 2". I have tried to format it to number. Did not work. I tired, Value(xx). I tried value(text(xx)). Did not work. I need to convert it to a numeric field to sort correctly and do arithmetic...

This is a multi-part question: 1. I am being asked to get trained in Lotus notes, I remember several languages; Lotus script is one of them. Which one is the prevailing choice. 2. Where can I get a good set of Video Training CD or VCR? 3. Any suggestions? 4. I have been programming for...

We have the code(below) that works in Access 2000. When we try to execute in Access 2002 we can get an error "Expected Expression". Any ideas? Thanks In Advance Jesse Dim MDString As String MDString = "cmd.exe /c \\Drawing\d\Progra~1\AutoCA~1\aclt.exe \\drawing\d\acadwork\37075.dwg /b...

I have written Excel VBA code within access. It works fine. The event is created using => x = cm.CreateEventProc("Activate", "Worksheet"). The problem is that I need it to be launched when the worksheet is opened. I have tried => x = cm.CreateEventProc("Open", "Worksheet"). That does not...

I have coded a pivot table in access and wrote it to an excel w/s. Works great. It was coded as an "Activate Event". How can I single step it so that I an see what is happening. I put a break(like in access) and open the w/s but it does not stop. I can not tell if I am even going through...

I can write cells to an Excel worksheet. Carrying this a bit further, it stands to reason that I can write VBA code to an excel worksheet. The problem: in what location do I place it in the worksheet for excel to recognize as code (emulate Alt F11 in excel). Thanks in Advance, JesseH