Hi there,
I've developed an application in Access 2003 and now the users are about to upgrade to 2007 (nothing I can do about it).
The entire thing works seamlessly except for my datasheet subforms. In 2007 you can select the data in a cell or the whole cell (like in Excel). Selecting the...
If anyone finds this via Google, I ended up using a stored procedure to count the filtered number of records (as the Access DB uses a MS SQL backend) instead of a clone of the recordset.
Hi There,
So I have come to a roadblock regarding recordset filtering.
I have a sub procedure that creates a clone of the form's recordset to check that at least one record matches the filter criteria before it is applied to the form (to avoid errors):
Public Sub sub_CheckRecordCount()
On...