MajP's latest activity
-
MajP replied to the thread Speed Up Query.In my government experience it was always the opposite. There never seemed to be time or money to do it right the first time, but there... -
MajP replied to the thread Speed Up Query.@Mister-B, if you want help on restructuring this and moving the data this group can help. You may think that is too much work, but you...
-
MajP replied to the thread Solved Treeview nodes error.From what I am seeing it appears to load all the nodes with the proper tag, but somehow it is lost later or a specific node does not...
-
MajP replied to the thread SQL Code in Access Report.My point was more about the ease of building, ease of error checking, and ease of use. Once you build your query you will immediately...
-
MajP replied to the thread SQL Code in Access Report.That is hard to debug with all the formatting and logic. I would make a single query qryDonorsPerYear do an aggregate query where...
-
MajP replied to the thread Solved Treeview nodes error.When the class loads the tree and adds the node it reads the query and puts the Identifier into the tag property Do Until...
-
MajP replied to the thread Solved Treeview nodes error.Can you post an image of your query. I am guessing the query is not formed correctly and therefore the "Identifier" is not in the tag...
-
-
MajP replied to the thread Question on Comboboxes.In VBA there is null propagation, that was the recommendations for a "+" Null + String = null Null & string = string Public Sub Test()...
-
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...
-
