I need to count the number of records that show up in a Microsoft access form. The forms record source is defined dynamically in vb using a select query. I need to know how to count the number of records that show up in a form.
Count the number of records that show up in a Access form
Hot Topic
- OpenRecordset VBA Parameters
- Using VBA macro to locate next free column on worksheet
- Find Method - enter value on one worksheet and search in another
- Order By DateDiff() in Access Report
- "How to" Programatically hide or display pivot items of pivot field
- Creating a Toolbar and a button that is linked to a macro
- Address Book Issues
- Updating a pivot table
- change my email address
- iexplore.exe - Application Error
Microsoft ISV
- I have a fairly simple macro writing question (in Word).
- ComboBox itemData as Long => error
- Extracting an embedded document within a cell in a table in a Word document
- row height
- MS Access User Defined Permissions
- DLookup help?
- about macro....
- Erratic Performance using Workbooks.Open
- Are you ready for Windows Vista?
- Compatibility Issue Excel 2000 and Excel 2003
Count the number of records that show up in a Access form
jranaudo
Open the results of your select query as a recordset. Then move to the last record in the recordset, and get the RecordSet.RecordCount property. Does this work
sun919