I don't have 2007; I have 2003, but I guess it should be similar
open the table you want to copy from and the table you want to copy to
going down the left side of both tables is a light blue or light gray column
in access 2003 there is a little pencil in this column when you edit a row
so on the table you want to copy from, right mouse click in that blue/gray column on the row that you want to copy
a little pop up menu pops up
on the pop up menu it says New, Delete, Cut, Copy, Paste
select Copy
then go to the table you want to copy to
right mouse click on blue/gray on the last row of that table, its the row where you normally type in your new record, the one with the * next to it
so you right mouse click on the * and the pop up menu pops up, then you select Paste
and that should do it
assuming the columns in both tables are the same type and in the same order
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.