By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,155 Members | 2,518 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,155 IT Pros & Developers. It's quick & easy.

Form RecordSet count = 0 check

100+
P: 553
Hi

This is duplicate post due to no answert.. its a bit urgent

Expand|Select|Wrap|Line Numbers
  1. Me.Form.RecordSource = strSQL
  2.  
How can i get the record count by using above statement.
I am interested in getting '0' value if no records are returned

Anyone?

Thanks
Qi
Sep 7 '07 #1
Share this Question
Share on Google+
1 Reply


100+
P: 553
I am keep answering myself.

Here is the solution:
Expand|Select|Wrap|Line Numbers
  1. If Me.Recordset.EOF Then
  2.  ...so whatever
  3.  
Qi
Hi

This is duplicate post due to no answert.. its a bit urgent

Expand|Select|Wrap|Line Numbers
  1. Me.Form.RecordSource = strSQL
  2.  
How can i get the record count by using above statement.
I am interested in getting '0' value if no records are returned

Anyone?

Thanks
Qi
Sep 7 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.