Recent content by kramerica

I managed to do this with Autoit. I found a script that had the ability to reference .exe name regardless of the window title. It also had functions that could access the .EXE even if it was on the system tray.

I have an application that I want to do 2 things with. a.) Select it and Send keystrokes. Note After you send keystrokes to the application the window name changes from "Ready" to "Not Ready". When the application is running my script works fine. If I enable the application to minimize...

Open your database and go to the Debug window and do a full compile.

What I ended up doing is loop through to see if they clicked more than one, if they did I pop up a msgbox indicating that this report can only run with 1 item selected. Thanks Randy.

I have a listbox displaying data. Initially the listbox is setup as 'Multiselect' - so that multiple items can be reported on. On one of my summary reports I want to disable the multiselect. When I use the code. mslist.multiselect = 0 I get a run-time error 2448 - you can't assign a...

Bridget, Look at the printers that you have installed. What is the name of your PDF Printer? It may be "Adobe PDFWriter"? See what you have it setup as on your system. Kramerica

Use the On Timer event of the form and set the property to 1000 this would be 1 second, then check the value of each textbox that is representing a chute and then based on it's value toggle the color from your forms background color to the color that you want to flash. Kramerica

Create a module or put this line of code at the top of your module. This will create a global variable for you. Global AuditGlobal As String Then in the After update property on your listbox add this line of text. auditglobal =me.list100.column(1) Kramerica

just a hunch. When you designed your table you may have fields set with the property "Allow Zero Length" = "NO" If this is true, then when you run your append query if you has some null values for those fields the query would fail. Kramerica

Mike, I am using Acrobat 6.0 Professional. this is the code that I use to dump reports into PDF format. Yes.. it's simple. When I use this method ADOBE uses the Report Caption as the name for the export file. So just before I call the procedure I edit the Reports.caption to the file...

I found the code thanks. http://www.tek-tips.com/viewthread.cfm?spid=181&sqid=97503&newpid=181 Kramerica

The IP Address field is stored as text. Has anyone coded a routine to sort the records by increasing IP address. 10.30.5.1 10.30.5.10 10.30.5.2 10.30.5.3 10.30.5.4 Currently this is what happens if you sort.. the last octet jumps up with the other's. Any idea's? Kramerica

try the following change to your SQL statement: Between #10/01/2004# and #9/30/2005# Kramerica

Burritonator, If you have a record open on the screen, all you need to do is save it. The command- "DoCmd.GoToRecord , , acNewRec" opens up a new blank record - and it is abandoning your existing record because you have not saved it. You are telling it to create a new blank record, then...

Rasage, Lewds is correct.. it would be better to run them all as SQL statments. Then you wouldn't need to write all those queries. What happens when you just run the queries.. (I've never used the docmd.close on a query before.. only on forms) DoCmd.SetWarnings False DoCmd.OpenQuery...