GaryB
06-03-2004, 06:33 AM
I really need some help with this. It has been driving me nuts, so I'm hoping that someone out there may have a brilliant solution.
I have a form that creates job folders for us and currently it is autonumbered. What I need it to have sequence numbering that is editable so I can modify and duplicate the number. For example, if the number is 12345 and the next number is 12346, I sometimes need to change the next number to 12345b and so on. What happens is, we sometimes get jobs that are multi-part and I need to create, lets say 3 job folders, that need to be numbered 12345A, 12345B, 12345C. I don't need the lettering automated, just the numbering editable so I can change it to suit our needs. Oh, one more thing, I have about 6000+ records that are already numbered and I can't lose that numbering. So whatever we come up with has to continue the sequence from the last numbered record. Easy, Huh! - HA. Well, if anyone feels up to this challege, it would certainly be greatly appreciated.
SOLVED THE PROBLEM: IN THE TABLE -ORDERENTRY- I CHANGED THE AUTONUMBER TO A TEXT BOX.
THEN IN THE FORM I ADDED =DMax("JOBID","ORDERENTRY")+1 TO THE DEFAULT VALUE UNDER DATA. WHAT THIS DID: IT ALLOWED THE AUTONUMBERING TO CONTINUE FROM THE LAST NUMBER I ENTERED AND ALSO ALLOWS THE NUMBER TO BE EDITABLE.
NOTE: IF YOU ADD A LETTER AFTER THE NUMBER WHEN THE NEXT RECORD COMES UP IT WILL SHOW ERROR IN THE NUMBER FIELD. ALL YOU HAVE TO DO IS TYPE IN THE NEXT NUMBER AND IT WILL CONTINUE NUMBERING FROM THAT INPUT.
GARY
Thanks
Gary
I have a form that creates job folders for us and currently it is autonumbered. What I need it to have sequence numbering that is editable so I can modify and duplicate the number. For example, if the number is 12345 and the next number is 12346, I sometimes need to change the next number to 12345b and so on. What happens is, we sometimes get jobs that are multi-part and I need to create, lets say 3 job folders, that need to be numbered 12345A, 12345B, 12345C. I don't need the lettering automated, just the numbering editable so I can change it to suit our needs. Oh, one more thing, I have about 6000+ records that are already numbered and I can't lose that numbering. So whatever we come up with has to continue the sequence from the last numbered record. Easy, Huh! - HA. Well, if anyone feels up to this challege, it would certainly be greatly appreciated.
SOLVED THE PROBLEM: IN THE TABLE -ORDERENTRY- I CHANGED THE AUTONUMBER TO A TEXT BOX.
THEN IN THE FORM I ADDED =DMax("JOBID","ORDERENTRY")+1 TO THE DEFAULT VALUE UNDER DATA. WHAT THIS DID: IT ALLOWED THE AUTONUMBERING TO CONTINUE FROM THE LAST NUMBER I ENTERED AND ALSO ALLOWS THE NUMBER TO BE EDITABLE.
NOTE: IF YOU ADD A LETTER AFTER THE NUMBER WHEN THE NEXT RECORD COMES UP IT WILL SHOW ERROR IN THE NUMBER FIELD. ALL YOU HAVE TO DO IS TYPE IN THE NEXT NUMBER AND IT WILL CONTINUE NUMBERING FROM THAT INPUT.
GARY
Thanks
Gary