F
Frank Stone
i had a similar problem some years back. I solved it by
creating a small table with only 1 record in it. I called
the table nexnum. The record was nnum and the fields were
the 3 product families we had at the time. The record held
the next number for each product fammily. When i clicked
the new button, the form asked for the product family.
that told the code which field to get the next number
from. The code then concatenated my product family entry
with the next number. I was using an unbound form and a
temp table. all work was done in the temp table. just
after saving the record i.e. tranfering the content of the
temp table to the main table, code then went and added 1
to the appoprate product family field. in essence, the
table was remembering the next number for each product
family. I would send the code i used but i don't have the
database any more. sorry.
but with this idea, maybe you can work something up. good
luck.
is based on a project number (ex: 2004-99) and a
sequential purchase order number suffix (ex: 008)
order. I already have the query that creates the prefix
(using the RIGHT function). I've copied the code used this
article mentioned in an earlier post
http://support.microsoft.com/default.aspx?scid=kb;en-
us;210194 to generate sequential suffix numbers.
creating a small table with only 1 record in it. I called
the table nexnum. The record was nnum and the fields were
the 3 product families we had at the time. The record held
the next number for each product fammily. When i clicked
the new button, the form asked for the product family.
that told the code which field to get the next number
from. The code then concatenated my product family entry
with the next number. I was using an unbound form and a
temp table. all work was done in the temp table. just
after saving the record i.e. tranfering the content of the
temp table to the main table, code then went and added 1
to the appoprate product family field. in essence, the
table was remembering the next number for each product
family. I would send the code i used but i don't have the
database any more. sorry.
but with this idea, maybe you can work something up. good
luck.
generate unique purchase order numbers. The number prefix
is based on a project number (ex: 2004-99) and a
sequential purchase order number suffix (ex: 008)
separately and then concatenate them for the purchase
order. I already have the query that creates the prefix
(using the RIGHT function). I've copied the code used this
article mentioned in an earlier post
http://support.microsoft.com/default.aspx?scid=kb;en-
us;210194 to generate sequential suffix numbers.
everytime there is a new project number?