Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Capture results of docmd.openquery 1

Status
Not open for further replies.
Cloonalt

Cloonalt

Programmer
Jan 4, 2003
354
US
This seems like a dumb question, but...

If I use docmd.openquery(queryname) and the query returns 0 records, can I capture that result and display a message box?

Thanks.
 
Sort by date Sort by votes
HI....

It is possible to obtain the count of records returned by Query using DCOUNT.

Place the following in the Click Event of a command button.
Fill values as needed.


Dim MyCount as Double

MyCount = DCOUNT("[SomeField]","YourQuery")

MsgBox "There are " & MyCount & " record(s) available!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

V
  • Locked
  • Helpful tip
Capture Shift Key if Pressed on A form
Replies
3
Views
604
strongm
strongm
M
  • Locked
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
3K
SoftwareRT
SoftwareRT
Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
1K
Andrzejek
Andrzejek
IrishJim
  • Locked
  • Question
How do I capture the "digital signature", for display in my Form header?
Replies
0
Views
334
IrishJim
IrishJim
Moss100
  • Locked
  • Question
Stop user changing size of Access Application (not form)
Replies
1
Views
677
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top