Search results

@MajP When loading the treeview it completes but breaks at the last record Private Function FindRoot(ByVal nodX As Node, tvw As TreeView) As Node On Error GoTo ErrHandler Dim n As Integer n = nodX.Index Debug.Print nodX.Index While n <> nodX.Root.Index n =...

Thanks.

Whew! Now to make it work for me. Thank you so much!

Just... Wow! On E2E and Genie.. I am completely confused about LabelEdit. What calls it? It's shown as a property of the form in the object browser but I don't get it.

I missed that in E2E. I'll study it. Knowing I'm not off the wall is a big deal.

@MajP Some years ago I used your treeview to organize some file cabinets. I had a table of DRawers, a table of DIvisions, a table of FOlders, and a table of ITems. Then I used a union query for the treeview. Each item had an address of...

open Access in administrative mode then go to open, search for the file and click read-only at the bottom before selecting it. Instructions are on the V-Tools site. The problem I had before was the deep search said that function was not available and then crashed so I had to use task manager to...

I had V-Tools installed and I was getting an error so I uninstalled it. Now I'd like it back again but every time it fails because of the following Error 5: lrc = api_RegQueryValueExNULL(lhKey, szValueName, 0&, lType, 0&, cch) If lrc <> ERROR_NONE Then Error 5 Irc returns the value of 2...

I very much apologize. Someone needs to tell me to never work on this stuff late at night because I don't think well then. For some reason I thought level should be a property of the node but after going through your help it turned out to be very simple Public Sub FormatNodes() Dim nd...

I'll sleep on it. Thank you so much for your help!

Here are my loctions... all headers. But headers on level 2 and level 3 should be different than level 1. Here are my levels. Now what? Public Sub FormatTree() With tvw.TreeView .Font.Size = Me.FontSize .Font.Name = Me.FontName .Indentation = 150 End With End...

Can you concatenate LocationID-ItemID as the identifier? That would be unique, no? I'm not really looking for unique... I'm looking for the various levels. And when the level changes, as in moves or gets descendants or whatever, the formatting should go with the level, not the item.

I love your pictures. I get it. But notice your're using "nt" for nodetype.. case C, BI, SB. GetNodeLevel returns a key. I thought I understood the levels but you don't use them the way it seems like you should. Even the tag uses the node PK. I'm not being intentionally oblique... just missing...

Well, I'm definitely incorporating that into my program! :love:But, same problem. My identifiers are Location and Item. How do I tell my treeview that I want to format by level? All of your identifiers are different but mine aren't. Location has at least 3 levels. The levels change when moving...

@MajP So I'm combining your ItemGenie with my own thing and getting all fancy and such... and I added fields to the application settings and created more formatting: (the orange fields will be hidden) . But when I got to the format treeview I realized there is no tvw property for nodelevel...

Nevermind. I found another piece that works I can send my record source from the form and place the code after the open event. Thank you for your help.

I need this to skip used labels. Maybe I should go back to creating a table before printing. This seemed so much more smoother...

Yes, I know. But you can't change the record source. Which it has no record source because I want to establish it in the opening of the report.

Then I receive a "the property is read only and cannot be set" at Me.Recordsource =...

@Pat Hartman I'm trying to use Pat's label printing code. When I open the report from a form I use DoCmd.OpenReport strReport, acViewNormal, _ OpenArgs:=Me.Name & "|" & Skip The report immediately starts printing and does not hit the Open code in the report. Private...