Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2011
    Posts
    13

    Unanswered: Assigning Sequential Number Multi User

    Help.

    Can someone show me how to get the next available number, add 1, save the new number?

  2. #2
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    119
    What number are you starting from - is it a number in a table?
    Why don't you just use an autonumber?
    Regards
    JD

    Software-Matters

  3. #3
    Join Date
    Dec 2011
    Posts
    13
    Here is my non-vba approach:

    1. Created a table with only one record, it holds the serial number (numeric).
    2. Created a table that holds new record with sequential numbers.
    3. Created an update query that increments the serial number by one.
    4. Created an append query for data entry
    5. Created a form for data entry, it has an embedded macro On Open, that opens the update query and adds 1 to the serial number. The field that requires the SN, i use DMAX("SN","tblSerial"). Record Locks set to All Records.
    6. On the form, a button has an embedded macro On Click that runs the append query, adding the record to the table that holds records.

    Tested it with two users creating a document number that requires unique serial numbers.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •