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

creating code base on recordset properties

Status
Not open for further replies.
t1hodges

t1hodges

MIS
May 8, 2003
54
How can I write an If statment using the fact that a query returned a recordset as my criteria which evaluates to TRUE?
 
Sort by date Sort by votes
Hard to say without more info, but I can say that you can test for the number of records in a records set using:

Me.Recordset.RecordCount

 
Upvote 0 Downvote
Im trying to code a pop up to appear when a query returns a recordset with values excluding the Null value. I dont care about the details of the field just yet. Is there some sort of boolean value I can check for?
 
Upvote 0 Downvote
Maybe this:
If Nz(DCount(1, "query name")) Then ...

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ameedoo3000
  • Locked
  • Question
format partition by vba code
Replies
6
Views
1K
mattKnight
mattKnight
BallunarCrew
  • Solved
ODBC Driver Struggles on new computers
Replies
3
Views
810
BallunarCrew
BallunarCrew
lameid
  • Locked
  • Question
Execution Slowing on iterative generation of PDF's
Replies
3
Views
843
lameid
lameid
renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
1K
renigar
renigar
PizMac
  • Locked
  • Question
error 3027 database or object is read-only
Replies
5
Views
792
PizMac
PizMac

Part and Inventory Search

Sponsor

Back
Top