error when opening vba editor

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

HGood - 29 Jan 2007 20:43 GMT

Hi, just today I've run into a problem, when I press Alt+F11 to open the VBA
editor, I get an error message that Access has encountered a problem, do I
want to tell Microsoft. Seems I had this problem a few times over the past
week, but today I can't get editor to open at all after repeated attempts.

Some previous versions of the database have the same problem, but some older
ones in another folder don't. So it doesn't affect all my databases. If I
open Northwind, it's no problem.

I saw some previous discussions about this, but no one had a solution.
Someone suggested opening a new database and copying everything over. I
haven't found a way to do that other than one form, query, and report at a
time. That'd be well over 100 drag and drops. : (

Any advice would be appreciated. Harold

Reply to this Message

John Spencer - 29 Jan 2007 21:08 GMT

Open the new database
Select File: Get External Data: Import from the menu
Navigate to your old database.
Select all the items you want to import
Don't forget to press the options buttom and make the appropriate selections
there.

Signature

John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
.

> Hi, just today I've run into a problem, when I press Alt+F11 to open the
> VBA
[quoted text clipped - 13 lines]
>
> Any advice would be appreciated. Harold

Reply to this Message

HGood - 29 Jan 2007 21:34 GMT

Fantastic, it worked like you said and appears to have solved that problem!
Thanks for such a quick reply.
Harold

> Open the new database
> Select File: Get External Data: Import from the menu
[quoted text clipped - 20 lines]
> >
> > Any advice would be appreciated. Harold

Reply to this Message