Share via

Access is printing multiple reports

Anonymous
2016-06-29T15:19:19+00:00

I have a problem with Access printing multiple reports when I only designate one to print.  I currently use MS Access 2010.  I created a database which track student progress and the problem occurs when I try to print one report.  It works fine to print one report I need, but then when I try to print later on it prints all reports.

I have had no problem with Access before.  It seems that there might be a glitch with Access 2010. 

Any thoughts on this?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

4 answers

Sort by: Most helpful
  1. ScottGem 68,830 Reputation points Volunteer Moderator
    2016-06-29T18:51:38+00:00

    Show us the code for the macro. Are you always triggering the print from this macro or are you sometimes printing from a different source.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2016-06-29T16:14:38+00:00

    Thanks for the reply.

    I created a Macro to first preview the report. After previewing the report I would then click the print button.  It normally works to print the one requested report, but after a while it would generate and print more than one report from the same query. I would then stop the print, close and reopen the database and it would print normal. It's seems to reset itself to print normally.

    Was this answer helpful?

    0 comments No comments
  3. Duane Hookom 26,825 Reputation points Volunteer Moderator
    2016-06-29T15:42:16+00:00

    What do you mean by "prints all reports"? Are you printing all records in one report or actually printing more than one report?

    Was this answer helpful?

    0 comments No comments
  4. DBG 11,711 Reputation points Volunteer Moderator
    2016-06-29T15:37:57+00:00

    Hi. How exactly are you "printing" the report? Do you have a button you click? If so, can you show the code? Thanks.

    Was this answer helpful?

    0 comments No comments