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...

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 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...

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...

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...

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!