Recent content by Recons

Thank you very much! You are a star! I have adjusted my database and all works now as on your sample.

I guess I'm doing something wrong, I have Run-time error '2485'. I have added your codes and trying to run through Forms On Click "DoCmd.RunMacro NextSeries". The object "127d" would be next on the table so why does it triggers error ?. Many thanks

Hi, I hope I have not confused you about my request this combination of 3 digits and letter is our trace code and its only one of many table fields what will further go to a label/tag for fast tracking in case if there is an issue. Its might not be a VBA coding but like theDBguy said a another...

Hi, I guess it's not about the inventing but complying with current system. I know that this is outdated, but to go with simple autonumber I would need to spend hours in requesting amendments in the current system what is complicated because its different department and this would take ages...

Hi, Unfortunately I can't leave it separately that's company requirements and this is what we have in all documentation, traceability etc.

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...