Search results for query: *

We had the same problem, try the Microsoft "Hotfix" for Office SP3 below: http://support.microsoft.com/kb/945674/en-us?spid=2509&sid=1374

When I attempt to run the original code in this thread from an Excel macro, I get the following msg in the Distiller log, as well as in two text files called in "MyPdfFile" & "myPSFile" which are created in the folder where I'm trying to save: %%[ Error: syntaxerror; OffendingCommand: ) ]%% %%[...

I am trying to get an auto disconnect prompt when a user closes IE6 (win XP). Currently you have to remember to click on connection in system tray and close connection there. It works real well unless user forgets to do so and leaves connection open. I know I can set a time out to...

My query looks at ID numbers and dates. I need to find the latest date for each ID number. Sample data: IdNum Date 123 12/31/2001 123 03/31/2003 354 06/30/2002 654 09/30/2001 654 06/30/2003...

Loomah, I'm sorry. No, I didn't copy your code (I should have) & I missed one of your modifications. To make matters worse, you had commented the change so I wouldn't miss it! Everything is working now. I really appreciate your help!

Thanks for the help Loomah. I still get the type mismatch error. What I'm trying to do is write generic code to disable all command buttons on a form after the user presses any command button. I will eventually put this code in a procedure which I will call as the click event of my buttons...

Please tell me why the following procedure would give me a type mismatch error after disabling all the command buttons on a form except the last one. I have tried deleting the last button but then the error just backs up one button giving me the error on the "new" last button on the...

Thanks for your help!

A co-worker and I are working on the same MS Access project. We are located in different cities. When we get together we spend several hours of our time putting our most current version of our respective objects (forms, reports, queries, etc.) into the same .mdb file. Is there anyway to speed...

Anything's possible! I'm probably misunderstanding still but this works on the test form I set up. I moved the code to the On Current event of the form. It now makes the background of the form change colors based on the value of your list box. I think this is what you want since On Current...

Hi, I'm sort of new at this but I think the following would work. Of course, you already know the values which can be in the status field or you couldn't pick what colors to change to, right? I set up a Select Case statement on the lost focus event of the list box which changes the ForeColor...

I'm not sure about Access 97 but with Access 2000 you can go to tools -> options -> general and choose "compact on close". I don't have a copy of Access 97 loaded to test this but I hope you can do it in that version also.

I'm trying to run a file compression activex utility (ActiveZipper Pro). I feel comfortable with coding the activex properties necessary to do what I want but here is my silly question.. How do I run the control? i.e. If I wanted to write code to run the common dialog box activex control I...

I mean the report output (the output that would show up if I printed the report out to the printer).

Is it possible to display the results of a report in a text box? A collegue of mine wishes to do & has yet been unable to do so.