Opening a spreadsheet with filtered data.

  • Thread starter Thread starter mdub
  • Start date Start date
M

mdub

Hi,

I am trying to use "DoCmd.TransferSpreadsheet...." to transfer data to a
spreadsheet that displays only the filtered data on a form. Right now, it's
giving me all of the data in the table. Thanks,

Michael
 
Hi,
you need to read current form's filter using .Filter property, build a new
query using form's recorsource query and current filter and then use this
new query for DoCmd.TransferSpreadsheet

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Set Read Only property in Excel from Access VBA 2
Excel Multiple Worksheets - TransferSpreadsheet VBA 0
Transfer Spreadsheet... setting parameters, etc. 5
How to export data from a query to a .xlsx file. 3
where to export to? 2
Adding filter to query 1
How to transfer the data from userform to spreadsheet for specific dates 0

Back
Top