Hi all,
My name is Andris from the UK, I currently working as a production planner and trying to upgrade our current Goods Intake database to avoid typing errors.
At this moment before progress further, I'm stuck at increment letters in alphabetical order based on the last record added to the table.
In addition to complex things it even more we have and Julian date in the front (Example 125A;125B...).
I have created a custom form to add new records and I have found code for Julian date : Me.ColumnName = Format(DatePart("y", Date), "000") = returns as 3 digit number.
Also, letter increment would go 125a,125b,125c..125.z and goes on to 125aa, 125ab,125ac..and so on until next Day all resets due to new date 126a,126b....
Is there a way how to combine these two?
My name is Andris from the UK, I currently working as a production planner and trying to upgrade our current Goods Intake database to avoid typing errors.
At this moment before progress further, I'm stuck at increment letters in alphabetical order based on the last record added to the table.
In addition to complex things it even more we have and Julian date in the front (Example 125A;125B...).
I have created a custom form to add new records and I have found code for Julian date : Me.ColumnName = Format(DatePart("y", Date), "000") = returns as 3 digit number.
Also, letter increment would go 125a,125b,125c..125.z and goes on to 125aa, 125ab,125ac..and so on until next Day all resets due to new date 126a,126b....
Is there a way how to combine these two?