Results 1 to 6 of 6
  1. #1
    KRa is offline Novice
    Windows XP Access 2016
    Join Date
    Jan 2020
    Posts
    3

    Autonumber register

    Hi everybody! As I’m new at this forum I apologize in case my question was already answered before.


    I’m designing an invoice manage database and I need to get the first invoice number from a table in which I register the authorized block of invoices (by the Treasury and just for defined period of time). Then, for new created invoices, correlative numbers … could someone help me on this? Thanks in advance!

  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
    16,716
    You mention Autonumber which is a special "thing" in MS Access.
    I suggest you review this link Autonumbers -What they are not for reference.

  3. #3
    KRa is offline Novice
    Windows XP Access 2016
    Join Date
    Jan 2020
    Posts
    3
    Quote Originally Posted by orange View Post
    You mention Autonumber which is a special "thing" in MS Access.
    I suggest you review this link Autonumbers -What they are not for reference.
    Many thanks for your reply...

    Now I realize I shouldn't use "autonumbers" since my doubt is actually related to the fact that I need to get the first invoice number from a table which contains just the first and the last numbers of an approved block of invoices. Then, for following registers, I need a series of correlative numbers.

    Thanks again! KRa

  4. #4
    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
    16,716
    Try searching the forum using "sequential identifiers" to review some existing threads/posts.
    Here is one that may be helpful.

  5. #5
    KRa is offline Novice
    Windows XP Access 2016
    Join Date
    Jan 2020
    Posts
    3
    Thank you orange "moderator"! I gona take a look at that forum... thanks again!

  6. #6
    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
    16,716
    Can you tell us more about your application? There may be other posts or articles relevant to your project, but we need a little more info.
    Good luck.

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

Similar Threads

  1. Cannot register value to table
    By nasps in forum Forms
    Replies: 9
    Last Post: 10-11-2019, 02:53 PM
  2. Student Attendance Register
    By faiz786 in forum Access
    Replies: 6
    Last Post: 05-04-2017, 02:56 PM
  3. Replies: 4
    Last Post: 11-21-2013, 05:06 PM
  4. Duplicate Register
    By maluna in forum Access
    Replies: 1
    Last Post: 09-28-2010, 12:45 AM
  5. Attendency register in a database
    By pp100 in forum Access
    Replies: 2
    Last Post: 08-31-2010, 06:51 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