MajP's latest activity
-
MajP replied to the thread Solved Treeview address.That was my point I was trying to make. In the E2E demo I had an unnecessarily complicated way to do this by using a dictionary to do... -
MajP replied to the thread Solved Treeview address.Just a wrapper on a dlookup to return the parent level identifier stored in the tables. Because you loop the nodes in order the parent...
-
MajP replied to the thread Solved Transferring data from unbound MS Access Form to another form.This is why you should not use bang but dot notation wherever possible and do not EVER EVER put spaces in any name of anything. Are you...
-
MajP replied to the thread Solved Treeview address.These are the values that I normally save for most Trees. TreeviewSort - If you read the nodes from the top to bottom that is the...
-
-
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()...
