Recent content by rnash

Thanks! that worked great. Such a simple solution.

I follow the code just fine as I have some experience with VB but I am new to access. I am having trouble getting the code to execute properly. I copied the code into a new module and clicked run. You said that I needed to put the Gen_no() values somewhere. Is this the same thing you are...

I would like to know how to generate a table of unique part numbers in access using the following template: ABC-DE where possible entries for each letter are: A=1,2,3,4,5 B=CD,ER,FF,FE C=A,B D=43,23,12 E=1,11,111,1111 A sample part number would be 1CDA-431. What is the best way of...