Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Create AutoNumber

Status
Not open for further replies.
ryan1

ryan1

Programmer
May 15, 2002
106
US
I'm trying to create a 4 digit, auto count from a number field in a table. I know how to find the max number and add one. But i do not know how to create a 4 digit number. Need help
 
Sort by date Sort by votes
Add a field (Sequence) to your table and a control on your form(?) bound to it

Dim Seq As Integer

Seq = DMax("[Sequence]", "[Your Table Name]") + 1

Me![Your field name] = Format(Seq, "0000#")
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ziffer68
  • Locked
  • Question
Pass Through query to create an alias for DB2 member
Replies
0
Views
2K
ziffer68
ziffer68
Johnny S
  • Locked
  • Question
Create folder based on ID field MS Access
Replies
3
Views
273
MattGreer
MattGreer
GShen
  • Locked
  • Question
create Excel file using stored procedure
Replies
2
Views
168
GShen
GShen
Moss100
  • Locked
  • Question
Create a repeating Diary Appointment 2
Replies
5
Views
99
dhookom
dhookom
lameid
  • Locked
  • Question
Error creating object in Class module - 429 ActiveX component can't create object
Replies
10
Views
306
lameid
lameid

Part and Inventory Search

Sponsor

Back
Top