Results 1 to 4 of 4

Incrementally Numbering each new report

  1. #1
    Rogeman is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Nov 2018
    Posts
    2

    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,538
    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.
    Using Access 2007
    Proficient in Access, Excel, VBA, and SQL

  3. #3
    Rogeman is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Nov 2018
    Posts
    2
    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,538
    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.
    Using Access 2007
    Proficient in Access, Excel, VBA, and SQL

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, 10:54 AM
  2. Replies: 9
    Last Post: 08-25-2015, 12:04 PM
  3. Help with numbering
    By hudsonp in forum Access
    Replies: 3
    Last Post: 11-21-2012, 07:55 AM
  4. incrementally slower routine -- vba
    By bill shockley in forum Access
    Replies: 2
    Last Post: 07-01-2012, 01:12 PM
  5. having a field which incrementally serializes
    By Kevin in forum Programming
    Replies: 1
    Last Post: 03-03-2010, 11:30 PM

Posting Permissions

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