How do I copy and paste multiple records?

English
#1

On a sub-form, I’d like to copy a selection of rows, cut them, select a different “bed” from the parent form and then paste them.
How can I do this?
In the example screenshots:
(1) I’m copying from plants in Bed named “”
(2&3) wanting to paste them into Bed named “Sooke Rd. 6411”. Which you can not see because the menu to paste is covering it.
(4) This shows table relations and the form navigator window in case that helps

Here is a dropbox link to the database:
https://www.dropbox.com/scl/fo/h9kn7rdru9s7e20h1s1f8/AFQNeUMCKouLx093XxMdxfI?rlkey=ag9uftpze2mjf55ag3btfza36&st=gbkwxszh&dl=0

#2

If you use a table control (without any macros) and a autoincremented primary key:

  • Mark the rows you want to copy (Mark first row, shift and last row)
  • Press mouse button and draw to new row.

All rows will be inserted.

#3

I can not drag them because I can only see plants from one bed at a time.
Here a a video to better illustrate my issue.
https://youtu.be/PI36nyhLPu8

#4

Seems like a sql APPEND query to me, nothing to do with a form.

#5

is there a gui to do what you are suggesting?

#6

No, you have to create all this by macros.

#7

goedible,

If you follow RobertG’s “drag and drop” no macro suggestion:

  • after “duplicating” the desired “plant” rows into the “plant” table control, simply change the foreign key of the newly inserted plants to the corresponding primary key of the “beds” parent recordset. Make sure the “plant” foreign key column is visible in the “plant” table control. On the first occasion of changing rows in the parent “bed” control (reload), the “plant” subform will refresh and the duplicated “plants” should reload into the “plant” subform under the proper “bed” form record.
#8

If your records are displayed in a table grid, Ctrl+Click the record markers (left of first column) in order to select arbitrary records, then right-click>Copy.
If your form shows one record in separated form controls, click the last button on the navigation toolbar. This opens an additional table grid representing your form.
When you copy to Calc, you get the selected records with column labels.
When you copy to Writer, you get a dialog with options. For instance, you can dump the copied data into a new text table.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.