Quick question here. I have am working in Access 2000 using vba. I have an array of custom classes in my program. When I am done w/ the array can I just erase the objects or do I have to loop thru the array and set each object = nothing first?
Code Example: (How it works now)
Dim a As Integer
Dim Managers() As Object
a = 1
a = a +1
ReDim Preserve Managers(a)
Set Managers(a) = New ReportingLevel
Loop Until a > 10
Just want to make sure my code is as clean as I can get it. :-)
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code.