How can I start Autonumber with 0001 in MS Access

[Guest]

 

[Lynn Trapp]

Set the Format property of the field to 0000.

For future reference, please ask your questions in the body of the message
rather than in the subject.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Joseph Meehan]

I suggest you may not want to use Autonumber for that use. Autonumbers
are designed to provide unique numbers. It in not designed to provide
numbers in order and for a number of reasons may not do so. As a result
using them in any application where the user sees the numbers is likely to
end up with confusion.

There are other ways of providing the numbers you want depending on the
particual application.

 

[Guest]

So what are those ways? She obviously needs the number for a particular
reason in Access, so please assist?

 

[John Vinson]

So what are those ways? She obviously needs the number for a particular
reason in Access, so please assist?

One way is to use a Number... Long Integer for this field, instead of
any type of Autonumber.

Use a Form to do ALL data entry to the table. Have a textbox bound to
this ID field, let's call it txtID, with a Format property of "0000"
to force leading zeros (the number 1 and the number 0001 *are the same
number* just displayed differently).

In the Form's BeforeInsert event put code like:

Private Sub Form_BeforeInsert(Cancel as Integer)
Me!txtID = NZ(DMax("[ID]", "[tablename]")) + 1
End Sub

John W. Vinson[MVP]