MsgBox Displaying Record Count

  • Thread starter Thread starter Jake
  • Start date Start date
J

Jake

Hi

I have a form which contains a button.

When i click this button, I wish to have some code displays a message box
which counts the number of records in a particular query. I don't want to
display the query on the form or anything like that, I just wish the message
box to say eg '12 records in myQuery'

Could somebody please advise???

Cheers

Jake
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record insert/delete anomaly 0
Access Counting records based on multiple age bracket and output to tabulated report 0
making a particular query the activedatasheet 3
Test for zero records returned from Query???? 8
Access Access Report Works on One Machine but not Another 3
populate a text box with multiple records based on combo box selec 2
Access Dcount (multiple criteria) 3
Counting records in a MsgBox 4

Back
Top