Select All records in datasheet view for copy

[Rx_]

[Solved] Select All records in datasheet view for copy

Trying to Copy All records in a Datasheet view into a variable.
Will use variable to paste into a new blank Excel worksheet (using vba).


A form (MyForm) with a SubForm (sfRowList) Default View as Datasheet. MyForm has a search to filter that works. And, the users like the feature to resort any column.

Once the users filter and sort the data, they can click in the upper left-hand corner of the header/row of the dataview and basically "Select All". Then they can paste the selected headers and records into Excel.


What is the VBA for the "Select All" and copy of the subform's data from the parent form (see button Copy to Excel in attachment)?

 

[Rx_]

Wow, I had realized the recordset was the key and started doing this from scratch.
Thanks to your speedy response, the code you point to is just perfect for me to start with and modify for my own reporting format.

Thanks to you, I can finish early this Friday and enjoy our 3 day Labor Day weekend!
Your web page is in my Favorites! Thanks Heaps!

 

[Snowflake68]

Why not just use my code that I have available. Copy it into a standard module and then just call the procedure passing the form. It will send the filtered form to Excel.

Do you still have the code for this as the link no longer works.

Thanks

 

[Rx_]

http://btabdevelopment.com/
Access Experts was nice enough to take the old Bob Larson BTABDevelopment site and preserve the code.
I won't have time to find the code you requested. If you do find it, please post it for others who follow.

 

[arnelgp]

another alternative to copy all records displayed in subform:

DoCmd.GoToControl "sfRowList"
DoCmd.RunCommand acCmdSelectAllRecords
DoCmd.RunCommand acCmdCopy