I've a field, say "Invoice No.", i want to be this as an auto-generated number.
like DLP/001/2013-2014 DLP/002/2013-2014 DLP/003/2013-2014 .
I use vb6 and Access.how can i do this?
subrata.roy.7583992
0
Newbie Poster
Recommended Answers
Jump to PostDLP/001/2013-2014
DLP/002/2013-2014
DLP/003/2013-2014I don't recomended to make autonumber to an Id like this but you can split it.
Get the Last Invoice number from database and Split it by "/". Extract the second value in array and you will get the existing invoice num. Add it by …
All 2 Replies
Jx_Man
987
Nearly a Senior Poster
Featured Poster
ITKnight
commented:
.
+2
subrata.roy.7583992
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.