Search results

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.

I inherited this user written multi user (<=10 simultaneous users) Access 2000 database. The front end in Access 2000, the back end is SQL 2000. All the tables are linked to SQL. When the users were running the Access front end on a Novell server there were no problems. We have sinced moved it...

Is there a way I can run a macro or module every time a database is closed, whether the user clicks File Exit or the big X in the upper right hand corner. They';re closing the forms properly and inserting blank records into the SQL database and I need a good way to stop that by providing a...

I put the formname in quotes in the Close event of my form per your suggestion, that worked. Thanks again.

thanks I got it to work.

OK, I admit it, I'm lost. I searched and found the code to find out if a form is open, but I don't know how to use it. How do I "pass the from name to the function"? I keep getting mismatch errors Please help!