- Local time
- Today, 14:54
- Jan 20, 2005
I tend to count the records with a dcount("*","queryname") first. If there are no records, then I never open the recordset.
It may be more efficient to open the recordset, and do a movelast instead. I don't know, to be honest.
It depends on what purpose we open the recordset for. If you attempt to take a count of records Immediately after opening the recordset the output will be 1. That means the recordset is not fully populated in memory.
To do that an rs.movelast is required before taking a count. On the SysCmd() case we need the total count of records for the initial call to the command. Subsequent calls needs the processed record count.
Yes, we all code differently taking it through the known route for faster delivery, till it is proved wrong or inefficient.
Sent from my iPhone using Tapatalk