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:
- Run a make-table query.
- Open the resulting table.
- Select all records and fields.
- Copy all selection.
- Open Word.
- End User clicks previously created macro button.
- 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!