Page 1 of 2 12 LastLast
Results 1 to 15 of 21
  1. #1
    xjps is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2020
    Posts
    9

    Report print loop

    I made a custom report and which should be about 4 pages long but when viewed in print preview its 380 pages long! I keeps looping the report. Any help would be great. Thanks.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    15,619
    Readers will need some details in order to offer advice. You could post your database in zip format, or give some specifics on record source, purpose of the report, sorting/grouping...

  3. #3
    xjps is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2020
    Posts
    9
    I can't just post the db. It has some sensitive information in it. What would be the best way to provide the necessary information?

  4. #4
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    2,783
    What do you mean by "Looping"?
    Does it print the same page over and over?
    Does it print the whole table when you want only a specific row from the table?
    What code fires off the report? Do you specify criteria?
    Do you get the same results when you double click on the report name from the navigation pane?

  5. #5
    xjps is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2020
    Posts
    9
    It prints the whole report over and over again. I have three different reports. The first is all records, the next two reports are specific data and they all do it. I can just hit the "next page" button an infinite number of times and once it gets to the end of the report the next page is the first.

  6. #6
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    2,783
    Maybe you have a cartesian query result as the report recordsource. Is the report recordsource a named query? If so, what does the query result look like when you run it independently?

  7. #7
    xjps is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2020
    Posts
    9
    The three separate queries all run normal and produce the expected results. How do I verify the recordsource? The property sheet in the query design view is empty. (Forgive my ignorance, Im new to access)

  8. #8
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    15,619
    Welcome to the forum.
    Well I did suggest
    or give some specifics on record source, purpose of the report, sorting/grouping
    ...

    There is some logic issue if you are getting multiple copies of the report. Can you show the code that processes the report?
    How do your queries relate to your reports?
    We need some concrete info on purpose, structure, something if we are to comment on facts.

  9. #9
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    2,783
    How do I verify the recordsource?
    The report recordsource is in the report properties, not the query properties:

    Click image for larger version. 

Name:	rpt.png 
Views:	8 
Size:	21.2 KB 
ID:	40802

  10. #10
    xjps is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2020
    Posts
    9
    I just ran the report independently and it works. I probably should have added that the reports are associated with navigation control. Again, Im new here so where is the code for the report located?

  11. #11
    xjps is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2020
    Posts
    9
    Record source is listed as: SELECT Pilots.[First Name], Pilots.[Last Name], Pilots.[Base Month], Event.[Event Name], Event.[Event Description], Event.[Valid Duration], Event.[Date Completed], Event.[Date Expires], Event.[Event Type], Pilots.[Certificate Number] FROM Pilots INNER JOIN Event ON Pilots.[Certificate Number] = Event.[Cert_Num];

  12. #12
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    15,619
    I just ran the report independently and it works.
    So where /how exactly do you run the report that is failing or giving multiple copies?
    That is what's different?

    How many Pilots are involved? How many Events?

  13. #13
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    2,783
    Quote Originally Posted by xjps View Post
    Record source is listed as: SELECT Pilots.[First Name], Pilots.[Last Name], Pilots.[Base Month], Event.[Event Name], Event.[Event Description], Event.[Valid Duration], Event.[Date Completed], Event.[Date Expires], Event.[Event Type], Pilots.[Certificate Number] FROM Pilots INNER JOIN Event ON Pilots.[Certificate Number] = Event.[Cert_Num];
    If the report is OK with this recordsource when run independently, then some code must be modifying that recordsource when run otherwise. When not working OK, are you running the report from a button click on a form? How do you differentiate one report run format from another?

  14. #14
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    2,783
    Orange, we're both on the same track here. No need for both. I'll step aside.

  15. #15
    xjps is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2020
    Posts
    9
    Whats your email? Itll be easier if I could just send you a dropbox link.

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Loop Query and Print based on multiple criteria
    By beckysright in forum Queries
    Replies: 1
    Last Post: 11-15-2017, 01:17 AM
  2. Replies: 3
    Last Post: 04-28-2017, 09:51 AM
  3. Print in a loop
    By LonghronJ in forum Modules
    Replies: 4
    Last Post: 02-03-2016, 07:44 AM
  4. Replies: 5
    Last Post: 08-06-2015, 03:26 PM
  5. Replies: 1
    Last Post: 02-21-2015, 11:35 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums