Recent content by EEK

Hi! I'm using Windows XP and Access 2003. I'm trying to send the enter key to a SAVE AS PDF Dialog box but can't get it to work! Here is the code: DoCmd.OpenReport (sReportName) SendKeys "{Enter}", False where sReportName is the name of the PDF file writing to the Adobe 5 Acrobat PDF...

Reports Work Now The reports stopped working when users PC was re-imaged. Did not check for default printer (although seems obvious now). The Help Desk reimaged again and it worked the second time. Reason still unknown.

I'm having same problem I have 1 user on 1 PC that can't open or design any reports in any database. He has Access 2003 and Win XP. Every one else is fine. We reloaded Access 2003 and rebooted, nothing. Anbody know what's going on and how to solve? HELP!

We have an Access 2000 db running on Windows XP. It now exports multiple reports to pdf using Adobe 5 thru the code which can be found in this forum. That code will not work in Adobe 7 and I can't find that code in any forum. Does anyone have the code to export Access Reports to PDF Adobe 7? Or...

I thought that setting a default value in a field on a form to the entered value of another field on that same form would be easy! Interestingly enough, if you set orig date to now() and set default value of revised date to [origdate] it works, so I guess it has something to do with the entered...

It is possible that the Orig Date may change, though unlikely

KeithG, thanks but wouldn't the AfterUpdate event update the revised date every time it was updated? I just want to have it default to the orig date when the orig date is filled in the first time.

My pet peeves I drive on backroads and I hate to get behind a tractor with a load of manure!

I have a problem. I have a form, being used as a subform. I have an "Original Date" field and a "Revised Date" field. I want the value the user types in the "Original Date" field to be the default value in the "Revised Date" field. I used default value "=[OrigDate]" but that doesn't work, it...

Thank you KeithG....the cancel option workd great.

Let me explain: the user clicks the checkbox. The checkbox has a Beforeupdate event that checks the condition. If that conditon is true I want to remove the check from the checkbox and prevent update. If the is false the checkbox is updated. Another application looks in the checkbox to see if...

Iwant to suppress the message "The macro or function set to the Beforeupdate or ValidationRule property for this field is preventing Microsoft Access from saving the data in the field". The message is correct-Iwant to prevent updating the checkbox if certain conditions aren't met. Any ideas? Thanks

I have a text box that contains cc info and can vary in size from 200 to 2000 characters. When the text box is placed in the DETAILS section, it prints fine, but when I put it in the REPORT FOOTER section, where it needs to be, it's limited to 255 characters. Does anyone know how to get around...

Auto Close Macro Thank you, but I want to make sure a specific form is closed before the db closes so that a user doesn't inadvertently add a new blank record to this database. I'd like to pop up a message that says you have to update the record or escape from it before closing the db. Any...

Surprised I'm surprised to see anyone advocating copying an ACCESS Frontend to every user's C: drive. What a maintenance nightmare! Every itty-bitty change to the db requires a new copy on everyone's PC, what a hassle if you've got a large user base, or users in different cities.