I wish I could claim the originality, but I found it while reading this group's messages or in my various wanderings while perusing Web sites on Access. Believe me I will be turning off the misnamed Auto Correct in the future.
Cheers.
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, September 11, 2014 11:17 AM
To: MS Access Pros List
Subject: RE: [MS_AccessPros] Error Message On Opening Databases
Unintentional and/or Freudian, and maybe it's been said before here and I missed it, but, thank you, Sheila for:
"Yes, I believe I have AutoCorrupt on"
That has made my day.
Steve Conklin
________________________________
> To: MS_Access_Professionals@yahoogroups.com
> From: MS_Access_Professionals@yahoogroups.com
> Date: Thu, 11 Sep 2014 19:47:56 +0200
> 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
> http://www.viescas.com/ (Paris, France)
>
>
>
>
> On Sep 11, 2014, at 5:26 PM, Sheila Vaughnn
> sheila_vaughnn@beaerospace.com<mailto:sheila_vaughnn@beaerospace.com>
> [MS_Access_Professionals]
> <MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professional
> s@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.
>
>
>
------------------------------------
------------------------------------
------------------------------------
Yahoo Groups Links
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: Sheila Vaughnn <sheila_vaughnn@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar