bruceblack
Registered User.
- Local time
- Today, 04:17
- Joined
- Jun 30, 2017
- Messages
- 119
Hello everyone. I would like to know how to partially make a unique number, but also count up. Which is the part where i have trouble
Maybe someone can help me along the way with this?
what i have now is:
This gives me "I1849"
(I+year+week)
But i would like to follow up with 01 to 99 somehow.
So i need to check if value exists + 1, till 99...
Please help!
Maybe someone can help me along the way with this?
what i have now is:
Code:
Dim newnumber As String
newnumber = "I" + Format(Date, "yy") + Format(Date, "ww") +
This gives me "I1849"
(I+year+week)
But i would like to follow up with 01 to 99 somehow.
So i need to check if value exists + 1, till 99...
Please help!