468,167 Members | 1,896 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,167 developers. It's quick & easy.

Serial Number

Hello,
access 2010.

I would like to enter the serial number following criteria:
year (21) month (xx) 0000 (progressive).

It must automatically generate it in the order form.

Thanks so much
Mar 9 '21 #1
2 1380
isladogs
232 Expert 128KB
The easiest way is just to use an auto number field 1, 2, 3 etc and then format the form control to add the rest of the information for display purposes only.
Mar 9 '21 #2
NeoPa
32,042 Expert Mod 16PB
You may find the Item Numbering Within a Group article helpful with that. We may be able to give more specific help if you still need it and reply with what you've managed so far and where you're stuck - but not without of course.
Mar 10 '21 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

15 posts views Thread by tom | last post: by
5 posts views Thread by | last post: by
reply views Thread by kamranasdasdas | last post: by
reply views Thread by gcreed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.