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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do i not show a query that has no results?

Status
Not open for further replies.
gr8R

gr8R

Technical User
Nov 10, 2001
6
GB
I have a query that checks something everytime the database is run. I only want it to show itself or alert the user somehow if it finds something.

So, How do I not show this query if it doesn't find any records?

 
Sort by date Sort by votes
You could use the DLookup or DCount function using the criteria that the query uses to see if it returns a Null value. If null, exit sub, else show query.

Without more detail, it would be hard to say.

ljprodev@yahoo.com
ProDev, MS Access Applications B-)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

atadbitslow
  • Locked
  • Question
how to search data and display matches that include the user's input, but not necessarily match
Replies
5
Views
332
atadbitslow
atadbitslow
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
2K
TheresAlwaysAWay
TheresAlwaysAWay
TheresAlwaysAWay
  • Locked
  • Question
Long-established database suddenly giving error Cannot open macro [Name] because it is not valid
Replies
6
Views
476
dhookom
dhookom
lmcate
  • Locked
  • Question
How to Open ACCESS (MDB) from an HTML Page 1
Replies
2
Views
2K
lmcate
lmcate
TheresAlwaysAWay
  • Locked
  • Question
Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them? 4
2
Replies
22
Views
3K
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top