Adding filter to query

[Ken Warthen]

I'm trying to export to excel the filtered results of an underlying query on
a split form. In the on click event of a command button I create a querydef
and then use transfer spreadsheet to create an Excel workbook. The code
creates the spreadsheet, but it includes all the records. I need to make it
create only the filtered records. I've tried several methods, but can't seem
to figure this out. Any help will be greatly appreciated.

TIA,

Ken

 

[ryguy7272]

I just answered a question just like this yesterday. I got a green check for
it! Maybe I will get another today...


Here's one way:
http://www.datapigtechnologies.com/AccessMain.htm

Go to the bottom of the page and download this file: 'DataPig Access
Explosion'

Here's a video on how it works:
http://www.datapigtechnologies.com/flashfiles/accessexplosion.html


Another GREAT resource:
http://www.accessmvp.com/KDSnell/EXCEL_Export.htm