Search results

Hi theDBguy, All what I have is the result of continuous result of generalisation code, so it is/was a long evolutionary path, with successes but also with failures. Where I say that I have one "The" form, I have actually two: one for continuous records, and one for all the rest. In the...

Hi The_Doc_Man. Well, the "RealWorld" I am referring to, is the "RealWorld" of that control. And absolutely not any "RealWorld". Therefore you have to join the Disney-world. That the "RealWorld" of the user-control can change is trivial. Exactly for that, it is a burden to use standard Access...

Hi theDBguy, I can "proudly" say that I don't use comboboxes nor cascading comboboxes. The underlying data decribes always the relation between the "cascading elements". Instead I define an sql-string that joins all these relations. When I open "The" form I first open an (generic!) Search form...

Hi AHeyne, I am very happy with your question. To begin with, I am not inventing something new, but look at the things in a different way. When you use an Access-application, you normally see a Form with Controls, e.g. a Postalcode control. But what the user/developper expects is far more than...

Hi The_Doc_Man, You can also read my answer to Pat Hartman. The way the different fields (controls) must be handled isd in your way: By the template. My point is, bring it to a metadata-table, And free the form from any user-interpretation. In that case a "form" is a "template" tuned by a...

Hi Pat, Thank you for your answer. Quite long, and it will take some time to consume all your comments. My first reaction was that you needed to get rid of your frustrations from how is was in earlier days. But in a second thought you are right from your point, but it missing my point. First a...

Perhaps a little out of topic for the OP. Working with dynamical forms make these things very easy. In each control, where-ever it is situated, I can (dbl)click on a control to open a Zoom-form. In this Zoom-form you find much functionality to "manipulete" the value of the control. E.g. (the...

I am not suprised that it did not work as you would have expected. What I understand,is that you use a template form, and then "reform" a copy of the form to a new form. And continu to work in the old classical way. Automating data handling is something else than automating processes for data...

Well yes, everyone his own flavour! I like the flavour that "unhides" the pitfalls, so it is easier to "see" the problem. Underscore and ampersand are not so interesting. For me it is the prominent space on the beginning of the line. Imb.

I have always problems with the way sql-strings are constructed. You have to read the whole line and find if it contains the necessary space and ampersand. Why not place them at the beginning of the line? In one glance you can see if all is correct: active_sql = "SELECT...

New to this forum, triggered by a thread, but alas I cannot find that thread. So I will sketch my situation. Since long I work on generalization of code to make programs more powerful and robust. Code must be as structured as normalized data. This has resulted in automation of many of the...

I am an Access-user since Access2.0, and since then developped over 100 different applications. The "weak points" of Access arised with my second or third application: copy/paste, copy paste, ad infinitum. Since then I started with the generalization of code. This opened the door the (partly)...