Search results

Hi Uncle Gizmo, I am aware of all the points, and many of them I have not yet straightened out. Try to understand the concept was the first priority. A visual demonstration would be the best. On hands is geographical undesireable, and I don't know how to make a YouTube video presentation...

Your choice is your choice is a good choice. What kind of "anything concrete" you had expected? Imb.

Hi The_Doc_man, I like your "partly" It is good to know the limits. I don't see Access to rule the world, and see it only as a small scale application. Of course you can argue what small scale is. I am not commercial. I develop applications for all kind of non profit organizations driven by...

Hi Pat, Well, I think I have to nuanciate my question a little bit. 100 as an abolute number is just a matter of time. But manage 100 applications at the same time including new wishes and ever growing functionality is a little bit different. Many, many controls can contain country-specific...

Hi DHookom, Thank you for this compliment. I think I was in the wrong forum. Almost all questions were about problems that did not exist in my systematics any more. And all my answers were more a disturbance of the standard Access way. On the other hand, while it was an open forum, no one ever...

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)...