The Recordset object is an essential component in Access development, but it often trips up even experienced developers. Susan Harkins explains 12 common Recordset pitfalls you can anticipate and ...

Which version of Access are you using? If 2K or above, ADO is the default data access library; and ADO Recordsets do sort properly.<BR><BR>Having said that, I would still prefer to use an ORDER BY ...

My old friends, I would appreciate your assistance in solving my current dilemma. I'm looking to make an access report that is dependent on data from a remote SQL Server. Additionally, I want to run ...

A quick method for counting Access records in a form Your email has been sent When you need to count records in an Access form, try the Count() function. There are several ways to count the records in ...