How to resovle this Error 'this object does'nt support this property or method'

[syedshaffee]

hey,
i am always getting this error 'this object does'nt support this property or method' while running this code

DoCmd.OutputTo acOutputQuery, "QryexportSecondarycashTracker", acFormatXLS, "C:\RIMSINLIVE" & "\temp.xls", True

Please Help

[zmbd]

Check that all of the fields in the query are supported by excel for both datatype and size. Memo fields can be a pain; however, attchement fields will cause this to fail too.

[syedshaffee]

But the Record gets Exported to excel anyway i don't want that error to pop up

[twinnyfo]

You could add error handling, and if the error matches this error number, just resume the code.... If your data exports OK, it should not be an issue, although, you should still try to find out what is causing the error, first.....

[TheSmileyCoder]

I do not know exactly what is causing your error, but it is always good practice to first try to solve error messages instead of just ignoring them.

I suggest you do as zmbd has allready suggested, check that all field types being exported are allowed.

Is the code overwriting or appending to the excel file if it already exists?

In the future when you post a question please remember to include all relevant information in the first post. I would consider such information as you posted in post 3 quite relevant to have included in the first post.

Not only will you get faster and more accurate replies, you will also get happier experts :) .