MajP's latest activity
-
MajP replied to the thread Programmatically construct a constant's name and return its value.I think I would update the class so you have run time "setable" constants and design time read only. 1. Provides intellisense for... -
-
MajP replied to the thread Programmatically construct a constant's name and return its value.What is the purpose that you are trying to achieve? The only thing I can guess is that you want to set the value once like a constant...
-
MajP replied to the thread Solved Treeview address.I am not following your numbering scheme. Is it the outline level like E2E demo 1 --1.1 --1.2 --1.3 -----1.3.1 -----1.3.2 2 3
-
-
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...
