+ Reply to Thread
Results 1 to 4 of 4

Run-time error'3001': Application-defined or object-defined error

  1. #1
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    Run-time error'3001': Application-defined or object-defined error

    i am getting this error while running the getting data from the mysql

    i am trying to getdata from the mysql according to Date in the mysql table

    i have two tables(logindetails and logout details)

    i am trying to getdata from one table at a time using Inputbox

    Please help me to solve

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Contributor pareshj's Avatar
    Join Date
    05-20-2014
    Location
    MUMBAI
    MS-Off Ver
    2007 & 2010
    Posts
    447

    Re: Run-time error'3001': Application-defined or object-defined error

    Hi,

    Please clarify some points in your code.
    1) You have commented out SQL query string, and that query string is used in recordset open. Please check.
    2) Before copying data from recordset to excel sheet, you have not checked whether BOF or EOF or recordset has data or not.
    3) Your query string should been like below. Please check:

    Please Login or Register  to view this content.


    Regards,
    Paresh J
    Click on "* Add Reputation" as a way to say thanks

  3. #3
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    Re: Run-time error'3001': Application-defined or object-defined error

    thanks but now getting an error called automation error

  4. #4
    Forum Contributor pareshj's Avatar
    Join Date
    05-20-2014
    Location
    MUMBAI
    MS-Off Ver
    2007 & 2010
    Posts
    447

    Re: Run-time error'3001': Application-defined or object-defined error

    Hi,

    Can you tell me on what line you are getting this error. Try debugging it and check on which line it is giving the same error?


    Regards,
    Paresh J

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. excel macro run time error '1004'- Application defined or object defined error
    By kmadan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-16-2014, 09:51 AM
  2. Replies: 1
    Last Post: 03-12-2014, 12:42 PM
  3. [SOLVED] Run time error 1004 Application-Defined or Object-Defined Error - Placing data into next e
    By michelle 1 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-27-2014, 12:57 PM
  4. [SOLVED] Error " Run-time error '1004': application defined or object defined error
    By lengwer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2013, 07:26 AM
  5. [SOLVED] run-time error '1004' application-defined or object-defined error - Excel 2007
    By kaurka in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-06-2012, 02:46 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1