Type Mismatch Error

[Guest]

Hi, suddenly I am getting a Run Time error 13 - Type Mismatch error on the
following line of code in a Function:

Set doc = dbs.Containers("Databases")!UserDefined

This cropped up suddenly today and had not given me any prior problems. As
a matter of fact, I use the same code in several databases and it works fine
in the others.

I have done a compact and repair and even deleted and re-entered the function.

Does anyone have a clue on why this could be happening?

Thanks for any help.

 

[Guest]

Hi.

Your database may have lost one of its library references. Make sure that
your database has a reference set to the Microsoft DAO 3.6 Library, and you
have no "MISSING" references. For more information, please see Tom
Wickerath's Gem Tip, "ADO and DAO Library References in Access Databases" on
the following Web page:

http://www.Access.QBuilt.com/html/gem_tips1.html

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts, so that all
may benefit by filtering on "Answered questions" and quickly finding the
right answers to similar questions. Remember that the best answers are often
given to those who have a history of rewarding the contributors who have
taken the time to answer questions correctly.