Vba ado

[Newcombe]

I'm having a problem creating a VBA ADO to call a select statement from a table and display it in the immediate window. (I really have no idea where to start either)

http://www.blackbootmedia.com/School/FinalProject.accdb

What I need to do is "Create a VBA function to produce a report in the immediate window using ADO to display the books title and published year"

Any help would be greatly appreciated!

 

[xenou]

There's some good intro material at these sites:

http://www.erlandsendata.no/english/index.php?t=envbadac
http://www.datawright.com.au/excel_resources/excel_access_and_ado.htm (our own SydneyGeek)

Also helpful is the w3schools ado pages:
http://www.w3schools.com/ado/default.asp

Just keep in mind that a recordset is an invisible (in memory) set of records that you can access - generally you are "on" a single row, just as in a table you are "at" a single record.