Share via

export a query to excel by using command button

Anonymous
2013-06-11T15:53:33+00:00

i have just designed a database in access 2010. i have a sub-form in a main form, this sub-form display a certain query based on the searching options in the main form. i also know how to export this query result by using access 2010 (in EXTERNAL DATA -> click to "Export to Excel file").

My question is, how can i export the query displaying in the sub-form, by using a command button right in the main form. please help.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-06-11T18:03:54+00:00

    If the query is a saved query, you can use the TransferSpreadsheet method/action.

    Was this answer helpful?

    0 comments