Hi
I have a sub form currently that is in datasheet view and I want to setup a command button that when clicked will copy all the records from the sub form into the clipboard.
I am essentially wanting to replicate going into the subform and pressing Ctrl + A (to select all records) and then Ctrl + C to copy them.
I have tried sendkeys with no luck..
Any suggestions???
Mark
I have a sub form currently that is in datasheet view and I want to setup a command button that when clicked will copy all the records from the sub form into the clipboard.
I am essentially wanting to replicate going into the subform and pressing Ctrl + A (to select all records) and then Ctrl + C to copy them.
I have tried sendkeys with no luck..
Any suggestions???
Mark