Access Query into Excel using Access Form Problem 1

[supanoods]

Hi,

I am attempting to export an Access Query into Excel. the query parameters are defined by a form that has a combo box on for a choice of "Machine". The choice of Machine defines the query.

My form is called "ExcelReportsForm", and my query is called "MachineByPart", the Machine combo is called "MachineCombo". In the Machine parameter in the query, i have [Forms]![ExcelReportsForm]![MachineCombo], and the query runs fine within Access.

I then try to "Get External Data..." within Excel, but I get a parameter error!!! If I change the parameter to a set machine - the process runs fine!!!

Any ideas or any thoughts on a better way to get the query results into Excel!!!

"If it aint broke - dont fix it!

 

[BoxHead]

Take a look at the TransferSpreadsheet method in Help. You can manage the export from the Access form rather than importing it in Excel.

HTH

John

Use what you have,
Learn what you can,
Create what you need.

 

[supanoods]

BoxHead - Thanks for the pointer!

It seems a hell of a lot easier using this method!!!!

Thanks again!



"If it aint broke - dont fix it!

 

[BoxHead]

Supanoods, glad to help.

John

Use what you have,
Learn what you can,
Create what you need.