Recent content by MajP

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.