473,395 Members | 1,539 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

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
Expand|Select|Wrap|Line Numbers
  1. DoCmd.OutputTo acOutputQuery, "QryexportSecondarycashTracker", acFormatXLS, "C:\RIMSINLIVE" & "\temp.xls", True
  2.  
Please Help
Oct 4 '12 #1
4 1414
zmbd
5,501 Expert Mod 4TB
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.
Oct 4 '12 #2
But the Record gets Exported to excel anyway i don't want that error to pop up
Oct 5 '12 #3
twinnyfo
3,653 Expert Mod 2GB
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.....
Oct 5 '12 #4
TheSmileyCoder
2,322 Expert Mod 2GB
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 :) .
Oct 5 '12 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

7
by: Roberta McGervey | last post by:
I have the following code: <Script LANGUAGE=vbscript RUNAT=Server> for i =0 to document.form1.elements.count-1 response.write "test" next
10
by: Rohan Hattangdi | last post by:
I get the following error message on a line that attempts to create an instance of an ADODB connection object. "Object does not support this property or method: 'Server.CreateObject' ". Now...
7
by: stellstarin | last post by:
hi all, I have a HTML page with two forms. While trying to add a hidden element in a first form by the default javascript function, the error message 'object does not support this property or...
1
by: kamleshsharmadts | last post by:
I am using Ajax with struts in web application. from jsp i am calling a function of ajax.js onclick of a button. code of that call function which calling from jsp given as below:- ...
5
by: John Olbert | last post by:
Subject: Error is Object doesn't support this property or method I am trying to pass a C# string under Vs2005 (Net2) to an Vb6 ActiveX Control. I get the following runtime error-- "Object...
7
dmjpro
by: dmjpro | last post by:
guyess .... here is my code .... document.body.offsetWidth = document.getElementById('photo_upload_table').offsetWidth + 10; document.body.offsetHeight = ...
2
by: Charles | last post by:
I have a validation script used before submitting a form. When executed it says "Object doesn't support property or method". I'm using onclick="return validate();" which should be fine. But when...
5
by: monu121 | last post by:
hi, i am getting one error "Object Does Not Support This Property or Method..." when i am using my dll file actuly i am calling my dll file in product. i am using vb 6.0. if any one is...
0
acoder
by: acoder | last post by:
Problem When setting the FORM object's action property an "Object does not support this property or method" error occurs Browser Internet Explorer 6- Example The Javascript code: var...
1
by: chetan7991 | last post by:
I'm using a jquery plugin Galleriffic in my page and it shows perfectly in all browsers except IE. The error says: "Object doesn't support this property or method" The code I use for script...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.