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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.