Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2014

    Unanswered: Automated form action to create 25 new entries with increasing cell contents

    Hi all,

    New to this site, and stuck on one fact.

    Trying to create a voucher database, and stuck with some automation.

    Example serial number is A12 000 01
    A12 = Product category (Only 8 categories), and using a separate table and lookup for the form
    000 = Batch serial number, this will be entered by the user in the database form
    01 = Batch voucher number, this is the bit I want to automate (only 25 vouchers per batch)

    When a user uses the form, selects the product category and batch serial number, I want a button to then create 25 entries all with the same information provided, but automatically create the 25 vouchers for the batch. Also if it would be possible to add the 3 separate pieces of info and turn it in to one number. We have the 3 separate parts of the total serial number, some entered and automated, so when the automation is complete, will have 25 serial numbers looking like:
    A12 000 01
    A12 000 02
    A12 000 03
    A12 000 04
    A12 000 05 etc.......

    Sorry if the way I explain it is confusing, just cant seem to get my head around it.


  2. #2
    Join Date
    Apr 2014
    Provided Answers: 35
    Have a table, tVouchersPerBatch, with fld [voucher] 1 thru 25, or string 01 thru 25 (whichever you use)
    at the point on a form where user adds a new batch 000, then run an append query that appends the table tVouchersPerBatch.voucher and the flds, BATCH, serial.
    You will get the 25 new records with the batch and serial. no more, no less.

    Show all for people to fill in in order, but if you dont trust them, show only the lowest voucher not filled in (via query)

Posting Permissions

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