J
John Ortt
The title of this post is misleading but I couldn't think of better. I wish
to create an Invoice field which automatically increments in a similar way
to the Autonumber field.
The main difference is that I would like the numbers to increment from the
highest value currently in the table (not the highest there has ever been)
as with a true autonumber.
I am wanting to create an Incrementing Invoice Number on a table based on
the previous numbers.
The company format for the invoices is three letters followed by an
incrementing seven digit number
eg. XXX0000001, XXX0000002,......XXX0000100 etc.
Many of these are usually recieved as excel spreadsheets... I copy the data
off the sheet and paste them in as new records.
I have managed to create a form which generates the number and allows me to
add them one at a time but I would prefer to paste them all at once into the
table..
Is it possible to paste numerous entries at once and have them automatically
update the InvoiceNumber field as the Autonumber would do, and if so how?
Thanks in advance for your help,
John.
to create an Invoice field which automatically increments in a similar way
to the Autonumber field.
The main difference is that I would like the numbers to increment from the
highest value currently in the table (not the highest there has ever been)
as with a true autonumber.
I am wanting to create an Incrementing Invoice Number on a table based on
the previous numbers.
The company format for the invoices is three letters followed by an
incrementing seven digit number
eg. XXX0000001, XXX0000002,......XXX0000100 etc.
Many of these are usually recieved as excel spreadsheets... I copy the data
off the sheet and paste them in as new records.
I have managed to create a form which generates the number and allows me to
add them one at a time but I would prefer to paste them all at once into the
table..
Is it possible to paste numerous entries at once and have them automatically
update the InvoiceNumber field as the Autonumber would do, and if so how?
Thanks in advance for your help,
John.