+ Reply to Thread
Results 1 to 2 of 2

Object Variable or With Block Variable Not Set- Error on Another User Machine

  1. #1
    Registered User
    Join Date
    10-26-2006
    Location
    Cincinnati, OH
    Posts
    4

    Object Variable or With Block Variable Not Set- Error on Another User Machine

    I have code that is running a query from an access db & returning the output into excel based upon user form inputs (on the excel template). The application is working fine for myself & one other user, however when I tried to run it on a third machine, I am getting a fatal error (RT Error 91- Object Variable or With Block Variable Not Set). I suspect that perhaps the user is not getting any data returned, but I can't figure out where the problem is occuring. Could someone please give me an idea on where my problem resides....I would GREATLY appreciate it!! I've excluded the section of code where the query output is formatted in excel, as I'm fairly confident the error isn't in this section (it isn't returning data, so I'm not getting that far in the query). The first section of the code is just evaluating the user form to determine which query to run & what parameters to use.


    Please Login or Register  to view this content.
    'set error location

    'define dbase
    Please Login or Register  to view this content.
    also posted question on:
    www.mrexcel.com
    www.utteraccess.com
    Last edited by dailem; 10-01-2010 at 09:23 AM.

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Object Variable or With Block Variable Not Set- Error on Another User Machine

    I suggest you comment out the error handler and then run it for that user to find out the actual error line.

    Thanks for correcting the post by the way.
    Remember what the dormouse said
    Feed your head

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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