Just starting - manipulating Access data using VBA 1

[cdipaolo]

I have a few complex queries created in Access but now I have to use some VBA logic to step through the records in these queries and sort/exclude some of them. Do I just start up a module and use the same ADODB type stuff as I would if I did it in Excel? Or is there an easier way to approach it since I'm already in the Access DB?

Example - I am getting a list of users that meet criteria, now I need to go through this list of users one by one and see if they have met certain education requirements, depending on what type of user they are.

 

[DoubleD]

Do I just start up a module and use the same ADODB type stuff as I would if I did it in Excel? Yep!

Something like this:

Dim rs as New ADODB.Recordset

rs.Open "YourQueryName", CurrentProject.Connection

Do While Not rs.EOF
  ' Your Logic here
  rs.MoveNext
Loop

Set rs = Nothing

I am what I am based on the decisions I have made.

DoubleD