Hi,
I use Access alot, but mostly the basic stuff. Now I am trying to learn some VB Script to expand my Access skills. I saw codes that I am not too sure of what they do. Please advice.

Do Until rst.EOF
With rst
vcount=vcount + 1
vtc = !tblColumn
End With
Loop
What does this codes do?



Another question:
vsql3 = "Group By SSN, [Group], " & vsta
What does this do? Particularly [Group]?

Thank you.

The first set of code lines is working ona recordset. It is looping through the recordset, and for each record, it is advancing the counter vcount by 1, and taking a value from tblColumn. This looks like DAO though, and I don't do that much.

The second set of code lines is assigning a text value to the variable vsql3. If you output vsql3 to the screen, you would get:

Group By SSN, [Group], vstaValue (which is a number)

[Group] is a field name. This is supplying a Group By clause to a SQL Select statement.

Does that help?
You should read some Wrox books on VBA.


mmcdonal