vba to connect individual............... RRS feed

  • Question

  • Hello,

    Please i will need help on how i can connect individual from the log on form to there various switch board. the logic is this.. i created a switch board for different department there is switchboard for Doctor, Pharmacy, and the Laboratory so if any one of them log in through the log on form they will see the switch board particular to them but before the switch bard comes up i want my splash screen to come up. so this is the flow    FROM LOG ON FORM ---- SPLASH SCREEN -------INDIVIDUAL SWITCHBOARD.

    I will be very happy if you can help me out on this . 

    Best Regard.


    Wednesday, January 21, 2015 4:42 PM

All replies

  • Sub pMain()
      frmSplash.Show vbModeless
      'stops for 3 seconds:
      Application.Wait Now + TimeSerial(0, 0, 3)
      Unload frmSplash
    End Sub

    Felipe Costa Gualberto - http://www.ambienteoffice.com.br

    Thursday, January 22, 2015 10:20 PM
  • Thanks alot, just wanna ask will this code be on a single form or each code will be on each form created for different task, i mean will the first code be written on log on form second code on the splash screen and third code for the individual switchboard or all code will be written on logon form. Thanks i really appreciate your effort.
    Monday, January 26, 2015 9:41 AM
  • The code must be at a regular module, not inside any Userform.

    So, the procedure pMain can be called through a button, for example.

    My understanding is that the three Userforms will appear, one each time.

    Felipe Costa Gualberto - http://www.ambienteoffice.com.br

    Monday, January 26, 2015 11:28 AM