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

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.