adding multiple records

[warco]

I am creating an inventory database and each entry has an individual invoice # and a few other informative fields. Quite often there will be 20+ entries with consecutive invoice #s and all other fields will be indentical. Is there any way to enter these records into a table without having to enter each invoice one by one.

I was also wondering if their would be a way to make a form button that would duplicate that record for the next record only adding 1 to the invoice #. Kind of like an optional autonumber.

A solution to either of these dilemnas would make my database a success. I have a feeling these problem are very basic, but I have been only using access for 2 days.

 

[Pat Hartman]

Placing three similar posts within 10 minutes, after business hours, will not increase your chances of success. It will simply confuse you as people start replying to the different versions.

There is certainly a way to do what you want but you would need to write code to do it. There is no where near enough information regarding the business rules for anyone to suggest an appropriate solution.

 

[warco]

thank you for you're reply to my question. I only posted multiple threads because I did not see the first two in the forum after I posted them. It is good to know that there is a way to solve my problem. If anyone has tackled similar problems as mine and would like to give me a good starting point it would be much appreciated. I've been researching the use of macros, but I'm not sure if that is the right way to go.

 

[neileg]

Assuming the PK for the invoices is an autonumber, the way I would do it is to run a query that returned the maximum of the PK, ie the last record entered, and the invoice number for that, then add 1 to that and drop this in your text box.

Trouble is, supplier invoices have a nasty habit of being alphanumeric. Incrementing an alpha numeric by one is a bit tricky. Once you have got that sussed, how do you deal with with trailing alphas?