access-vba-recordset
MS Access Login Form Revised
MS Access Login Form Revised. Revised because I added some stars to the password entry box, and a new registration form. Make sure you set the InputMask property of the password textbox to “Password”! Option Compare Database ‘======================================================== ‘BY LOEBLCOM SERVICES 2013 ‘ERIK LOEBL(713)409-7041 ‘EMAIL: erik@loeblcomservices.com ‘WEB: http://loeblcomservices.com ‘======================================================== ‘================= ‘basUtilities code: ‘================= Public Function […]
Being More Specific In Access Import
In this video will help you be more specific in your access import. You will find out how to insert a name of the table you want to import. Option Compare Database ‘======================================================== ‘DATABASE DESIGNED & CODED BY LOEBLCOM SERVICES 2013 ‘ERIK LOEBL(713)409-7041 ‘EMAIL: erik@loeblcomservices.com ‘WEB: http://loeblcomservices.com ‘======================================================== Dim m_strFileName As String Private Sub btnDBTable_Click() […]
Access Import Of Spreadsheet Or Table
I received an email question about the difference in importing an Access object versus an Excel spreadsheet. In this video you are going to find out how to import your spreadsheet or table using the access import feature and vba. Option Compare Database ‘======================================================== ‘DATABASE DESIGNED & CODED BY LOEBLCOM SERVICES 2013 ‘ERIK LOEBL(713)409-7041 ‘EMAIL: […]
How Do I Import An Excel Spreadsheet
How Do I Import An Excel Spreadsheet In this video you will find the answer to the question “How do I import an excel spreadsheet into my Access database?” Option Compare Database ‘======================================================== ‘DATABASE DESIGNED & CODED BY LOEBLCOM SERVICES 2013 ‘ERIK LOEBL(713)409-7041 ‘EMAIL: erik@loeblcomservices.com ‘WEB: http://loeblcomservices.com ‘======================================================== Dim m_strFileName As String Private Sub btnImport_Click() […]
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 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 […]
Recordset In VBA – PT4
This video will show you how to create the SQL recordset in VBA. SQL is used to perform updates quickly to a data source. The 4 main SQL statements cover the “action” queries in MS Access: 1. SELECT 2. UPDATE 3. DELETE 4. INSERT 1. The syntax for the SELECT is: SELECT [field] FROM [table] […]
Recordset In VBA – PT3
In this video we are talking about how to use MS Access form and bind in to a recordset In VBA. We talk about how to navigate the recordset. Here is an image of the way the process of the recordset’s methods work: Here’s the video: Option Compare Database Dim m_rst As Recordset Private Sub […]
Recordset In VBA – PT2
There are times when you will need to access your data programatically and you will have to create the recordset in VBA rather than from the built in data connection Access provides. ADO is a superset of DAO in functionality point of view. The primary benefit of using the ADO recordset object is: -Ease of […]