Results 1 to 4 of 4
  1. #1
    Rogeman is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Nov 2018
    Posts
    9

    Incrementally Numbering each new report


    Hi,

    I am printing a report which I then send to a club treasurer, to keep track of our records I would like to number each report, although they may be sent many days apart.
    I could possibly use a text box to input the numbers manually, but not to sure how to achieve this or whether it would work anyway.
    Alternatively VBA May be the answer but I would like some guidance if possible.
    To print the report I use a query from a table using a command button.
    All of my searches only give page numbering.

    Any help will be much appreciated.

    Thanks

    Roger

  2. #2
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    How about just using a DateStamp on the report?
    That would guarantee a unique value (as long as you don't do it more than once a day).

    So, for today, it would show: 20181107

    Otherwise, if needs to be incremental, with no gaps, then create a table where you record the number. You can create a macro or script to update that, and then you just need to be sure to call/run that when you are creating a report.

  3. #3
    Rogeman is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Nov 2018
    Posts
    9
    Thanks JoeM,
    I had used the date format but have been asked to number them as well, just to make life more interesting I suppose.

    I will try your table method, thanks.

    Roger

  4. #4
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    You may be able to incorporate something like this: https://www.techonthenet.com/access/...utoinc2007.php

    I would probably have two fields in this able - the auto-incremented field, and a date field, in which the current date is captured.

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

Similar Threads

  1. Report numbering and opening
    By alarm_guy1 in forum Access
    Replies: 3
    Last Post: 03-30-2016, 11:54 AM
  2. Replies: 9
    Last Post: 08-25-2015, 01:04 PM
  3. Help with numbering
    By hudsonp in forum Access
    Replies: 3
    Last Post: 11-21-2012, 08:55 AM
  4. incrementally slower routine -- vba
    By bill shockley in forum Access
    Replies: 2
    Last Post: 07-01-2012, 02:12 PM
  5. having a field which incrementally serializes
    By Kevin in forum Programming
    Replies: 1
    Last Post: 03-04-2010, 12:30 AM

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