V Vitality Registered User. Local time Today, 14:04 Joined Sep 16, 2004 Messages 15 Sep 16, 2004 #1 I have continous Form. How can I export only filtered data from continous form to Excel file?
Ron_dK Cool bop aficionado Local time Today, 23:04 Joined Sep 5, 2002 Messages 2,129 Sep 16, 2004 #2 Apply the filter in the Database. Once the filtered data is there, select all records on your form, select File > Export and the .Xls file and the filtered data will be transfered to your excel file.
Apply the filter in the Database. Once the filtered data is there, select all records on your form, select File > Export and the .Xls file and the filtered data will be transfered to your excel file.
V Vitality Registered User. Local time Today, 14:04 Joined Sep 16, 2004 Messages 15 Sep 16, 2004 #3 Thanx, it works. But it not work, when continous Form is as Subform. What can I do in this Situation?
Thanx, it works. But it not work, when continous Form is as Subform. What can I do in this Situation?
Ron_dK Cool bop aficionado Local time Today, 23:04 Joined Sep 5, 2002 Messages 2,129 Sep 16, 2004 #4 Assuming that the data from the subform is based on a query : filter the data in that query and export the records from the query. This can also be automated.
Assuming that the data from the subform is based on a query : filter the data in that query and export the records from the query. This can also be automated.
