Software

Ask something
Discussion Locked

Ms Access 2000

0 helpful
1 reply

by sallyha4906

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
After I entered all datas in the table and saved it, I usually don't use a primary key's, instead I choose auto nos. But when it come to report, some of the nos were not running. It happened every time I chosed auto nos. Can you tell what went wrong?

1 reply

by techsupportspecialist

I can't be 100% what went wrong because I don't have your database in front of me, but I would suggest checking the following:

1) Make sure your AUTONUMBER field is the primary key in design view.
2) Make sure the 'Data Type' is AUTONUMBER.
3) 'Field Size' should equal Long Integer.
4) 'New Values' should equal Increment.
5) 'Indexed' should equal Yes (No Duplicates).
6) Make sure your query, form, or report is bound to the correct field. It is possible to inadvertantly make the field unbound.

I hope this helps. Good luck.

This discussion is closed to new replies.