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

------------------------------------

------------------------------------


------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/