VB Forum / General 2 / June 2006

Typically, I would think the errors are arising from some DLL that's
referenced in your app.  It probably can't debug them because the errors are
happening in the code of the DLL instead of in your code itself.  I could be
wrong on that, but that's where I'd tend to look first.

Run-time Error '5' happens a lot when there are multiple objects or
functions with the same name in your code, or if a DLL is missing, so look
at those possibilities...try fully qualifying your function calls and see if
that resolves anything (i.e., not just "Recordset", but "DAO.Recordset" or
"ADO.Recordset", or instead of "Left$()", use "VBA.Left$()", etc.

Chances are that Word or Excel have nothing to do with it, but certainly
they could if you're referencing those DLLs in your app.

If you can't figure it out, your best bet is probably to step through your
code and figure out specifically where it's happening (and if it's
reproducible if you run the program again without changing anything else).
Worst case scenario, put a bunch of Debug.Print statements into your code
(or send debugging info to a file...whatever), and use that to figure out
where exactly it's happening.

Rob

You're trying to access a remote component during a paint (or similar)
event. Don't. This is forbidden.

BTW, I had no trouble using search.microsoft.com to locate KB131056
(http://support.microsoft.com/kb/131056/en-us) and KB198996
(http://support.microsoft.com/kb/198996).