D
Desmond
I need to export data to a spreadsheet but I need to apply filters to the
export which the user applies based on a number of custom filters ranging
from one to six (different filters)
Specifically, the query that displays data on the form lists upto 20 fields
from the underlying table and I may only want a few of those fields exported
with data further narrowed down based on the filters the user has chosen.
For example, 1000 Employee records comprising Name, address, telephone,
Branch Location and Salary. I may only require the Name Address & Telephone
but filter the export to include specific Employees at a specific Branch
Location.
I am presently using the following to export data based on the forms display
after a variety of user selected filters have been applied but,
unfortunately, this exports all the controls on the form too.
- DoCmd.OutputTo acOutputForm, "Employees", acFormatXLS, , True
I'm sure there must be a better way - can anyone help me?
export which the user applies based on a number of custom filters ranging
from one to six (different filters)
Specifically, the query that displays data on the form lists upto 20 fields
from the underlying table and I may only want a few of those fields exported
with data further narrowed down based on the filters the user has chosen.
For example, 1000 Employee records comprising Name, address, telephone,
Branch Location and Salary. I may only require the Name Address & Telephone
but filter the export to include specific Employees at a specific Branch
Location.
I am presently using the following to export data based on the forms display
after a variety of user selected filters have been applied but,
unfortunately, this exports all the controls on the form too.
- DoCmd.OutputTo acOutputForm, "Employees", acFormatXLS, , True
I'm sure there must be a better way - can anyone help me?