I am using a unbound form for the user to enter date ranges. These fields are tied to underlying query.
I want to export the query from access 2007 to excel 2007 when I click the command button in the form.
I have tried several attempts but not getting success.
The name of the query is "qryExcelDeliveryExport"
I thought it would just be an OnClick event that included the docmd.trtansferspreadshee acExport code.
Thanks in advance for looking at this.