Search results

Hi Edgar_, Yes, about the English/Dutch mix, it needs still some upgrading, but as far as I can see that is not a big problem. The end form is perhaps a little misleading. The left part shows the "menu" with Items, the only one being Contacts. In the right part you would see the contents of the...

Hi Edgar_, It wouldn't suprise you that I have a "Database of Databases", which contains all my applications. It is a.o. used for contact information towards the user(s). But this application also has tools to analyze all applications. Since application specific information is only stored in...

Hi Edgar_, In general you are heading in the right direction, in detail it is a little different. It is now late here, and it will take me too long to explain my way of working, but tomorrow I will come back. Imb.

Let me try to describe in short how the dynamical forms work. Some parts I will skip on the moment, because it will disturb all the readers too much, I suppose. I have a table "A_Veld_tbl" with all the fields from all tables in the application. See before. I have also a dynamical form with only...

No, the form is already build, only filled on the fly. And that in any way that is handy for the current problem. I like Access the same way as you do, but if you manage many, many applications, maintenance becomes a problem, because each application is in a far extent independant of the other...

Hi Mark_, Yes, I know, but that is not the point. The point is when you start your 4th, or 5th ..., application that needs a postal database, and moreover the current systematics "must" be extended, then you have quite a lot of copy/paste work. Better is to have one shared system. When...

Hi bushwacka666, Banker's rounding does work, but only on exact 1.915, and not when it is a very, very little less then 1.915. And this is caused by the division in 19.15 / 100 * 10. See the results of: result = Round(1.915, 2) result = Round(19.15 / 100 * 10, 2) result = Round(CCur(19.15...

Hi The_Doc_man, It is good to be skeptic. Personally i would not speak of "automatic" systems that self-generate forms and interfaces. I like more the "re-use" of as much as possible. Imb.

Hi Mark_, I have no experience with Clarion 2.0, so I cannot answer that. The "template" that I use is not a "standard template", it is just a bag full controls. After definition (the layout) most off the control-events are handled in the general library. These are the regular events of a...

Do you happen to wear smoky sunglasses?

Hi DHookom, The "form" is stored as a couple of procedures in a general module. One procedures for the layout of the form, a couple of procedures as a kind of "click event" for the different "button" controls, that are specific for the form. Most of how these forms behave are generic over all...

The value of Total is displayed as 1.915, but how is it stored? As 1.9149999999993, or something like that? In that case the rounding is correct. This can happen with real values because of its natural inaccurancy. Better use the Currency datatype in these cases.

Hi The_Doc_Man, Did you ask that question also at Microsoft, when you started with Access? See me as an enthousiastic researcher, who drilled down the generalization path, resulting in a feasable concept. Working now on removing the evolutionary errors, optimizing the code, and make it more...

Hi DHookom, No, absolutely not. Unless I misunderstood your question. The entire system has evolved in a RAD-tool, using generalized code. Just name the Application, the Items (entities) and the Fields, with for every field to data for definition table, and the application is ready. Just need...

An additional feature of this approach is that you can enlarge and shrink at will. factor = 1.25: factor 0.8:

The definition table in datasheet view is too large for display, thus in a couple of steps. First the form with all Items: Zoom in to the fields of "Crypto": And finally all the descriptive fields of "Omschrijving": With this "A_veld_tbl", with a record for every field in the...

Hi DHookom, I was not in the position to answer till now. In my never ending work on generalization I realized that Forms are quite static, because they contain relevant information about the fields. By excluding this from the Forms, and transfer it to definition tables and/or general modules...

Can you give me an small description what you mean with the "sequences"? It would help me for a better formulation of my postulate. Did they build up experience with "two forms"? I shouted my "Eureka" only recently, after many years of generalization, from the start with Access2.0. I don't...

I have taken a few days for sabbatical leave, to give my mind some rest. I experienced this thread as dominated by a couple of persons, and their admirers, that only shout without trying to understand the underlying principle. "Throw the code over the wall, and we understand it". I must admit...