October 2020
MS ACCESS FORM OBJECTS – PT1
Get all the videos in this Access VBA collection 100% FREE by signing up at https://vbahowto.com/ms-access-tutorial In this video I talk about vba properties and methods of ms access form object items. I also will show how to reference ms access form object items. This is part 1 of a 3 part video series. You […]
MS Access VBA Control Events – PT3
In this video we are going to continue to cover the following MS Access VBA Control Event: NotInList We will also look at the Open Event Arguments of a Form. This is part 3 of a 3 part video series. The NotInList Event of the combo box: Private Sub cboBookTitles_NotInList(NewData As String, Response As Integer) […]
MS Access VBA Control Events – PT2
In this video we are going to cover the following MS Access VBA Control Events: AfterUpdate BeforeUpdate NotInList This is part 2 of a 3 part video series. Private Sub cboBookTitles_NotInList(NewData As String, Response As Integer) Dim strMsg As String Dim strForm As String strForm = "frmAddBookTitle" strMsg = "Sorry, ‘" & NewData & "’ […]
How To Connect Access To SQL Server On Amazon Virtual Machine
In this post I am going to show you how you can connect your Access database to a Microsoft SQL Server 19 running on an Amazon Virtual Machine. Something great about the current technology is that you can have a version of something that would cost you BIGGGGGGGG Money in the past! In this case […]
MS Access VBA Control Events – PT1
In this video we are going to cover the following MS Access VBA Control Events: Click DblClick GotFocus LostFocus DblClick Change This is part 1 of a 3 part video series. Private Sub btnClick_Click() MsgBox "Click" End Sub Private Sub imgDoubleClick_DblClick(Cancel As Integer) ‘These events fire before the DblClick event ‘MouseDown ‘MouseUp ‘Click ‘DblClick Me.txtDoubleClick.Visible […]
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 […]
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 […]