Results 1 to 5 of 5
  1. #1
    CementCarver's Avatar
    CementCarver is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2013
    Location
    Canada
    Posts
    231

    Operation is not supported for this type of object error

    How does one trap the location where this error is happening...." Operation is not supported for this type of object error? All I get is the message and not the line or subroutine where the error is occurring.



    What causes this error to happen?

    CementCarver

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    If you have error handling, temporarily comment out the "On Error" line and then test.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    CementCarver's Avatar
    CementCarver is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2013
    Location
    Canada
    Posts
    231
    Thanks pbaldy...... after commenting out the "on error" is flagged the lines that were causing the problem.

    CC

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    No problemo. Don't forget to uncomment that line. Some of us use a global variable to turn error handling on/off during testing.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    CementCarver's Avatar
    CementCarver is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2013
    Location
    Canada
    Posts
    231
    Now at least I know that I can comment out error handling to trap errors.....CC

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Operation must use an updatable query-- error
    By bhushan98 in forum Queries
    Replies: 2
    Last Post: 12-01-2012, 11:32 AM
  2. variable uses automation type not supported
    By eerkut in forum Programming
    Replies: 4
    Last Post: 02-15-2012, 03:21 PM
  3. the operation on the ole object failed
    By merlin777 in forum Access
    Replies: 5
    Last Post: 09-05-2011, 05:43 PM
  4. Object not supported "ERROR"
    By Casper2012 in forum Forms
    Replies: 1
    Last Post: 08-24-2011, 06:31 PM
  5. Replies: 2
    Last Post: 03-23-2009, 05:39 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums