Hi,

I need help with some of the most basic VBA stff in the world, (haven't done any for 4 years....ish). I am trying to write some VBA in MS Access, and have three main, (initial), questions.

1. How do you run an SQL SELECT statement in VBA Access?
2. How do I get the results out of the returned object\recordset?
3. How can I iterate through each record in the returned object\recordset?


Any and all help will be very much appreciated.

Cheers