jcolby at colbyconsulting.com
jcolby at colbyconsulting.com
Mon Jul 28 20:28:31 CDT 2003
Bruce, It will fire over and over. You will need to set up a variable to track when you set the filter and only do this code once, then clear that variable. Check the var in OnCurrent, and if set, run the count, then clear the variable. John W. Colby www.colbyconsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Bruce Bruen Sent: Monday, July 28, 2003 9:07 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] OnFilter event (repeat) A HUGE thank you Charlotte! Do you see any problem with using Me.recordset.recordcount instead though? I have used it apparently successfully throughout the app where filters are being applied from a commance button. I only need the "after filter event" if the user uses the toolbar buttons to set a customised filter. Should I go back and change all the others to recordsetclone? I have a bit of fear of using the on_current event as I thought it would fire over and over as the list screen concerned (continuous forms) was populated and on many other occassions when the form is active. Any comments? Bruce -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Tuesday, 29 July 2003 9:54 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] OnFilter event (repeat) Me.RecordsetClone.RecordCount should give you the number of filtered records. You can update it in the Current event. Charlotte Foust -----Original Message----- From: Bruce Bruen [mailto:bbruen at bigpond.com] Sent: Monday, July 28, 2003 3:51 PM To: accessd at databaseadvisors.com Subject: [AccessD] OnFilter event (repeat) Hi List, Did not get an any interest in my previous post, so I'll give it another try under a new topic. The onFilter event fires before the filter is applied to a form. I need to get a record count after the filter is applied and display it. I cannot find any way of doing this. Has anyone got any ideas? Tia Bruce _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com