splash screen.

Question

Hello Sir,

I will need you assistant please i just created an application with Ms Access 2010, i want the log on screen to come up first then the splash screen will come up for 3 seconds after which the user that logs on will be directed to his or her switch board so i got this code below.

     Sub pMain()

  frmLogin.Show

  welcome.Show vbModeless

  'stops for 3 seconds:

  Swichboard.Wait Now + TimeSerial(0, 0, 3)

  Unload welcome

  Switchboard.Show

End Sub

But the frmLogin.Show is highlighted on yellow and i got this error " run-time error 424 object require" Please can i have the appropriate code and step for this to work for me. Thanks alot i really appreciate.

Answer 1

Hello Daniel,

like you said check the code below, after typing the code to my logon form close event, the the splash screen "frmwelcome" did not come up after loging in, what i just discover was that as i login my switchbaord comes up, but what i want is once i log in my splash screen  should come up come up and stay for like 3sec then switchboard will come up. Thanks for you respose.

Private Sub Form_Close()

DoCmd.OpenForm "frmwelcome"

End Sub

Private Sub txtPassword_AfterUpdate()

'Check that EE is selected

If IsNull(Me.cboUser) Then

    MsgBox "You need to select a user!", vbCritical

    Me.cboUser.SetFocus

Else

    'Check for correct password

    If Me.txtPassword = Me.cboUser.Column(2) Then

        'Check if password needs to be reset

        If Me.cboUser.Column(3) = True Then

            DoCmd.OpenForm "frmPasswordChange", , , "[UserID] = " & Me.cboUser

        End If

        DoCmd.OpenForm "Switchboard"

        Me.Visible = False

    Else

        MsgBox "Password does not match, please re-enter!", vboOkOnly

        Me.txtPassword = Null

        Me.txtPassword.SetFocus

    End If

End If

End Sub

Answer 2

So why not use your logon form's close event to open the splash screen?

DoCmd.OpenForm "frmwelcome"

Look at the help file for all the options avaliable with DoCmd.OpenForm()

Answer 3

Hello Dhookom,

Thanks alot, May you could help in this area. now i have made the frmlogon to pop up automatically by doing that from the Access database option, so after logon i want my splash scree to show, i titled my splash screen frmwelcome , so what is the event procedure going to be? is it on load? or after update ? please help out with the code and which event procedure to use.

Thanks alot

Answer 4

Ditto as to what Duane said.

Also, your code is for MS Excel, Word Userforms, not Access.  It will not work with Access.

Answer 5

Typically we open Access forms with code like:

DoCmd.OpenForm "frmLogin"

Do you want the splash to display after the login form is closed?

To automatically close a screen after 3 seconds, I would use the On Timer event and set the Timer Interval to the correct number of milliseconds.