Dim rs as New ADODB.Recordset
rs.Open "SELECT * from tblTest", etc.
Assume that the query qryText does the same query as "SELECT * from tblText".
Obviously, I have kept these very simple. I know how loop through the rs recordset. What I don't know is how do I loop through the results of the Docmd? I know I can copy and past the SQL view from the query, but is there any way to access the results of the Docmd?
This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted. Others take a little more time and effort and often providing a sample database is very helpf…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…