MajP's latest activity
-
MajP replied to the thread Solved Treeview nodes error.Trouble shoot that with a debug.print I only ever use numeric PKs. If you build your node query correctly, you concatenate the... -
MajP replied to the thread Question on Comboboxes.There are probably a few ways to do this. You could union the values and in one combobox see both people names and company names if...
-
MajP replied to the thread Question on Comboboxes.Are the chosen values saved in the same field in the table? What is the control source of your current combobox and if you showed the...
-
MajP replied to the thread Solved Treeview nodes error.My getNodeLevel function was dumb too. Should be Public Function GetNodeLevel(myNode As Node) As Integer 'saving the PK as the key...
-
MajP replied to the thread Solved Treeview nodes error.The original code is so bad and only works in spite of itself. Probably doing some drinking when I wrote that. The root is the very...
-
MajP replied to the thread Solved Treeview nodes error.This seems to be more correct. Public Function FindRoot(ByVal nodX As Node, TVW As TreeView) As Node On Error GoTo ErrHandler...
-
MajP replied to the thread Solved Treeview nodes error.It is exactly as I expected. The root property is worthless. It returns node 0 every time. I still think my code is a little weird and...
-
-
MajP replied to the thread Solved Treeview nodes error.Looking at that, I am not sure why I wrote it like that. I am thinking the Root property does not give you exactly what you expect. As...
-
MajP replied to the thread A Function that returns a Recordset.IMO that is unusable. Because it does not show which nodes are expandable there is no plus signs. You have to guess if you can expand...
-
-
MajP replied to the thread A Function that returns a Recordset.If I am using a domain aggregate function I am probably using it more than once. Even if I am uncertain of its reuse I tend to go ahead...
-
MajP replied to the thread A Function that returns a Recordset.But like @Pat Hartman suggests, most of my DBs have tons of Domain wrappers. Sometimes hundreds. Very simple and do one thing. You pass...
-
MajP replied to the thread A Function that returns a Recordset.The question is not very clear, for what you want to do. But sounds like you want to get some values from a recordset and then...
-
MajP replied to the thread ItemGenie location address.There is an afterLabelEdit and beforelabeledit event procedure of an active X treeview. This event occurs when you edit the node text...
-
MajP replied to the thread ItemGenie location address.Here is the fix Public Sub RecurseIGTree(Optional ByVal ParentID As Variant = Null, Optional RS As dao.Recordset = Nothing, Optional...
-
MajP replied to the thread ItemGenie location address.Let me redo that. I can see that is not correct for the dining room shelves.
