I have a table with completed, active and inactive projects.
basically the projects that are completed or active do not need job numbers.
but the inactive projects once they turn active I would like to assign them a job number.
as this used to be manual the next number to be used is 2180.
BUT! I dont want it as an autonumber as that will give incorrect number to the older completed projects.
so... is there some code I can write to do the following:
last number used is 2179.
if button (or whatever event procedure) is clicked put "last number" +1 into job number textbox.
Therefore job number textbox now equals 2180. and that is saved on the datatable.
So the last number will have to update each time and be stored. To amke each new active project a new unique number.
any ideas anybody???
ta
John
basically the projects that are completed or active do not need job numbers.
but the inactive projects once they turn active I would like to assign them a job number.
as this used to be manual the next number to be used is 2180.
BUT! I dont want it as an autonumber as that will give incorrect number to the older completed projects.
so... is there some code I can write to do the following:
last number used is 2179.
if button (or whatever event procedure) is clicked put "last number" +1 into job number textbox.
Therefore job number textbox now equals 2180. and that is saved on the datatable.
So the last number will have to update each time and be stored. To amke each new active project a new unique number.
any ideas anybody???
ta
John