MS Access Form

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

MS Access Option Group

In this video you are going to find out how to implement, and vba code a MS Access Option Group [sourcecode language=”vb”] ‘======================================================== ‘BY LOEBLCOM SERVICES 2012 ‘ERIK LOEBL(713)409-7041 ‘EMAIL: ‘WEB: ‘======================================================== Option Compare Database Dim m_blnTimer As Boolean Private Sub btnAnimal_Click() If m_blnTimer = True Then MsgBox "Animal Questions, Use Timer" Else […]

Continue Reading