Dear All,
I would like When the invoice status is selected approve, an invoice number is given.
Now an invoice number is given with all entered words, do you know how this can be solved
Thank you in advance
Dear All,
I would like When the invoice status is selected approve, an invoice number is given.
Now an invoice number is given with all entered words, do you know how this can be solved
Thank you in advance
why not just use AUTONUMBER?
you don't have to do anything since its created when the record is made.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
@WGM - some people don't seem to care about that
https://www.accessforums.net/showthread.php?t=83637
https://www.accessforums.net/showthread.php?t=84539
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.