×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Report not to print if source query is empty

Report not to print if source query is empty

Report not to print if source query is empty

(OP)
I have a series of mailmerge reports that run off of queries. I have a form set up to run all of the letters and their underlying queries when a button is clicked.

The problem occurs when the query comes up with no results and the letter prints anyways with "#error" in the place of the null fields.

I want to be able to print or not print based on wether there are any records in the query.

RE: Report not to print if source query is empty

Find the recordcount of the query before you go to the print.  If your button just does a doCmd for the report, you will need to add the steps to get the record count from the query before the docmd.

If MyQry.RecordCount > 0 then
    DoCmd.OpenReport ...
End If

MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over

RE: Report not to print if source query is empty

Alternatively, you could simply place some code in the 'On No Data' event in the report that aborts the report by setting 'Cancel=True'. This way, you don't have to run the query more than once.
  -Doug

RE: Report not to print if source query is empty

Doug,

Yours is much better.  I don't use Ms. Access much anymore, and I misplaced my memory for the NoMemory 'event'.

MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close