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!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Unique numbers in Purchase Orders
- Thread starter yogiyosh
- Start date
Do you store the values in a database? If so you could use a unique id assigned to that record.
If not, do your users log into your system? If they do you could use something like their username and the current date/time.
----------------------------------------------------------------------
Need help finding an answer?
Try the search facilty ( or read FAQ222-2244 on how to get better results.
If not, do your users log into your system? If they do you could use something like their username and the current date/time.
----------------------------------------------------------------------
Need help finding an answer?
Try the search facilty ( or read FAQ222-2244 on how to get better results.
- Thread starter
- #3
No probs. If you do use a database you could still do it the same way i.e the ID field starts at 1 and increments by 1 each time. Each time a new order is placed you write it out to the word file as:
where id is the value of the record in the database.
If you don't use a database then that is still OK but you will have to decide where you store this number (it has to be somewhere where it can be read and updated). Possibilities are a registry entry (you read it, assign it to the order and then update it to add 1 to its value) or maybe even a text file (same scenario as above).
No matter which way you do it, the procedure of doing it is basically the same, it's just up to you how you prefer to do it.
----------------------------------------------------------------------
Need help finding an answer?
Try the search facilty ( or read FAQ222-2244 on how to get better results.
Code:
OrderNumber = "C0" & rs("ID")If you don't use a database then that is still OK but you will have to decide where you store this number (it has to be somewhere where it can be read and updated). Possibilities are a registry entry (you read it, assign it to the order and then update it to add 1 to its value) or maybe even a text file (same scenario as above).
No matter which way you do it, the procedure of doing it is basically the same, it's just up to you how you prefer to do it.
----------------------------------------------------------------------
Need help finding an answer?
Try the search facilty ( or read FAQ222-2244 on how to get better results.
- Thread starter
- #5
- Status
Similar threads
