Microsoft Access Macro - is there a way to copy records with a macro?

Question

I have written a macro in Microst Access that runs a make-table query, opens the table and selects all the records. (I don't know VBA so I have to use macros).

Then I copy all the records and paste them into Word and run a macro I've created there.

Is there a way to add a command of some sort to copy selected records?

If so, here would be the end result that I'm trying to accomplish.

By adding this to a menu item, the End User would simply click the Run Whatever Report button and it would go through all these steps:

1. Run a make-table query.
2. Open the resulting table.
3. Select all records and fields.
4. Copy all selection.
5. Open Word.
6. End User clicks previously created macro button.
7. Task completed.

My End Users are at the very basic level and are menu-button driven. If they have to manually select the records, I will (seriously) have to write a manual on "How To". Therefore the reason for my desired end result.

Thanks for any help or suggestions!

Answer 1

Why not just create a report using the Access Report Designer? It's not that hard and doesn't require knowing VBA. There are report wizards for basic designs. You already have your "make table" query that creates the data to be reported. Just choose it in the report wizard and in a few simple steps you will have a basic report. Once the report is designed and saved you can create a simple one-step macro to open that report and put that macro on a menu button.

You can then use the Office Links button on the toolbar to export the report to Word, if that's still necessary.

If you want to learn more about creating reports starting with using the wizard, here's a very clear video tutorial on YouTube: http://bit.ly/xQBzjp

Answer 2

http://www.vbforums.com/showthread.php?t=376693 (interesting info that may be close to what you are looking for).

If you must use a macro, this site looked promising.