Fast opening form

[Hank]

I'm using Access 2000 and like many of you, I use the AutoExec
macro to open my main form. The problem is that for the first few
seconds, no form is visible and the user is looking at the list of
forms or tables in the database.

It would be nice if a form popped up immediately and just said
"Database Loading" or anything besides looking at the design screen. I
tried just opening a simple form with a label on it, which would, in
turn, open my Main form. But the simple form took just as long to
open. I have also tried using Startup with the same results.

As the project is still under development, I release the .mdb
version every day.

Is there anyway I can hide the view of the design screen until
some form is ready to display?

Thanks,
Hank Reed

[lylefair]

Hank wrote:

I'm using Access 2000 and like many of you, I use the AutoExec
macro to open my main form.
Many of us use the AutoExec macro to open our main form? Really? I
think I've never used an AutoExec macro for anything and I never use a
main form either.
Is there anyway I can hide the view of the design screen until
some form is ready to display?

If you go to Tools, Start you can choose a form to show on open, and
you can choose to hide the Database Window. (You can also control these
settings in VBA code.) As for the design screen, I have never seen this.

[AP]

Try using the tools to display the form on open of the database instead
of launching it with the macro, then run your other macro functions in
the on open event of the form.

[david epsom dot com dot au]

Why is it taking so long? What VBA references are you
using?

(david)

"Hank" <ha********@aol.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...

I'm using Access 2000 and like many of you, I use the AutoExec
macro to open my main form. The problem is that for the first few
seconds, no form is visible and the user is looking at the list of
forms or tables in the database.

It would be nice if a form popped up immediately and just said
"Database Loading" or anything besides looking at the design screen. I
tried just opening a simple form with a label on it, which would, in
turn, open my Main form. But the simple form took just as long to
open. I have also tried using Startup with the same results.

As the project is still under development, I release the .mdb
version every day.

Is there anyway I can hide the view of the design screen until
some form is ready to display?

Thanks,
Hank Reed