Search results

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.

Okay, thanks for you help. Looks like I'll have to rethink it all.

Nope, no good.

Sorry, I should've specified that. I'm using an ADP with ADO recordsets. And yes, that's the error message I get.

Thanks for your reply dkinley. No, I'm not able to apply a filter before I set the recordset variable rs.

You guys are heaven sent. I thought I wouldn't be able to get out of this one. From now on, I'll backup my database more often!!

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...