export to excel

[hireagenius via AccessMonster.com]

Hello,
I have been reading through the site posts for advice given for exporting
from access to excel, and have followed some of the recommended links. From
what I read, it looks like using the TransferSpeadsheet Action may be the
best option. Although I have read about filters and WHERE clauses in SQL what
isn't really clear to me is how I allow the user to limit the data.

Here is the scenario. I have three tables from which to export data. The
tblProjects has a one to many relationship with tblMilestone, and tblBudget.
I want the Project Manager to be able to click a button on the form from
which they are viewing one project and the related many milestones and
budgets. This data will go to an excel sheet with Project data on tab1 of
excel, milestones on tab2, and cost on tab3.

How do I filter the data to one project for export?

Thank you
Carla

 

[pietlinden]

Hello,
I have been reading through the site posts for advice given for exporting
from access to excel, and have followed some of the recommended links.  From
what I read, it looks like  using the TransferSpeadsheet Action may be the
best option. Although I have read about filters and WHERE clauses in SQL what
isn't really clear to me is how I allow the user to limit the data.

Here is the scenario.  I have three tables from which to export data.  The
tblProjects has a one to many relationship with tblMilestone, and tblBudget.
I want the Project Manager to be able to click a button on the form from
which they are viewing one project and the related many milestones and
budgets. This data will go to an excel sheet with Project data on tab1 of
excel, milestones on tab2, and cost on tab3.  

How do I filter the data to one project for export?

Thank you
Carla

If they're exporting only a single Project at at time, then you can
filter by the primary key of the parent table, tblProjects, and then
all 3 will be tables' data will properly filtered.