Event Procedures

MS Access Form Events – PT1

In this video I talk about how to program vba object items like the ms access form. Specifically we look at the Access Form Open Event, and add a password prompt in the open event of the form, cancelling the open event if it is incorrect. Also we will look at controlling the Form_Load with […]

Continue Reading

MS Access Form Events – PT2

This video covers the following MS Access Form Events: Form_Delete Form_Unload Form_Close Remember: The Unload Event happens before the Close Event. Private Sub Form_Close() ‘happens after the unload event End Sub Private Sub Form_Delete(Cancel As Integer) If MsgBox("Continue with Delete?", vbYesNo) = vbNo Then Cancel = True End If End Sub Private Sub Form_Unload(Cancel As […]

Continue Reading