Recent content by MajP

Well good luck. Often if the OP takes a little bit of effort explaining the issue the people on the forum can provide an answer in a couple of posts. We are now on 37 and maybe someone knows what you want, but I do not. Instead of answering simple questions you keep responding with some crappy...

So here is with incorporated Auto Paragraph Numbering. None of those paragraphs numbers are manually entered. As you add or move items the numbering is automatic. Although Comments can go in the header table, for me to make this work I probably pull into a seperate child table like BillItems...

Am I the only one thinking this, but every time the OP responds it seems the problem completely changes. How does post #30 relate to anything posted previously? I do not think I have ever seen someone so incapable and unwilling to clearly explain a problem. Instead just wasting everyone's time...

I think you will be very interested in my presentation here starting at 21 minutes https://www.access-programmers.co.uk/forums/threads/access-europe-wed-7-aug-using-treeviews-with-access-applications-pete-poppe.331867/post-1932142 You will see it pretty much does everything you are asking and...

NO. What I posted was a complete 100% working solution. No edits or modification required. I demonstrated that it works in the test. You just need to call the User Defined Function (UDF). You can use this in a query or calculated control. I called it GetPayment but you can rename to something...

The OP came back and said that was not correct. A misunderstanding.

Once you get nested iifs it becomes a pain to write and debug. So much easier with a UDF. Public Function GetPayment(MaritalStatus As Variant, BSalary As Variant, TaxLower As Variant, ColA As Variant, ExemptionCredit As Variant, Optional MarriedSalary As Currency = 25727, Optional SingleSalary...

Still no idea why that would be useful, but fully doable as previously demonstrated. I dynamically create a recordset for each employee Public MyRecordsets As New Dictionary 'need reference to microsoft scripting runtime 'This allow you to add and find a recordset with a user defined name...

I am glad it was clear to someone because like everyone else on this thread I have no idea what the OP is asking and why they would feel a need to do this. If for some bizarre reason I had to do it, I would use a dictionary instead of a collection because then you can check if the User defined...

Some advanced modern concepts here. https://www.access-programmers.co.uk/forums/threads/modernizing-the-microsoft-access-interface.331322/

I realize the provider table got imported into the response list. That should remain its own table IMO so I recreated it. With that said there may be times where you really want to search a very long combo like the Provider combo. Then you may want a find/filter as you type capability. See the...

I tried to recreate and even make a new form and still no luck. I think the autoexpand issue seems to be at the application level. I could not fix it whatever I tried. I do not know if this is one of the database settings. So for everyone, this is the current form and if I type F there is no...

If interested to get you started on the correct path to enlightenment. I ran some code to put all responses tables (>100) into a single table. There are 2685 responses. I kept the old table name to help Identify what the Response Category is. Even being non familiar with the subject matter, I...

@bonzitre I do not want to be late to the game here, but do you really not want to fix this? Please consider the suggestions. @Pat Hartman and @GaP42 provided some useable approaches. I would cry if I had to develop a database this way or I was the person inheriting this to maintain it...