Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Compile error

Compile error

Compile error

I have the following code:

'* Declaration Specifications *
Dim nodcat As Node
'Node for Category
Dim nodCatCode As Node 'Node for Category Code

Dim nodCatValue As Node '######## Node for interval value '########

Dim i As Integer 'Working variable

Dim strKey As String 'Unique ID (key) for the node
Dim strPMInterval As String 'Title (name shown on tree)
Dim intPMIntervalValue As Integer '######## Value of interval ########

Dim rstPMS As New ADODB.Recordset
Dim rstINTERVALS As New ADODB.Recordset
Dim rstIntervalValues As New ADODB.Recordset '####### Create new recordset ######

The Dim nodcat as node line causes an error "compile error user defined type not defined. Other apps I have use the same code but work fine. Any thoughts?

Thanx in advance

RE: Compile error

It is exactly what the error is stating. You do not have a reference to a tree view so it throws a user defined error.

RE: Compile error

So the code is calling for a tree view but can't find it? I just want to understand

Thank you

RE: Compile error

There are external code libraries that access reads by setting references.

In a module window / VBE (visual basic editor), select the tools menu and select references. You will see a list of references Access knows about. Occasionally you might have to browse for a library that it does not see. You need to find the reference appropriate for the object giving the error and check it.

I personally do not know which library that would be.

RE: Compile error


RE: Compile error

Gotcha, thank you

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close