shevada123
New member
- Local time
- Today, 10:26
- Joined
- Apr 24, 2007
- Messages
- 9
I have a database and enter claim numbers for each claim received. However, this year 08, I want to change the process and have Access automate the claim numbers.
Only one person uses the system at a time.
I would like the number to start at DN-08-000 and increase by 1 every time I enter a claim.
Can someone help me with the correct code because this is not working at all?
I have the DMax code which is:
Dim NxtNo as long
NxtNo = nz(DMax("[claim number]","[claim info]"))
if NxtNo > 0 then
NxtNo = DN-08 + NxtNo 000
else
NxtNo = DN-08-000
endif
me.claim number = NxtNo
Only one person uses the system at a time.
I would like the number to start at DN-08-000 and increase by 1 every time I enter a claim.
Can someone help me with the correct code because this is not working at all?
I have the DMax code which is:
Dim NxtNo as long
NxtNo = nz(DMax("[claim number]","[claim info]"))
if NxtNo > 0 then
NxtNo = DN-08 + NxtNo 000
else
NxtNo = DN-08-000
endif
me.claim number = NxtNo
