Results 1 to 2 of 2
  1. #1
    saudkazia is offline Advanced Beginner
    Windows 8 Access 2013
    Join Date
    Oct 2015
    Location
    India
    Posts
    71

    How To Limit Any VBA To Group, Access 2013

    I am using methods to artificially enter blank lines to fill up report when detail items are less than x and also to duplicate the report to print twice on one sheet.

    Separately both work well.

    But together I don't see the 2nd copy details.

    I am using these methods that were gained from a google search

    Blank lines - http://www.UtterAccess.com/forum/Add-blank...b-t1565952.html
    print report twice- http://www.access-programmers.co.UK/forums...ad.php?t=199305

    I can understand the logic that the 2nd copy details are being hidden because they meet the criteria set for blank lines. So I need to know how can I reset the counter after the first copy so the second copy prints the details as well.

    Please let me know what is required in terms of information. I am using almost exactly the code and method presented above (with changes to my fields obviously)

    Appreciate any help on this.



    Thanks

  2. #2
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    There is an event for when the header of a section prints. You could try resetting the counter in that event.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 10-07-2015, 12:28 PM
  2. Access 2013 size limit is exceeded
    By jassie in forum Access
    Replies: 4
    Last Post: 09-24-2015, 08:54 AM
  3. Replies: 2
    Last Post: 08-13-2015, 02:14 PM
  4. Export From Access 2013 To Excel 2013
    By Esmatullaharifi in forum Programming
    Replies: 8
    Last Post: 04-17-2015, 09:40 PM
  5. Limit number of records in report by group
    By Dr Ennui in forum Reports
    Replies: 0
    Last Post: 06-22-2010, 12:36 AM

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