Counting Records in a Query Using Code

A

Amy

I have a form my sales guys can use to enter booth change requests. I have a
button on the form to gather new change requests in a query, send them out in
an e-mail, and then update the records as sent. If there are no records in
the query, I want it to show a dialog box instead and not send anything.
What's the easiest way using code to tell if the query is empty?
 

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

Using Code to test if a value is in a list 4
Refreshing a query 1
counting query recordds 2
Access Dcount function in access 0
Using Option Buttons to Modify a Query 1
Update records 1
Query Parameter using multiple options 0
Input a value in a form and display in a report 0

Top