How to link Splash screen and Switchboard in mdb database using Ma

[Mahesh Yawantikar]

Can anyone tell me the Macro code for linking a splash screen and switchboard
on startup of mdb database?

 

[tina]

what do you mean by "linking a splash screen and switchboard"? what are you
trying to accomplish?

hth

 

[Mahesh Yawantikar]

I mean, when you start a mdb database, if you have got a splash screen for
your database and if you have created a SB, and when you start your mdb
database, i want to see my splashscreen and when i close it, it should
directly take me to my SB. See, i have a splash screen and SB ready for my
Database, but when i open it only I can see splash screen open and when i
closes,it all i can see is my Database window.
If i want to go to my SB, i have to open that Form.
I hope now, my problem. If any body can automate this, pl send me the code,
or whatever it is. Thanks in advance.

 

[tina]

suggest you use the splash form's Timer event to close the splash form and
open the switchboard. normally you don't want your user to have to close a
splash form. try

Private Sub Form_Timer()

DoCmd.Close acForm, Me.Name, acSaveNo
DoCmd.OpenForm "name of switchboard form here"

End Sub

in the splash form's design view, click on the Event tab and scroll to the
Timer Interval event. set the interval to the number of seconds you want the
splash screen to remain open; for instance, a setting of 3000 will keep the
splash form open for 3 seconds.

hth