Results 1 to 2 of 2
  1. #1
    jlgray0127 is offline Competent Performer
    Windows 7 64bit Access 2003
    Join Date
    Oct 2011
    Location
    Central Illinois
    Posts
    187

    Sequential numbers...

    So... the down and dirty... I'm writing a program for scheduling multiple production lines which will be used my multiple users... not a big deal for me, with the exception I'm just really starting to mess with VBA.
    Here is what I want to do. I have a daily schedule by line. There are multiple parts being built on this line in a day. Lets say there can be up to 40 or so units, each with a unique serial number.
    The way this is set up, the scheduler goes in, sees the units that are available to schedule. They assign a date and a sequence to build this. In the background, I after they assign the date and the sequence they want the unit built in, I have an Afterupdate Event that takes the line, the date and the sequence and makes a unique record. I was doing this so I had a unique sequence for this line and date. So they could not schedule more than one unit per day.
    This would work, but I need a way to set it so the scheduler can easily change the sequence.

    If we are building an A1A (sequence 1) and an A1B (sequence 2), they can change the A1A sequence from 1 to 2, and this will delete the sequence 2 for the A1B, so they HAVE TO resequence A1B.


    Any thoughts on how I might accomplish this?

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,848
    Do you have a clear list of "Business facts"?
    Do you have a data model that supports your "business facts"?
    Do you have a clear description - in plain English - of what you are trying to do?

    I find this to be "jargonese"
    If we are building an A1A (sequence 1) and an A1B (sequence 2), they can change the A1A sequence from 1 to 2, and this will delete the sequence 2 for the A1B, so they HAVE TO resequence A1B.
    Any thoughts on how I might accomplish this?
    I'm sure it means something to you. But the readers here are really the average person on the street, no real appreciation for re-sequencing A1B.

    A clear definition of "line", "part", "unit" , "sequence" would be helpful to the reader also.

    The last chance you have to check if a proposed record already exists, or to decide if something should be rejected is in the BeforeUpdate (usually).

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

Similar Threads

  1. Sequential Numbers
    By cactuspete13 in forum Queries
    Replies: 5
    Last Post: 03-27-2013, 12:14 PM
  2. Generating sequential numbers automatically
    By Malcolm41 in forum Access
    Replies: 2
    Last Post: 07-15-2012, 08:20 PM
  3. auto enter sequential numbers
    By normie in forum Access
    Replies: 5
    Last Post: 05-25-2012, 10:38 AM
  4. To generate sequential numbers in query
    By lizzywu in forum Programming
    Replies: 1
    Last Post: 03-02-2012, 12:01 PM
  5. How to add sequential numbers to query resultset
    By h_latha2k in forum Queries
    Replies: 3
    Last Post: 04-29-2011, 08:53 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
  •  
Other Forums: Microsoft Office Forums