If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
saving a revised form/report
I have problems saving a revised form. I found a
technique that seems to resolve the problem but not sure why it works. The following describes the problem and solutions tried. Does anyone know why the last procedure works: Subject: saving a changed form From: "Brandon Jackson" Sent: 7/7/2004 12:38:43 PM I tried each of these to no avail. I did however stumble across the follow which allows me save the revised reports. Any idea why this works? 1. Open the database report in Design View; 2. Right click on the report properties tab; 3. Open the properties box; 4. Click on the Event tab; 5. Go to the first line which reads: On Open....[Event Procedure] is probably selected; 6. Open the three ... buillder box; 7. Select and delete the contents of the box and close this box; 8. High light and delete the Event Procedure line if still present; 9. Add back Event Procedure to the line; 10. Can now save the report; 11. If none of the lines in Event have Event Procedure selected, add it to a line and then do the remove process. No idea why this works. Brandon -----Original Message----- Okay, you certainly have a problem with your old database. You could try compacting a *copy* of your old database, and see if that helps. You could also try turning off its Name AutoCorrect, and compacting again. Double-check you do not have a procedure that has the same name as a module. For example, if you have: Function FooBar() and you also have a module named FooBar, then rename the module. Finally, the to check the name of the "project", open a code window, and look on the Tools menu. You will see: xxx Properties where xxx is the name of your project. You can use that menu item to rename the project if necessary. If none of that works, it may be possible to export the problem report with the undocumented SaveToText, and import into the new database with LoadFromText. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Brandon Jackson" wrote in message ... I tried the procedure you outline. As the import ran, I received the following message on forms and most reports: "Name conflicts with existing module, project or object". With a click on OK, the process skipped the report and moved on to the next. Thus, I was unable to import the needed forms and reports. The reports are the main items I need to have revision/save capabilities. Any other suggestions. thanks Brandon Jackson -----Original Message----- Your database is either opened (not converted), or else partially corrupt. To rebuild it, try this sequence: 1. Using Access 2000, create a new (blank) database: File | New 2. Immediately, uncheck the Name AutoCorrect boxes under: Tools | Options | General. For an explanation of why, see: http://allenbrowne.com/bug-03.html 3. Import everything from the problem database: File | Get External | Import 4. Press Ctrl+G to open the Immediate Window. Under: Tools | References check the box beside: Microsoft DAO 3.6 Library Unless you need them, uncheck the boxes beside: Microsoft ActiveX Data Objects 2.x OLE Automation For more information on references, see: http://allenbrowne.com/ser-38.html 5. Still in the code window, compile the application: Debug | Compile "brandon jackson" wrote in message ... I have a 2000 db, converted from Access97. I can revise and preview converted forms but can not save changes. I can create new forms, run, edit & save them. Upon exit, get "do you want to save" message. A yes reply keeps the form open and a no reply closes w/o saving. No one else is in the database. I opened the Events property tab on several forms and managed to make/save changes, but still have problems with many forms. I can change/save tables and queries. We have many forms in this db so the prospect of rewriting is daunting. Any suggestions? I posted this same message on security as pbm may be security. |
#2
|
|||
|
|||
saving a revised form/report
I would guess that something is corrupted. If you are trying to remove all
code from behind the form or report, try setting its HasModule property to No, this will completely remove the coding. If you are wanting to keep the coding, you may try saving the code to text, do the above, compact and repair the database, then select one of the events, reopen the code window, and paste the code back in. You'll need to reset each event that has code to [Event Procedure] on the Events tab. If that still doesn't work, you can find more information on corruption here. http://members.iinet.net.au/~allenbrowne/ser-47.html http://members.iinet.net.au/~allenbrowne/ser-25.html -- Wayne Morgan Microsoft Access MVP "brandon jackson" wrote in message ... I have problems saving a revised form. I found a technique that seems to resolve the problem but not sure why it works. The following describes the problem and solutions tried. Does anyone know why the last procedure works: Subject: saving a changed form From: "Brandon Jackson" Sent: 7/7/2004 12:38:43 PM I tried each of these to no avail. I did however stumble across the follow which allows me save the revised reports. Any idea why this works? 1. Open the database report in Design View; 2. Right click on the report properties tab; 3. Open the properties box; 4. Click on the Event tab; 5. Go to the first line which reads: On Open....[Event Procedure] is probably selected; 6. Open the three ... buillder box; 7. Select and delete the contents of the box and close this box; 8. High light and delete the Event Procedure line if still present; 9. Add back Event Procedure to the line; 10. Can now save the report; 11. If none of the lines in Event have Event Procedure selected, add it to a line and then do the remove process. No idea why this works. Brandon -----Original Message----- Okay, you certainly have a problem with your old database. You could try compacting a *copy* of your old database, and see if that helps. You could also try turning off its Name AutoCorrect, and compacting again. Double-check you do not have a procedure that has the same name as a module. For example, if you have: Function FooBar() and you also have a module named FooBar, then rename the module. Finally, the to check the name of the "project", open a code window, and look on the Tools menu. You will see: xxx Properties where xxx is the name of your project. You can use that menu item to rename the project if necessary. If none of that works, it may be possible to export the problem report with the undocumented SaveToText, and import into the new database with LoadFromText. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Brandon Jackson" wrote in message .. . I tried the procedure you outline. As the import ran, I received the following message on forms and most reports: "Name conflicts with existing module, project or object". With a click on OK, the process skipped the report and moved on to the next. Thus, I was unable to import the needed forms and reports. The reports are the main items I need to have revision/save capabilities. Any other suggestions. thanks Brandon Jackson -----Original Message----- Your database is either opened (not converted), or else partially corrupt. To rebuild it, try this sequence: 1. Using Access 2000, create a new (blank) database: File | New 2. Immediately, uncheck the Name AutoCorrect boxes under: Tools | Options | General. For an explanation of why, see: http://allenbrowne.com/bug-03.html 3. Import everything from the problem database: File | Get External | Import 4. Press Ctrl+G to open the Immediate Window. Under: Tools | References check the box beside: Microsoft DAO 3.6 Library Unless you need them, uncheck the boxes beside: Microsoft ActiveX Data Objects 2.x OLE Automation For more information on references, see: http://allenbrowne.com/ser-38.html 5. Still in the code window, compile the application: Debug | Compile "brandon jackson" wrote in message ... I have a 2000 db, converted from Access97. I can revise and preview converted forms but can not save changes. I can create new forms, run, edit & save them. Upon exit, get "do you want to save" message. A yes reply keeps the form open and a no reply closes w/o saving. No one else is in the database. I opened the Events property tab on several forms and managed to make/save changes, but still have problems with many forms. I can change/save tables and queries. We have many forms in this db so the prospect of rewriting is daunting. Any suggestions? I posted this same message on security as pbm may be security. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Preventing People from Saving | Andrew | General Discussion | 1 | June 23rd, 2004 03:05 PM |
Saving files to a usb2 drive. | Peacekeeper | Powerpoint | 9 | June 23rd, 2004 02:46 AM |
Saving Page Margins with RTF files | Karen Spann | Page Layout | 0 | May 17th, 2004 11:33 AM |
Word/Excel Linked Templates not saving on exit | Worksheet Functions | 2 | November 5th, 2003 06:50 PM |