Search results

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

@GPGeorge, @isladogs, My problem with a simple sample database, is that it works an almost any sample databases, only without too much cosmetics. The added value is that the database is almost complete automatically generated, independant of any user-definition. For starters with programming...

I'm sorry, I never realized that.

I am looking for some "soulmates", who are working on the subject of Field independant Forms, to start a discussion for further exploration. In standard Access forms are bound to a RecordSource. In this way the form knows which controls can be used, where to find the values, and where to store...

Is that the main form including subforms for the relations?

It is to premature to post full documentation or a sample application file, since the concept is still in "heavy" development, though the main processes are clear. But I am willing to join a zoom call. Only. I don't know how to do that.

I am sorry @DHookom, I had a reply, but for some reason it disappeared .... Am I blocked?

Hi Azaverte, I use junction tables, but no subforms! Instead of a subform I open a new main form of the related items as are in the subform. The advantages of this is that you are not limited to the size of the subform control, and, the new form is not a child form but an independant (main) form...

Poor Pat. Well, the essential part is not the unbound form, it is the late binding of "any" control. That makes it equal whether the form is bound or unbound. But why use a bound form when it is not used in that way. It has only limitations with respect to the available fields because of the...

Is this your start of a discussion about the post/project? I don't see any connection?