Alpha Video Training
Results 1 to 4 of 4

Thread: Sequential Number Product Labels

  1. #1
    Member
    Real Name
    Tom Causey
    Join Date
    Jun 2000
    Posts
    58

    Default Sequential Number Product Labels

    Our company offers some products that have sequential numbering. Each product is packaged in some quantity of product per unit. And we place a label on each unit that has the starting number and the ending number for the sequential numbers of the products in that package. We have had someone entering each of these numbers manually and I was asked to come up with a more automated way to do this. However, I'm not even sure where to start so I thought I would see if anyone had thoughts or suggestions.

    I have A5V8 Enterprise and 5-User Runtime Plus and would like to create a desktop solution that does the following:

    User Input with Sample Data

    Start Number: 0437001 (must keep leading 0's and number of digits could be between 4 and 9 digits)

    Items per Unit: 100 (number of items per unit could vary from 100 to 5,000)

    Units: 9 (units = number of labels)

    Label: Avery 5160 (1" x 2-5/8" labels are currently used but it would be great if I could provide other options that could be selected from the main form)

    Print Preview / Print

    Sample Label Output

    0437001-0437100 | 0437101-0437200 | 0437201-0437300

    0437301-0437400 | 0437401-0437500 | 0437501-0437600

    0437601-0437700 | 0437701-0437800 | 0437801-0437900

    Once agian, if anyone has any thoughts or suggestions about how this can be accomplished that would be very much appreciated.

    Thank You,

    Tom

  2. #2
    "Certified" Alphaholic Tim Kiebert's Avatar
    Real Name
    Tim Kiebert
    Join Date
    Jul 2004
    Location
    Geelong, Victoria, Australia
    Posts
    2,785

    Default Re: Sequential Number Product Labels

    This should give you some ideas.
    Tim Kiebert
    Eagle Creek Citrus
    A complex system that does not work is invariably found to have evolved from a simpler system that worked just fine.

  3. #3
    Member
    Real Name
    Tom Causey
    Join Date
    Jun 2000
    Posts
    58

    Default Re: Sequential Number Product Labels

    Tim,

    This is perfect!

    At some point I may add additional features to this to allow for further automation. But compared to the manual data entry they've been doing, the solution you created is already an amazing leap forward. I will study what you did more carefully but I can already say that this meets our immediate needs.

    Thank You!

    Tom

  4. #4
    "Certified" Alphaholic Tim Kiebert's Avatar
    Real Name
    Tim Kiebert
    Join Date
    Jul 2004
    Location
    Geelong, Victoria, Australia
    Posts
    2,785

    Default Re: Sequential Number Product Labels

    Tom,

    Your welcome.

    Oh, by the way just send cheque or money order to..... Just kidding:D

    Glad to help. Enjoy
    Tim Kiebert
    Eagle Creek Citrus
    A complex system that does not work is invariably found to have evolved from a simpler system that worked just fine.

Similar Threads

  1. Sequential number
    By Judith in forum Alpha Five Version 7
    Replies: 4
    Last Post: 04-03-2007, 07:03 AM
  2. How to count and record the number of times a product is downloaded?
    By Daves in forum Web Application Server v7
    Replies: 2
    Last Post: 06-30-2006, 04:33 PM
  3. Sequential number updating within a selection of records.
    By trackmanpete in forum Alpha Five Version 7
    Replies: 3
    Last Post: 11-24-2005, 05:10 PM
  4. Sequential number on A5 report - how?
    By brett s in forum Alpha Five Version 5
    Replies: 3
    Last Post: 12-20-2004, 06:17 AM
  5. Number Of Labels To Print
    By Phil Rolf in forum Alpha Five Version 4
    Replies: 2
    Last Post: 05-01-2001, 04:46 PM

Bookmarks

Posting Permissions

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