Search results

You cannot drop "between". If you drop off of the nodes it will assume you want to add as a root node. You cannot stop or alter where it drops, but you can reverse it after the fact. Now I do have code in the item genie demoed where if items are dropped on another item (make no sense) will...

It is demoed in the Item Genie and in the E2E demo. See post #181. There are methods in the class to move up and down within a node. The arrow keys on the right are faster to move things up and down because you can just keep clicking them without right clicking the pop up menu. However, I...

But again, this not being my first rodeo, when the OP says they are 100% sure there will never be more than 2 bins, this means it is 99% certain they will be back because they now need a new solution for that exception when there are more than 2 bins.

My guess is you still have an open pointer to the instances. The code probably sets more than one variable.

For this problem, If you do not need all the additional functionality you get with the class then loading the tree might be easier to roll your own. Because building the right queries takes time and accuracy in the naming. And probably a good practice Writing the code may be actually easier 1...

Yep that is how I do it.

Yes. You simply have to filter the query you are using and reload the tree.

Here is a treeview demo. I think the original solution is better becuase more options in formatting. If you were adding, editing, deleting info then maybe use a treeview, but I cannot imagine you would do that. The information is fixed and known. For the amount of levels and nodes the tree view...

Why are you 13 posts in and still trying bang notation. What part of you can not use bang did you not understand?

As @The_Doc_Man shows this can only be done using dot notation not bang notation.

All of these companies have a Business development rep, customer care rep, Product support rep, or whatever they call it.. You contact them for a meeting and full demo and Q&A on capabilities, you will likely get more than you could possibly want and either alleviate your concerns or confirm...

The Recordset seems like a really bad idea. If you plan to reuse the variable but "reload" it. If you really plan to have one recordset and never reload it that would be OK, but cannot envision a database where that could be of any use. If that is a generic place holder variable then the chance...

Form Aesthetics is not my strong suit, but I will say your example is just painful to look at. I would hate entering info into that. With a little formatting and organizing you could make that nicer. Again this is not my strong suit there are people who can make really nice looking forms. But I...

Just formatting. Scroll bars - None Record Selectors and Navigation bar - no Name Field - locked and no tab stop. Might be disabled Subform - Transparent border Subform back color - same as main form This will work fine if you do not have variable amounts of quote. In my example I allow you to...

I would build the query once with the PK and the minimum fields needed for that calculation. qryCalculations Then you can create other queries linked to query calculations by the PK to PK. Now you have one place to update the calculations and you can use those field names in other queries...

I just presented to Access Europe today on this exact topic of Making "non - normal' forms while ensuring that you keep the data normalized. What you describe is similar to some of the techniques I demoed. Personally, in this case, I think I would have gone with the "fake subform" idea I show...

If it is just aesthetics you can make the subform not look like a subform. Just play with the formatting. Here the 5 subform records look like main form controls. Using your colors.

@arnelgp, Can you explain what you did since most of us cannot even test this. I did not see a change in the code so assuming it was some setting or design of the form.

1. Add customer 2. 3. If you select yes 4. Modify Choices This would also allow you to have an Add button. Lets say you did a bunch of leads with companies 1,2,34,5. Then the boss says to do 6,7 also. You can hit the add button and whatever was not included previously will be included...

My point has been that it is not that much work. The only hard part is dragging out the actual requirements. This is just a demo so there is likely more to it, but if you agree to the concept we can walk you through it. The reason we are all adamant is because we have see a ton of users come...