Recent content by AuburnDesigner

Okay, I did some more research and came up with the following code. It appears to work the way I want it to, but I just want to verify to make sure it looks correct to a trained eye. And What issues might I have in the future with the way this code is set up? Me.BaseID =...

How would you set up the highest number? Would it be a previous part number or a new table? I have tried and tried to get this to work, but Im still lost on the lookup and highest number method. Any tips? Thanks in advance.

"dmax doesnt "steal a number" it simply asks what the higest number is in the file." With this point I was trying to state that I had read that if two users are using the same database, that DMax will assign the next highest number, but If two users are trying to grab the next highest number at...

I am a Product designer and not very familiar with Access. I am completely out of my element when it comes to coding, but I am trying to create a Intelligent Part Number Structure. I understand that IPN's are not desired when creating a part number, but I do not have the option in this case, as...