Hi Andy.
Thank you for your reply. The idea of creating patType, sampType and sampNum is interesting. I am not really new in working with databases, I normally work with MySQL/PHP and never played with VBA. That's why even basic things are holding me back.
And yes, you are right, those...
I need to create a customized PID in VBA(MS ACCESS).
For example, a user at a hospital wants to enter a blood test for a patient. The user clicks on a form and submits blood test information. I want to create and store a customized PID(or label) that looks like this: BEQ001G01; BEQ001G02...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.