Search results

@Edgar_ I only use unbound forms, and to be specific, only two for all applications. Binding is necessary for the control to know where to get its information, or where to store it. In my applications I use a "dynamic" bonding, that is, in the Enter event of any control the whole binding and...

This is the way I build my applications, completely event driven. I don't use Classes, but just "THE" Control. During the load of the form a reference is made to a metadata table, that holds the description of how the control should behave, including the corresponding table and field, to get...

The way I work with my dynamical forms is I think in line with class module code, but without the formal declarations. On of my first attempts, some 20 years ago, was a calender form, and is still actual. It is still based on a predefined form, with the controls "on their place". It is activated...

I usualy do it in the Open event of the (sub)form, after all controls are defined. Then I do a Resize of the form, and depending of the number of records (continuous) or controls (unbound), the Scrollbars are defined. Imb.

I have no problems with Scrollbars. In a main form I use: HB_form.Scrollbars = 2. in a sub form I use: HB_sub.Form.Scrollbars = 2. Imb.

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: