Treeview object declaration for intellisense

[Dale_Fye via AccessMonster.com]

I'm currently running A2007, and need to figure out the proper declaration
statements which will enable intellisense while working in VBA. I think
there may also be a reference that I need to add, but cannot remember what it
is.

The code I have all has declarations of the various treeview objects as
Object, but that doesn't provide me with the intellisense functionality.

When I was doing this in 2003, I thought I had to use something like:

dim tvw as mscomctrl.treeview

or something like that, but don't currently have any access to any of the old
2003 mdb files.

Anybody have any ideas?

 

[Stuart McCall]

I'm currently running A2007, and need to figure out the proper declaration
statements which will enable intellisense while working in VBA. I think
there may also be a reference that I need to add, but cannot remember what
it
is.

The code I have all has declarations of the various treeview objects as
Object, but that doesn't provide me with the intellisense functionality.

When I was doing this in 2003, I thought I had to use something like:

dim tvw as mscomctrl.treeview

or something like that, but don't currently have any access to any of the
old
2003 mdb files.

Anybody have any ideas?

I've never used the treeview in Access, but in VB6 when you add the tv
activex object to a form, it sets a reference to MSComctlLib. The actual
library file is mscomctl.oca (usually in the system32 folder). If this isn't
happening in Access, you could try setting a reference manually, using the
browse button...

 

[Dale_Fye via AccessMonster.com]

Stuart,

Thanks buddy, exactly what I was looking for.

Unfortunately, I was looking for: Microsoft Windows Common Controls
in the "Available Resourses" list, and it was not there. I forgot all about
the Browse button.

Dale

I'm currently running A2007, and need to figure out the proper declaration
statements which will enable intellisense while working in VBA. I think

[quoted text clipped - 14 lines]

Anybody have any ideas?

I've never used the treeview in Access, but in VB6 when you add the tv
activex object to a form, it sets a reference to MSComctlLib. The actual
library file is mscomctl.oca (usually in the system32 folder). If this isn't
happening in Access, you could try setting a reference manually, using the
browse button...

 

[Stuart McCall]

Stuart,

Thanks buddy, exactly what I was looking for.

Unfortunately, I was looking for: Microsoft Windows Common Controls
in the "Available Resourses" list, and it was not there. I forgot all
about
the Browse button.

Dale

<snip>

No problem. Glad I could help someone who helps others.