UPDATE: A few people have mentioned to me that if you go back and delete one of the previous records from that year, then the count is wrong. Yes. That will happen. That's one of the reasons why I always say Don't Delete Data! But if you're going to not listen to me, then use DMax instead, and you'll have to wrap that in an Nz function if none exist. That's again, why I say Don't Delete Data! 599cd.com/DontDelete
HELLO DEAR RICHARD, I HAVE USED YOUR CODE BUT THERE IS A PROBLEM WITH IT LIKE I HAVE TO INSERT THE 2 RECORD BUT AFTER SOME TIME I DELETED THE FIRST ONE NOW YOUR METHOD OF CODE GENERATE THE VOUCHER NO 2 BUT BUT VOUCHER NO 2 IS NOT DELETED, SOLUTION?
UPDATE: A few people have mentioned to me that if you go back and delete one of the previous records from that year, then the count is wrong. Yes. That will happen. That's one of the reasons why I always say Don't Delete Data! But if you're going to not listen to me, then use DMax instead, and you'll have to wrap that in an Nz function if none exist. That's again, why I say Don't Delete Data! 599cd.com/DontDelete
Nice lesson,
how about if I want to use sequential numbers in report, you can say "counting how many reports I print".
Thank you
Interesting question. Post it in the Forum: 599cd.com/AF
0:45. That seems like a very productive chat thread...
Indeed
HELLO
DEAR RICHARD, I HAVE USED YOUR CODE BUT THERE IS A PROBLEM WITH IT LIKE I HAVE TO INSERT THE 2 RECORD BUT AFTER SOME TIME I DELETED THE FIRST ONE NOW YOUR METHOD OF CODE GENERATE THE VOUCHER NO 2 BUT BUT VOUCHER NO 2 IS NOT DELETED, SOLUTION?
Don't Delete Data: 599cd.com/DontDelete - but if you're going to, use DMax instead.