copy multiple records with sub - How To Build a Reservation System and Copy Orders With Details Using Recordsets in Microsoft Access


	Back to Access Developer 24 Lessons Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

copy multiple records with sub

Ludwig Willems

2 years ago

Richard, in Developer 24 we see how we can copy 1 record on a form with its subform and copy it at the bottom into a new record.
Now I have various subdivisions of cabinet modules that keep coming back where some fields need to be adjusted. This is about hundreds of records. It would be a waste of time to enter all these characters again as only a few pieces of data need to be changed each time. My intention would be to copy, for example, 150 records specifying which numbers and paste them back underneath to make some adjustments here and there so that I don't have to enter everything back. The intention is that I would say copy the recordsID, for example from 152 to 300 and paste it back at the bottom, then I could request it with a query and adjust the necessary data on these requested records. Is this possible or is there another much better way to achieve this.

	Richard Rost @Reply 2 years ago
Yeah, certainly possible. You can do it with a query or a recordset loop, or you might just find it easier to copy all the items and delete the ones you don't need if it's only a few. Lots of different ways you can do this.

	Ludwig Willems OP @Reply 2 years ago
ok, are there any videos or examples of this?

	Sami Shamma @Reply 2 years ago
Start at developer 18

	Richard Rost @Reply 2 years ago
It's really just applying the recordset lessons that you've learned.

	Ludwig Willems OP @Reply 2 years ago
ok, first learn to crawl, then walk and then run :)... advantages and disadvantages of when you have to make something at work and you don't have the knowledge about it yet. They will have to be patient. Everything will be fine, but it will take a while, practice makes perfect, with some help from the forum every now and then :)

Richard Rost @Reply

2 years ago

To copy one order, you take a record set for the order and then use a record set loop to loop through the items. The whole process will allow you to do a bunch of orders. You would just need to make two records that loop; one to go through the orders, and the second one to loop through the details on each order as you go through it. I'm sure with a little practice, you'll get it. If you can't, let me know.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer 24 Lessons.

Next Unseen

New Feature: Comment Live View