SlingerJM
Last Activity: Oct 13 '15, 11:47 AM
Joined: Apr 21 '15
Location:
-
I spent three days searching the internet for a solution to my problem. I had some help from our IT expert and I now have a solution. First, let me repeat what I needed. I needed a Condition Report(CR) Number which will drive my database. I created a field "CR Number". I needed information in that field to be prefixed with the current year, by last two digits, a hyphen, and a sequencing number that reverts back to 0001 at the beginning... -
From SlingerJM:
I saw the [CODE/], tried it but could not figure it out. So simply did it the old fashion way. I am not a code writer so I doubt I will be submitting anything again; however, this one perplexed me and as much searching has I have done, I saw there were many others in same situation. So since I had a solution that worked, I thought I would share it in the only way I knew how. Thanks for your help on making it correct for...Last edited by zmbd; Oct 25 '15, 05:04 AM. Reason: [z{NO Edit: Cut and paste code, select the code, click on the [CODE/] format like you would for bold or underline - voici c'est accompli :) }]Leave a comment:
-
I spent three days searching the internet for a solution to my problem. I had some help from our IT expert and I now have a solution. First, let me repeat what I needed. I needed a Condition Report(CR) Number which will drive my database. I created a field "CR Number". I needed information in that field to be prefixed with the current year, by last two digits, a hyphen, and a sequencing number that reverts back to 0001 at the beginning...Last edited by zmbd; Apr 22 '15, 07:32 PM. Reason: [z{merged the three related into one}{use the code format for script}{removed the unneeded "indent" example - stepped the code}]Leave a comment:
-
Yes, I saw those threads, tried their solutions, esp NeoPa's, did not work for me.Leave a comment:
-
Annual Serial Number using Macro Solution
Real new to Access 2010. Condition Report system identifies new entries as YY-####, ex, 15-0031. I need a field "CR Number" to automatically produce this format for a new record. This then becomes the main (controlling) field for all forms and reports. I started with "CR Number" as an autonumber with a prefix in 'format' "15-"0000. However, when query for forms, would not accept prefix. Condition Report 15-0009...
No activity results to display
Leave a comment: