Compile error

[hoofit]

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

 

[MajP]

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.

 

[hoofit]

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

Thank you

 

[lameid]

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.

 

[MajP]

Mscomctl.ocx

 

[hoofit]

Gotcha, thank you