I want to do this .. and am looking for some help. Cannot understand mostly why the Splash screen does not immediately load.
The biggest issue .. is that the splash screen does not load up immediately. However .. I tried just the splash screen without the code below and it opens immediately as expected.
Looking for suggestions at this point ..
This is what I want to have happen.
Minimize Database Window (I do not want to see it .. ever. I use Shift to get into the DB if needed).
Open a splash screen (I specify this to open automatically in the database options) This takes a long time to happen.
I would like to open a main form in the background ... as it has lots of subforms and take some time to load.
After .. 10 seconds after splash screen opening I would like to close the Splash Screen .. (done on timer of splash screen and is fine)
Show .. MainForm from above .. and this works.
However .. this is the issue, it takes 49 seconds til I see the splash screen after clicking on the DB file .. it stays for the 10 seconds and then the main form displays fine.
I am thinking that the splash screen loses its focus .. once it tries to open the 2nd form. I would like it to open and remain on the screen .. the 10 seconds part is what I am going to change so that
it will remain on the screen for the amount of time that it takes the main form to load.
The code below is the only code in the Splash Screen
Private Sub Form_Load() // This is code from Splash Screen Load
DoCmd.RunCommand acCmdAppMinimize
DoCmd.OpenForm "frmMainSwitchboard"
Forms!frmMainSwitchboard.Visible = False
End Sub
Private Sub Form_Timer() // Code from Timer from Splash Screen
DoCmd.Close
Forms!frmMainSwitchboard.Visible = True
End Sub