Create new records for multiple list (2 Viewers)

[Number11]

need to have on a form the option to paste a list of 40 account numbers and have access generate a new record for all?

 

[Uncle Gizmo]

have access generate a new record for all?

How about this?

Create Many Records - Nifty Access

Recordset Loop - Create Records Becoming an MS Access Power User 💪Once you start converting queries into SQL statements – in other words, a string version of the query – you can take that string and manipulate it, extract things from it, and do all sorts of things with it! One of the best stepping

www.niftyaccess.com

If you want a free copy of the sample file, Contact me in a pm a (private message) on access world forums and I will send you a coupon code for a free download

 

[Uncle Gizmo]

In this example I demonstrate how to fill records automatically in a subform:-

Subform Record Duplicator - Nifty Access

Subform Record Duplicator Nifty Access - "Subform Record Replicator" allows you to provide your user with the facility to quickly add sets of duplicate records in a subform. All they need do is specify the number of Records they want to add, select a record to copy, and hey presto you've got a...

www.niftyaccess.com

 

[Pat Hartman]

paste a list of 40 account numbers

Copy/Paste is something we do with spreadsheets and flat files. In a relational database, you can link to the spreadsheet or flat file and use an Append query to copy the data from the file to your table. The append query is a much more reliable method because it allows you to perform certain kinds of error checking on the way in.