Hi Brandon,
Sounds like corrupted Form/Report or VBA Module of that Form/Report.
Try the following in the original database:
- Open the Form/Report in design view
- Select the menu option View > Code
- Select the menu option Edit > Select All
- Select the menu option Edit > Copy
- Paste the code into a NotePad file
- Close the VBA window
- Select the Form/Report properties (properties window)
- For the Property "Has Module" change it from Yes to No (deleting the code
behind Form/Report)
- Close and Save the Form/Report
Then try to see if you can import the Form/Report. If you can't then try
the following
- In the original database open any module (or press ALT+F11)
- Select the menu option View > Immediate Window
- In the Immediate Window type the following and press enter
Application.SaveAsText acForm, "name of your Form", "c:\myForm.txt"
- In the new database open the Immediate Window the same way and type the
following and press enter
Application.LoadFromText acForm, "name of your Form", "c:\myForm.txt"
NOTE: if it's a Report replace acForm with acReport
Once you get the Form/Report into the new database (good luck) open it in
design view and select the menu option View > Code. The code that you
pasted to the NotePad file, copy it from the NotePad file and the paste it
into the Form/Report module
If none of the above methods help get the Form/Report into the new database
then I would recommend that you perform a Google search for "Access",
"Database", and "Recovery".
I hope this helps! If you have additional questions on this topic, please
respond back to this posting.
Regards,
Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<
http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <
http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."
This posting is provided "AS IS" with no warranties, and confers no rights
--------------------
| Content-Class: urn:content-classes:message
| From: "Brandon Jackson" <
[email protected]>
| Sender: "Brandon Jackson" <
[email protected]>
| References: <
[email protected]>
<
[email protected]>
| Subject: RE: Saving revised forms
| Date: Wed, 7 Jul 2004 09:23:05 -0700
| Lines: 89
| Message-ID: <
[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| thread-index: AcRkPq7dH9XfwOopR/GT2iQcr5FbOQ==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.access.security
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.security:11977
| NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
| X-Tomcat-NG: microsoft.public.access.security
|
| Eric-
|
| I get this message: "Name conflicts with existing
| module, project or object library" for any report/form in
| the existing db that will not import into the new db.
| The reports that will import are the same ones that I can
| edit and save the changes. I have tried compact and
| repair.
|
| thanks
| Brandon
|
| >-----Original Message-----
| >Hi Brandon,
| >
| >What result do you get if you import ALL the objects
| into a new database
| >file?
| >
| >
| >Regards,
| >
| >Eric Butts
| >Microsoft Access Support
| >
[email protected]
| >"Microsoft Security Announcement: Have you installed the
| patch for
| >Microsoft Security Bulletin MS03-026? If not Microsoft
| strongly advises
| >you to review the information at the following link
| regarding Microsoft
| >Security Bulletin MS03-026
| ><
http://www.microsoft.com/security/security_bulletins/ms0
| 3-026.asp> and/or
| >to visit Windows Update at
| <
http://windowsupdate.microsoft.com/> to install
| >the patch. Running the SCAN program from the Windows
| Update site will help
| >to insure you are current with all security patches, not
| just MS03-026."
| >
| >This posting is provided "AS IS" with no warranties, and
| confers no rights
| >
| >--------------------
| >| Content-Class: urn:content-classes:message
| >| From: "Brandon Jackson" <
[email protected]>
| >| Sender: "Brandon Jackson" <
[email protected]>
| >| Subject: Saving revised forms
| >| Date: Mon, 5 Jul 2004 05:14:59 -0700
| >| Lines: 10
| >| Message-ID: <
[email protected]>
| >| MIME-Version: 1.0
| >| Content-Type: text/plain;
| >| charset="iso-8859-1"
| >| Content-Transfer-Encoding: 7bit
| >| X-Newsreader: Microsoft CDO for Windows 2000
| >| Thread-Index: AcRiibEMUe2YZYtfSda3C5LfP9xZ4Q==
| >| X-MimeOLE: Produced By Microsoft MimeOLE
| V5.50.4910.0300
| >| Newsgroups: microsoft.public.access.security
| >| Path: cpmsftngxa06.phx.gbl
| >| Xref: cpmsftngxa06.phx.gbl
| microsoft.public.access.security:11934
| >| NNTP-Posting-Host: tk2msftngxa11.phx.gbl 10.40.1.163
| >| X-Tomcat-NG: microsoft.public.access.security
| >|
| >| 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?
| >|
| >
| >.
| >
|
