Email Filtered Form Object

[horatiu00]

Any idea why when i'm trying to email a filtered subform the excel file is empty? I need a solution for the user to be able to export a report after he is applying some filters on the data....Thank you in advance!

 

[Micron]

Don't know why but apparently it's only achievable with code. I would have thought it possible and easier to reproduce the filtered subform as a query and send that instead, but from what I've seen, many of the code approaches seem quite complicated. This seems to have somewhat simpler approaches than others I looked at. What's interesting though is that others complain that the entire subform recordset is what goes into the spreadsheet (which makes sense to me), not no records at all.

Export Filtered Form Data to Excel

Hello, I am trying to export data from a filtered Access form to Excel by clicking on a command button. I found a function written by Bob Larson to export data from a filtered Access form to Excel, but I am getting an error 438, "Object doesn't support this property or method." My form's name...

www.access-programmers.co.uk