December 2012
VBA Calculate – Multiply
In this video you will find out how to load a table into a recordset object, loop through the records, and vba calculate 2 fields. Also you’ll find out how to make a user defined function and call it from a query. Need to know how to insert into a table? See this video – […]
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: erik@loeblcomservices.com ‘WEB: http://loeblcomservices.com ‘======================================================== Option Compare Database Dim m_blnTimer As Boolean Private Sub btnAnimal_Click() If m_blnTimer = True Then MsgBox "Animal Questions, Use Timer" Else […]
MS Access SQL
In this video you’ll find out how to create a table with SQL, and insert data into a table, with SQL insert syntax, with data from a dynamic array. Also how to update a table, with SQL update syntax, and select data from a table using ms access sql. [sourcecode language=”vb”] ‘======================================================== ‘BY LOEBLCOM SERVICES […]
How To Make A MS Access Login Form
Watch and find out how to make a MS Access login form. Login forms are useful to collect needed information from the user. In this video, you will find out how to make one with MS Access VBA. [sourcecode language=”vb”] Option Compare Database ‘================= ‘frmMainForm code: ‘================= Private Sub Form_Close() DoCmd.Close acForm, "frmLogin" End Sub […]
How To Make An Access Timer
In this video, you’ll find out how to create an MS Access timer. Timers in MS Access are needed when you want to set a time limit on anwering questions or other tasks. [sourcecode language=”vb”] Dim m_intTimer As Integer Private Sub btnTimer_Click() Me.TimerInterval = 1000 m_intTimer = 10 ’10 seconds Me.txtTime.SetFocus Me.txtTime.Text = m_intTimer Me.btnTimer.SetFocus […]