Search results

I really understand all these frustrations, and where possible, I work hard to improve the code for a better understanding of the principle of Late Control Binding. But we have not yet reached a common thinking. I will try to explain the principle as simple and as short as I can. When I want...

@tvanstiphout, Thank you for your nice words. First, our niches will be quite different. I suppose you are working with squaremeter-screens for high-speed data entry, my customers have mostly laptop-screens, and are more interested in to find the the right person that is called Petrus, of...

@isladogs, No, no explanation. Possibly the right part of the form is some remnant of some test for positioning. It is a loop through the Containers collection, with the Name of the Container, followed by the Count of the Documents in that Container. About your next question, I still work with...

@Albert D. Kallal, Thank you for your reply. Your definition of a re-usable control is completely different from mine. Referring to my definition you use duplicates of predefined controls, on a predefind form. So your forms are always dedicated to a certain situation. I have been working on...

@GPGeorge, In the meantime there is a little demo database uploaded, so you can see HOW things happen. One project is called "Archief", that tries to relate almost anything that "has happened" in a middle sized town with about 30,000 inhabitants, including persons, activities, addresses...

@tvanstiphout, I use only TextBoxes. But here is a difference of interpretation. In your classic model you can use a listbox to select a value, or a record. In my concept I do not use that. I use the TextBox as a really dummy control, with absolutely no user-information. It is just a...

@tvanstiphout, The PersonGroup_tbl is a junction table, and its fields are FK fields. That is a different "Veldtype" then some text. If you type a character (space or any other) then a new form is opened with the (filtered) records of the underlying Item, i.e. Person of E_group. If this form...

This is not the tone in a friendly forum, it is absolutely not constructive, and only denigrating. I will have to report this. You were trying to be funny?

No, I don't use user defined classes, no form classes, no control classes. I have (the same) form, with a number of dummy controls, that on opening the form, are placed, dimensioned and and layed-out according to their further meaning, defined by a Veldtype, and they get their initial value...

@RonPaii, No, not that I am aware of. What I do is write code in VBA to automate the underlying processes. These are parameterized to accomodate any Item/Entity and are independant of the form. All error handling is included in code of these processes. Because the code is independant of a...

@DHookom, Here a really simple sample. Place DHookom.mdb and General.mdb in some map. In the map you make a submap Data, to store DHookom_data.mdb, and also a submap Temp for report-output. (Dbl)Click on DHookom.mdb to start the application. Pressing one of the three buttons (Persons...

Can you also have ONE template for continuous forms and ONE template for all the rest? And this template (these 2 templates) work for ALL applications?

I agree, that a good design of the data with respect to the relations is the basis for a good robust application. But I don't "accept" that the forms have to follow that design. In my applications I have utilities that, when you used a wrong relation between two entities, you can convert that...

I am very disappointed that you say "you refuse us ..." I really did my best to do the opposite. But I think the models that we have in mind differ. Whatever I say, with my model in mind, is probably interpreted a little different with your model in your mind. Your solution - from your point...

@Edgar_, You seem the only one who understands the principle. What you sketch is the way I work with continuous forms, because these need a recordset. A minor difference is that I unhide the used controls. The metadata table in the FE with the control specifications, customizes the whole thing...

@DHookom, I have the zipped application at hand. But I have to modify the sample a little bit, because the word "GROUP" is a defined word, so I need to change that. I define my items as singular, Group_tbl, Group_id, I have to change that first. But now it is too late That is a pitfall that I am...

@Mark_, Thank you for your answer. I don't think I need Clarion on this moment In my approach I have 2 templates, one for a continuous form, and one for all the rest. That is not the problem. The problem with Access - in my opinion - is that the form, and thus its controls, are based on the...

@DHookom, The sample database with your specs is ready. I can attach the DHookom.mdb and the DHookom_data.mdb, but not the General.mde. How can I solve this?

@DHookom, Something like: Person_tbl Person_id PK Lastname Firstname Mailaddress_tbl Mailaddress_id PK Mailaddress Mailgroup_tbl Mailgroup_id PK Person_id FK Mailaddress_id FK

@DHookom, Please use the thread "Late Control binding to make Forms Field independant'. There I will concentrate on the topic, instead of using another one's thread.