470,831 Members | 2,466 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Serial Number

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 1561
358 Expert Mod 256MB
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
32,311 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 mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.