too many fields defined

[lauras]

I made some changes to my query and I'm now receiveing the error above.
Action Failed:
Macro name:
mcrExportDailyReview
Condtion:
True
Action Name
Transfer Spreadsheet

What did I change that caused the problem?

 

[vbaInet]

What changes did you make? Show the old macro and the new indicating the changes.

 

[lauras]

I made no changes to the macro at all. Just to the query - and all I did to the query was change the information I want pulled.

 

[vbaInet]

How many fields are you pulling?

 

[lauras]

i am able to run the query fine from design view -
6 from 1 table

 

[vbaInet]

I see. Try creating a new query and pull those fields into it.

 

[boblarson]

If you are pulling only 6 fields and the query is fine in design view when you view the results, then perhaps it is the TransferSpreadsheet file path that is the problem. What did you put in for the TransferSpreadsheet Arguments?