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 Rhinorhino 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
Joined
Jan 4, 2003
Messages
354
Location
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 Helpful tip
Capture Shift Key if Pressed on A form
Replies
3
Views
867
strongm
strongm
Knicks
  • Question Question
Nested Column (Excel, CSV) : How to extract just the metadata or column names within a column of data
Replies
1
Views
74
Andrzejek
Andrzejek
M
  • Locked
  • Question Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
4K
SoftwareRT
SoftwareRT
Moss100
  • Locked
  • Question Question
Remove everything including the comma from the last comma of a string.
Replies
10
Views
1K
Andrzejek
Andrzejek
IrishJim
  • Locked
  • Question Question
How do I capture the "digital signature", for display in my Form header?
Replies
0
Views
416
IrishJim
IrishJim

Part and Inventory Search

Sponsor

Back
Top