Generate Auto Number Values

[jeanhurtado]

Hi. my name is Jean and I trying to finish my project that is a Cycle
Count program in Access. My problem now is that I have a table with a
field called "Ticket Number" this number was generated by the
Autonumber feature in the Cycle Count tickets. I now have to change
that because I need to continue using the last number of the old Cycle
Count program in "Excel". I have a form called "CYCLECOUNTTICKETS"
that generate the ticket number in the table. I need help creating
that code in the form so when I click the "ok" button generates 100
tickets number from the number 075000. We generate daily 100 cycle
count tickets.

Example:

075000,075001,075002,......0705100.


Can you help me?Thanks for your cooperation.


-Jean C.

 

[storrboy]

Hi. my name is Jean and I trying to finish my project that is a Cycle
Count program in Access. My problem now is that I have a table with a
field called "Ticket Number" this number was generated by the
Autonumber feature in the Cycle Count tickets. I now have to change
that because I need to continue using the last number of the old Cycle
Count program in "Excel". I have a form called "CYCLECOUNTTICKETS"
that generate the ticket number in the table. I need help creating
that code in the form so when I click the "ok" button generates 100
tickets number from the number 075000. We generate daily 100 cycle
count tickets.

Example:

075000,075001,075002,......0705100.

Can you help me?Thanks for your cooperation.

-Jean C.

In the 97 help files (not sure about newer versions) there is a topic
outlining how to (re)set the starting number of an autonumber field.
Would that work?

 

[jeanhurtado]

In the 97 help files (not sure about newer versions) there is a topic
outlining how to (re)set the starting number of an autonumber field.
Would that work?- Hide quoted text -

- Show quoted text -

I have to eliminate the Autonumber because I need to start the program
with the 075000 ticket number and increased by 1 until 100. I need to
create a code in the form that generate 100 tickets number in a daily
basis begining with 075000 number.

 

[storrboy]

I have to eliminate the Autonumber because I need to start the program
with the 075000 ticket number and increased by 1 until 100. I need to
create a code in the form that generate 100 tickets number in a daily
basis begining with 075000 number.

Probably the most common way is to create a table that stores either a
list of assigned numbers, or the last assigned. You would query that
table, get the next available number, use it to create the record(s)
and write back the used (or last used) number as the next starting
point. However in a multiuser environment, you need to plan this
carefully as there can still be gaps and even conflicts in the custom
used numbers.