Splash Screen Assistance (1 Viewer)

Hello,

Have had this splash screen and figured I would get it to work. I have searched around and found some things that helped but no luck.

I just want it to open when any of my forms are loading...then when they are loaded for it to disappear.

It just says basically "Please wait while the data loads".

I have the interval set to I think 5000 and have this code:

Option Compare Database


Private Sub Form_Timer()
DoCmd.OpenForm "Switchboard", acNormal
DoCmd.OpenForm "frmMain", acNormal
DoCmd.OpenForm "frmMemberDetails", acNormal
End Sub

But dont think that is what I am looking for or even correct...I cant even get my splash screen to even load, only when I directly select the form.

Any help or tips would be great. Thanks.

I have the interval set to I think 5000 and have this code:

Private Sub Form_Timer()
DoCmd.OpenForm "Switchboard", acNormal
DoCmd.OpenForm "frmMain", acNormal
DoCmd.OpenForm "frmMemberDetails", acNormal
End Sub

Click to expand...

With the TimerInterval set to 5000, what this code does is open the forms Switchboard, frmMain, and frmMemberDetails over and over again every 5 seconds! What form is this code in, and exactly what is happening?

What you need to do is have your splash screen form open, then in the Form_Load event of the first form you want to see (your Switchboard, I would assume) close the splash screen form. I don't think there's any practical reason to open all three forms at once. Even doing this the chances are you'll never see the splash screen anyway! Even the most complicated Switchboard only takes nanoseconds to load and open!

Under "TOOLS"... "Startup" set the DB startup form to "SplashScreenName"


In the properties of the Splashscreen....

On the On Timer event of the splash screen

Private Sub Form_Timer()
DoCmd.Close acForm, "SplashFormName"
end Sub

Set event timer to 3000...4000...whatever

on the "Close Event" of the Spashscreen....

Private Sub Form_Close()
DoCmd.OpenForm "Switchboard"

End Sub


Give that a try.

I don't think you really want 3 forms opening at once

Perhaps this can help

Jakboi said:

Hello,

Have had this splash screen and figured I would get it to work. I have searched around and found some things that helped but no luck.

I just want it to open when any of my forms are loading...then when they are loaded for it to disappear.

It just says basically "Please wait while the data loads".

I have the interval set to I think 5000 and have this code:

Option Compare Database


Private Sub Form_Timer()
DoCmd.OpenForm "Switchboard", acNormal
DoCmd.OpenForm "frmMain", acNormal
DoCmd.OpenForm "frmMemberDetails", acNormal
End Sub

But dont think that is what I am looking for or even correct...I cant even get my splash screen to even load, only when I directly select the form.

Any help or tips would be great. Thanks.

Click to expand...

_________________________________________________________

' This will open the splash screen, I set the interval to 1000 on the form
properties setting.

Private Sub Form_Timer()
'On timer event close form
DoCmd.Close acForm, "frmStartUp"
End Sub

THIS....
Under "TOOLS"... "Startup" set the DB startup form to "SplashScreenName"
.... will make your splashscreen open when you open the DB.
the Timer delays the close event.

or just have a loop on the splash screen to see if the form has loaded

Curtis has laid out a procedure for opening the splash screen then opening the next form, and from a purely technical standpoint, rborob's suggestion of looping behind the splash screen until the next form is loaded could be added, using object.IsLoaded to confirm the loading. All of this is really a moot point, I think. Back in the days of slow-as-molasses processors, splash screens were used as JAkboi has suggested in his original post

I just want it to open when any of my forms are loading...then when they are loaded for it to disappear.

Click to expand...

to babysit the user while the data loaded. But in today's world average, run of the mill Access apps are loaded in nanoseconds, and splash screens are only used to convey info to the user; apps name, author, copyright etc. If I were using a loop until the next form loaded, and the splash screen stayed on the monitor long enough to be taken in and registered by the human eye, I'd start debugging my opening code because I'd know that something was wrong!