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 – […]

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: 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 […]

Continue Reading

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 […]

Continue Reading

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 […]

Continue Reading

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 […]

Continue Reading