VBA, Splash screen hints?

Scott Simonso
#1 / 4

Splash screen hints?

How can I create a form and use it for a splash screen? I'd like to place it
in my autoexec macro and display it for about 3 seconds and close. Any
ideas?

Scott

Fri, 04 Jun 2004 23:59:37 GMT

Dirk Goldga
#2 / 4

Splash screen hints?

You don't need to use an autoexec macro; just set the form as the startup
form in the database's Startup properties (select Tools->Startup... ->
Display Form/Page). Set th form's TimerInterval property to 3000 (3
seconds) and create an event procedure for the Timer event:

Private Sub Form_Timer()
DoCmd.Close acForm, Me.Name
' optionally, open the main menu form or switchboard here.
End Sub

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(to reply via e-mail, remove NOSPAM from address)

Quote:

> How can I create a form and use it for a splash screen? I'd like to place
it
> in my autoexec macro and display it for about 3 seconds and close. Any
> ideas?

> Scott

Sat, 05 Jun 2004 01:32:56 GMT

Scott Simonso
#3 / 4

Splash screen hints?

Thanks Dirk, I found the timer event and started using it. I didn't know
about the Startup procedures. That sounds like a great way to implement it.
Could I hide the form and still have access to it in your implementation?

Scott

Quote:

> You don't need to use an autoexec macro; just set the form as the startup
> form in the database's Startup properties (select Tools->Startup... ->
> Display Form/Page). Set th form's TimerInterval property to 3000 (3
> seconds) and create an event procedure for the Timer event:

> Private Sub Form_Timer()
> DoCmd.Close acForm, Me.Name
> ' optionally, open the main menu form or switchboard here.
> End Sub

> --
> Dirk Goldgar, MS Access MVP
> www.datagnostics.com

Sat, 05 Jun 2004 02:50:59 GMT

Dirk Goldga
#4 / 4

Splash screen hints?

Quote:

> Thanks Dirk, I found the timer event and started using it. I didn't know
> about the Startup procedures. That sounds like a great way to implement
it.
> Could I hide the form and still have access to it in your implementation?

I'm not sure what you mean. You could have the form open (visible) at
startup, and then in the timer event disable the timer (by setting the
TimerInterval to 0) and make the form invisible (Me.Visible = False).

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(to reply via e-mail, remove NOSPAM from address)

Sat, 05 Jun 2004 04:12:49 GMT