admin
Access VBA Create Table
This example is a response from an email I received regarding: “How to build a table by extracting some fields from a main database…” I interpret it as: “Query a main database (mainframe) and create a local table.” I do have another easier version of this process at “How To Create A Table In Access […]
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() […]
Shell VBA function
Did you know that you can use the Shell VBA function to launch external applications? Option Compare Database ‘======================================================== ‘DATABASE DESIGNED & CODED BY LOEBLCOM SERVICES 2013 ‘ERIK LOEBL(713)409-7041 ‘EMAIL: erik@loeblcomservices.com ‘WEB: http://loeblcomservices.com ‘======================================================== Private Sub btnLaunchExcel_Click() Dim strPath As String Dim strFile As String strPath = "C:\Program Files\Microsoft Office\Office14" strFile = "EXCEL.EXE" Shell strPath […]
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() […]
Microsoft Access IIF Function
In this video you’ll find out how to use a microsoft access iif function to create a list of items to order to replenish your stock. You’ll learn how to use the iif function to return a text value and to return the result of a calculation. You can download the database file, by clicking […]
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 […]