Hi
this may seem obvious and glaring me in the face but i can't see it.
I have a form I use for data entry, it needs to generate an id called RO Number and i need it be generated by access starting at number RO129036 and then keep adding sequentially, so RO129037 etc etc.
as i already have data in my DB that i need i cannot just reset any fields
someone suggested having a table with just one field - the numeric part of the RO number so first one would be 129036 -
so i need the form to pull this field, add 1, and then add "RO" at the beginning of it? i have really been struggling with this database, would someone be able to help point me in the right direction?
Thanks :)
this may seem obvious and glaring me in the face but i can't see it.
I have a form I use for data entry, it needs to generate an id called RO Number and i need it be generated by access starting at number RO129036 and then keep adding sequentially, so RO129037 etc etc.
as i already have data in my DB that i need i cannot just reset any fields
someone suggested having a table with just one field - the numeric part of the RO number so first one would be 129036 -
so i need the form to pull this field, add 1, and then add "RO" at the beginning of it? i have really been struggling with this database, would someone be able to help point me in the right direction?
Thanks :)
VBA code to pull data from a different table
0 commentaires:
Enregistrer un commentaire