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