Sheila-
John:
Wow! That was a quick response. And it's late in Paris. Thank you.
I think I understood all the steps except the last one. I don't know where the Startup properties are set. Is that in VBA code? That's over my head.
I am going to start the process now. I am eternally grateful.
-Sheila
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, September 11, 2014 10:48 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Error Message On Opening Databases
Sheila-
The problem is the parts of the VBA project have become "disconnected" from the associated forms / reports.
Try this:
1) Create a new empty database. Make sure you turn of Auto Correct in this database.
2) Import all the objects from the "broken" database
3) Open the VB Editor (CTRL+G works), and choose Compile from the Debug menu. If you get no errors, Save the project.
4) Compact and Repair the new database.
5) Put back the Startup properties that were set in the old database.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Sep 11, 2014, at 5:26 PM, Sheila Vaughnn sheila_vaughnn@beaerospace.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Hi, everyone:
My name is Sheila. I work for Liz Ravenwood, who is a member of this group. She is also the only expert I know of at our company.(I've been here less than three months.) Liz is on vacation, and I'm stuck. I'm a real newbie as I've been trying to learn Access 2010 for about two months. I am not a programmer, and I don't know VBA. I have been reading Dummies books to try to get up to speed.
Here's the problem I have:
On Tuesday (9/9), I opened Database A in one instance of Access and made some cosmetic changes to the main form. Then I opened Database B in another instance of Access to make a few quick changes as I waited for a meeting with the user for Database A. In Database B, I made a few edits to some sub-forms that reside on the main form. I selected a text box and thought I was typing a word into a property field. (Yes, I believe I have AutoCorrupt on, which I've since learned I shouldn't.) Suddenly the screen seemed to freeze, and I got a message box asking if I wanted to save changes. I decided I better, so I clicked OK. Both instances of Access disappeared. When I try to re-open Database B (which I have more than once), I get this message: The expression On Open you entered as the event property produced the following error: Return to GoSub.
I looked up the error message online, but the suggestions, like Decompiling, were over my head. Of course, Compact & Repair didn't work. It was late in the day so I gave up.
The next day, I opened Database A without using the shift key. When I expanded the left panel, I selected the form, right-clicked Open, and the form opened! Magic? I worked on the form for most of the day thinking I could at least get some work done until Liz returns. I saved frequently in vain. In the afternoon, I closed the database. Then I thought of a quick change, and tried to re-open the database, and I got the same message again.
I'm totally mystified, worried, and out of ideas. Can anyone help? I really don't want to text Liz while she's on vacation.
Thank you very much,
Sheila
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (6) |
Tidak ada komentar:
Posting Komentar