Trouble Exporting Sorted Data from Access Form with Subforms to Excel (1 Viewer)

AHMEDRASHED

Member
Local time
Today, 20:15
Joined
Feb 2, 2020
Messages
50
Hello everyone,

I'm encountering an issue when exporting data from a Microsoft Access form, which includes subforms, to an Excel file. Specifically, when I attempt to sort the data in the Access form (either ascending or descending) before exporting, the exported Excel file ends up containing zero results.

Has anyone encountered a similar issue before or have any insights into what might be causing this problem? Any suggestions or troubleshooting steps would be greatly appreciated.


Note: If I remove the sorting, the export works fine. However, I need to use sorting in ascending order for all my forms.

Thank you in advance for your help!"

1712052344088.png


sorting :
1712052422867.png



1712052582873.png



-----
1712052673444.png

1712052866559.png
 

Attachments

  • 1712052659068.png
    1712052659068.png
    17.3 KB · Views: 22

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 01:15
Joined
May 7, 2009
Messages
19,246
insights into what might be causing this problem?
there is nothing causing the problem.
only your query is "fixed" (and the sorting is done only on the form).
so you need to create new Query and add the current sort order of the form.
then use the query for import.
 

ebs17

Well-known member
Local time
Today, 19:15
Joined
Feb 7, 2020
Messages
1,991
Export from a form to Excel: With the CopyFromRecordset method you can copy a form recordset as it currently appears into an Excel worksheet, with all filters and sorting.
 

Users who are viewing this thread

Top Bottom