Access Custom Serial Number Generator. I would like to create a custom Serial number for a few Tables I have. I would like it to show like this. HCPV R XXXXX 0. HCPV R Would be static. XXXXX would be the current Julian Date as in YYDDDAnd 0. I would end up putting this tbl. Integer In Vba CodeRental and would exist in Rental. ID field. There would be one almost Identical in tbl. Tenant and would exist in Tenant. Convert To Number In VbaI need the column A to have serial numbers, once the. Code for auto generate serial number. Autogenerate Serial Number. When I enter a Student name it will automatically generate its Serial number in the place. Auto generated save excel file name VBA. This is the snippet A Serial Number Generator and Checker on FreeVBCode. The FreeVBCode site provides free Visual Basic code, examples, snippets, and articles on a. ID as well as the same in tbl. Lease in Lease. IDTenant. ID would start with HCPV T and Lease. Adobe Photoshop Elements 12 Full Crack. ID would be HCPV L I know this would probably be done with a module but havent had any luck in creating it myself. Thanks in advance for your help. Stuart. HCPV. accdb.