Restore Database Window

[Zellan]

I have a large relational database which has attached to one of my forms at
startup; a macro which assigns the current time and date.
I must have inadvertently changed the macro and have somehow caused a block
to the tools menu and I have lost the database window.
Is there a way to recover the database window or at least the tools menu so
I can access the startup options and correct the problem?

So far I have

(1) Tried Shift then opening the database - tools option display for a
second but cannot be invoked

(2) I have attempted to import all components from the effected database
into a new database but I am receiving vb errors which I am sure I can
rectify if I had the time.
I have not as yet imported just the tables and queries which will be my next
option
Any assistance would be appreciated.

Zellan

[Larry Linson]

Did you try holding down the shift key when opening your database or
pressing F11 with the database open?

Larry Linson
Microsoft Access MVP

"Zellan" <Ze****@hotmail.com> wrote in message
news:44***********************@news.optusnet.com.a u...

I have a large relational database which has attached to one of my forms at
startup; a macro which assigns the current time and date.
I must have inadvertently changed the macro and have somehow caused a
block to the tools menu and I have lost the database window.
Is there a way to recover the database window or at least the tools menu
so I can access the startup options and correct the problem?

So far I have

(1) Tried Shift then opening the database - tools option display for a
second but cannot be invoked

(2) I have attempted to import all components from the effected database
into a new database but I am receiving vb errors which I am sure I can
rectify if I had the time.
I have not as yet imported just the tables and queries which will be my
next option
Any assistance would be appreciated.

Zellan

[Zellan]

Hi Larry,

I held down F11 and then opened the database. It showed the toolbar for a
brief moment but I am unable to navigate to it so I can open the startup
menu...it just disappears before I can engage it..Is there anything I can do
at this stage to "buy myself more time"

Thanks.

Zellan

"Larry Linson" <bo*****@localhost.not> wrote in message
news:pzOdg.2513$lN5.765@trnddc04...

Did you try holding down the shift key when opening your database or
pressing F11 with the database open?

Larry Linson
Microsoft Access MVP

"Zellan" <Ze****@hotmail.com> wrote in message
news:44***********************@news.optusnet.com.a u...

I have a large relational database which has attached to one of my forms
at startup; a macro which assigns the current time and date.
I must have inadvertently changed the macro and have somehow caused a
block to the tools menu and I have lost the database window.
Is there a way to recover the database window or at least the tools menu
so I can access the startup options and correct the problem?

So far I have

(1) Tried Shift then opening the database - tools option display for a
second but cannot be invoked

(2) I have attempted to import all components from the effected
database into a new database but I am receiving vb errors which I am sure
I can rectify if I had the time.
I have not as yet imported just the tables and queries which will be my
next option
Any assistance would be appreciated.

Zellan

[Rick Brandt]

Zellan wrote:

Hi Larry,

I held down F11 and then opened the database. It showed the toolbar
for a brief moment but I am unable to navigate to it so I can open
the startup menu...it just disappears before I can engage it..Is
there anything I can do at this stage to "buy myself more time"

You don't hold F11 while opening the file. You hold Shift while opening the
file. F11 is for showing the db window AFTER the file is already open (but only
if that hasn't been disabled in Startup).

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com