How do you design a database to print running numbers from 1 to 10,000 onto labels? Just like printing customers' names, I want to print lets say numbers from 00001 to 10,000 onto labels, so that I can paste them on in-coming documents. I cannot enter 10,000 records in a table and then use it as a record source in the report to print them on labels, there must be a easy way? Pleas help?
How to print running numbers from 1 to 10,000 on labels? (1 Viewer)
- Thread starter Benny Kay
- Start date
- Status
Galphanore
Registered User.
- Local time
- Today, 13:40
- Joined
- Apr 5, 2006
- Messages
- 23
You can do this by having the autonumber primary key field of your main table with the following properties :
New Values : Increment
Format : (00000)
This will save the first record as 00001, second as 00002 and so on. Then, when you want it displayed in a text box just set the format of the text box to 00000, then it will display correctly.
New Values : Increment
Format : (00000)
This will save the first record as 00001, second as 00002 and so on. Then, when you want it displayed in a text box just set the format of the text box to 00000, then it will display correctly.
- Status
