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
- Auto Indentation for VBA
- Making the templated document the active document
- Visual Studio Tools for Applications
- Running a macro if new mail if from a specific address
- Assigning ranges with empty cells
- API/SDK for Office Communicator 2005
- ActiveX 429 error
- problem printing with IE 6.0.2 (hopefully resolved in IE 7)
- How Can I Register The Yahoo DomainKey For My Mail Server ?
- VBA: read/write chinese words
Microsoft ISV
- Sort table based on array
- File Protection from Users
- whats wrong with this code?
- Trying to create Data Acess Pages to manipulate recordsets.
- Need help writting a script similar to...
- Search Keyword in word
- MS Office document and image writer print driver
- BUNDLING MS MONEY 07 TRIAL
- precisely position embedded charts in worksheet
- VBA Userform Control of multiple userform controls
Count the number of records that show up in a Access form
Memroid
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
DerekL