98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Arrays
Arrays
Resolved · Low Priority · Version 2003
Thu 22 May 2008, 09:31Delegate Jan said...
Jan has attended:
Access VBA course
Arrays
Hi,
just a quick question.
As we have not touched arrays on our training - how do they work? i.e. how do you compare set of values in an array to certain variable?
Thanks
Fri 23 May 2008, 09:32Trainer Stephen said...
RE: arrays
Hi Jan
Thank you for your question
An array can be thought of as a virtual table that can hold multiple values.
You must first declare an array in the same way as you would declare a variable.
e.g
Dim myArray(5,6) as integerWould declare an array of 5 "rows" and 6 "columns" that would contain integer data.
You can then set the different "cells" of the array equal to particular values
e.g
myArray(1,1) = 323Sets the first row, first column value to 323.
To compare a set of values in an array to a variable you would normally cycle through the array checking each value against your variable
The following code cycles through each row and column and checks each value against a particualr variable and executes some code if a match is found
For i = 1 to 5
For j = 1 to 6
if myArray(i,j) = Variable then
EXECUTE CODE
End if
next j
next i
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Deleting duplicate records from a tableYou cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table. |
