By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 2,606 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Increment Transaction NO.

P: 54
Can anyone help me how to use the increment in auto number field?
Feb 26 '07 #1
Share this Question
Share on Google+
5 Replies


100+
P: 1,646
Hi. this is from access help:
Create a field that automatically generates numbers
Open a table in Design view.


To insert the field within the table, click in the row below where you want to add the field, and then click Insert Rows on the toolbar.
To add the field to the end of the table, click in the first blank row.

In the Field Name column, type the name for the field, following Microsoft Access object-naming rules.


In the Data Type column, click the arrow and select AutoNumber.


To create an incrementing AutoNumber, leave the property settings in the bottom part of the window as they are (the FieldSize property is set to Long Integer and the NewValues property is set to Increment by default).
To create a random AutoNumber, in the bottom part of the window on the General tab, set the NewValues property to Random. For more information on the types of AutoNumber fields you can create, including fields for database replication, click .

Set the other field properties, if desired.
Feb 26 '07 #2

P: 54
Hi. this is from access help:
Create a field that automatically generates numbers
Open a table in Design view.


To insert the field within the table, click in the row below where you want to add the field, and then click Insert Rows on the toolbar.
To add the field to the end of the table, click in the first blank row.

In the Field Name column, type the name for the field, following Microsoft Access object-naming rules.


In the Data Type column, click the arrow and select AutoNumber.


To create an incrementing AutoNumber, leave the property settings in the bottom part of the window as they are (the FieldSize property is set to Long Integer and the NewValues property is set to Increment by default).
To create a random AutoNumber, in the bottom part of the window on the General tab, set the NewValues property to Random. For more information on the types of AutoNumber fields you can create, including fields for database replication, click .

Set the other field properties, if desired.

Ok il try thanks
Feb 26 '07 #3

P: 54
Hey dude it helps a lot, but what if i want a formatted increment field like for example the default variable is 1 - i want it to be formatted as PC00001 (increment) and so on..?how can i do that?
Feb 26 '07 #4

100+
P: 1,646
Hey dude it helps a lot, but what if i want a formatted increment field like for example the default variable is 1 - i want it to be formatted as PC00001 (increment) and so on..?how can i do that?
You can create a field that you increment yourself in code by checking the last record and updating the new record with whatever you like.
Feb 26 '07 #5

NeoPa
Expert Mod 15k+
P: 31,186
Hey dude it helps a lot, but what if i want a formatted increment field like for example the default variable is 1 - i want it to be formatted as PC00001 (increment) and so on..?how can i do that?
In case WillAKAWill's answer left any doubt, an Autonumber field does a particular job and is well defined. It cannot be used as an automatic sequencer in a table. Should you require this functionality you will need to implement that separately.
Feb 26 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.