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 […]
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 […]
A Variable Scope
Key points: A private procedure can be called from any procedure in the same module. The default scope for a sub procedure is “Public” unless you specifically designate it as Private. Store all your procedures and functions you plan to use in your application in “Modules”, which you can call from your other database objects. […]