October 2012

Passing Form Field Default Values

This video shows you how to pass form field default values in MS Access. Get all the videos in this Access VBA collection 100% FREE by signing up at https://vbahowto.com/ms-access-tutorial By the way, if you got or are getting value from the VBA information, please give me a tip, thanks!

Continue Reading

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

Continue Reading

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

Continue Reading

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

Continue Reading

Recordset In VBA – PT1

In these next 2 videos, we are going to discuss generating the recordset in VBA techiques: -We will access data in tables by using the ADO recordset object. -We will retrieve data from a table using SQL and ADO recordsets. -We will alter the data in the table using SQL and ADO recordsets. In this […]

Continue Reading

VBA For Loop

Use the VBA For Loop when you know how many iterations the code should make. Using this VBA For Loop will allow you to loop for a specific number of times. Take a look at the video: The syntax for the VBA For Loop is: ****************************************** For counter= start To end [Step backward count (how […]

Continue Reading

VBA Do Loop

Looping structures like the VBA Do Loop allow you to specify the conditions under which you would like your program to run a set of code statements repeatedly. There are 4 different variations of the VBA Do Loop we are going to look at: ‘Do While…Loop structures check the condition before running the code. ‘The […]

Continue Reading

VBA Error Handling PT2

In this VBA Error Handling set I’ll talk about using the error object Here is a chart referencing the Error object’s properties for you to reference: Property Description Number The number of the error. Description The description of the error. Source The name of the object or application that originally generated the error. …CODE EXAMPLE […]

Continue Reading

VBA Error Handling PT1

In this VBA Error Handling set (1 & 2) we’ll talk about: Trapping run-time errors Creating error handlers Using the error object There are 3 main types of VBA Errors: 1. Syntax Errors 2. Logic Errors 3. Run-Time Errors Syntax errors result when the logic is misspelled, or a wrong keyword is used. The VBA […]

Continue Reading