When you first open a Recordset, the current record pointer will point to the first record and the BOF and EOF properties are False.If there are no records, the BOF and EOF property are True.Some are pretty obvious: The most obvious and annoying situations are queries on one table with totals (Group By, Sum, Count, Average, etc.) that aggregate multiple records.You wouldnt expect to edit that since you are not viewing individual records.They can be chained together (one query uses another query), and are used throughout MS Access forms and reports. Most users are familiar with queries that generate results: select queries, select queries with totals, and crosstabs (which Excel users appreciate the most).
pk People ID First Name Last Name Hire Review Salary Sex Is Selected 1 Carla Dumont 9/4/87 10/2/99 ,249.82 F Yes 2 Andrew Frank 2/9/97 2/9/99 ,081.10 M Yes 3 Janet Lydell 6/25/94 6/25/99 ,875.00 F No 4 Margo Oniell 1/16/94 7/16/99 ,629.58 F Yes 5 Edward Jones 1/17/98 9/17/99 ,163.31 M No 6 Harry Jones 9/22/78 10/1/99 3,500.00 M Yes 7 Jane Doe 8/9/78 10/3/99 3,750.00 F Yes 8 Hugh Poynor 9/12/89 9/30/99 ,601.00 M No 9 Jane Deaux 9/8/87 10/3/99 ,368.71 F Yes If you have this document open, highlight all 9 data rows (above) and copy them to the clipboard.
Connection") Set my Command = Create Object("ADODB. Just remember that the data is being returned as an array (often two dimensional, where the results you want are actually in the second dimension of the array!
) and that you may need to either Trim to kill blank spaces at the end of results or parse the results with string functions like Left.
The recordset interface is referred to as Active X Data Objects (ADO).
It requires a different syntax than DAO, but your experience with DAO will transfer nicely, and it has a much more powerful and consistent toolkit for accessing today's variety of PC and mainframe database formats on the Web.