What does error: User-defined type not defined mean?

[wedd]

What does The expression On open you entered as an event property setting produced the following error: User-defined type not defined mean? And how can this be resolved? I am a novice/intermediate user of vba in access.



Thanks for your contributions!!!:friends:

[orange]

see http://support.microsoft.com/kb/289664

[wedd]

Hi Orange, I've read through the troubleshooting on Microsoft website. But what does this statement below mean: and what steps would I need to do or which type of library in the reference section should I check to help resolve this issue? I'm an intermediate user of vba...so I'm still learning this functionality.


"Click to select the object library that contains the object that is referenced by the line of code that is highlighted."Thanks!

[Aflatoon]

The code you are using in the OnOpen event refers to objects in libraries other than Access, to which you have not set a reference. ADO perhaps? If you try to compile the code it may highlight the specific offending line.

[wedd]

Ok, thanks!

[wedd]

Aflatoon, which checkbox option would I select in the references object library if the object is refering to as a ADO?


Thanks

[Aflatoon]

What is the actual line that is causing the problem? There is no point in me telling you how to select an ADO reference if it is not the correct one.

[wedd]

Hi Aflatoon, the offending line is written below:

' The date passed in from the caller (possibly null)
Dim dtStartDate As udDateType

[Aflatoon]

It would seem that you forgot to copy a user defined type declaration from wherever you got your code.

[orange]

I agree with Aflatoon, it doesn't seem that you have a missing reference.
It seems that a user defined type (defintion) has not been copied into your code.

This may give some idea/more info about udt(user defined types).
http://www.techrepublic.com/article/vb6-tip-making-the-most-of-user-defined-types-udt/5493772

[orange]

Double post in error.