Dynamic Controls

[Thinh]

I have managed to create dynamic controls in MS Access. the only problem that I have is that it wont work in compiled mode. I am creating a new form on the fly and then insert controls into that form before displaying it.

It seems database structure will get very simple with dynamic controls.
I have include picture to display that it is possible creating dynamic controls.

Please provide feedback on my implemenation. at this moment the only usage I have is that i can incorporate as many attribute without using columns.

 

[boblarson]

You can't create forms/controls/reports, etc. on the fly in a compiled version because you can't make changes to those items.

And, using a datasheet or continuous form subform you can incorporate as many attributes as you need for each item anyway. You don't need to create objects to do this. See my sample here on how to do it.

 

[Thinh]

I see your implementation. but with datasheet you cannot have different control on each line like in my screenshoot. The controls are limited by column. In my Implementation i can control what type of control is used for each line. I can make the field require or not required by changing a single checkbox in a table. I can also set different drop down value for each line item.

Will the dynamic controls work with access runtime model?

I have included the table that determine the order of the control and what control should be displayed.

 

[boblarson]

Well, sometimes we don't get exactly what we want. If you want it to be dynamic like that you will either need to have everyone use a full version of Access or write the frontend in a language like VB6 or VB.NET where you can do dynamic controls at runtime.

 

[Thinh]

Will it work with the MS Access runtime?

 

[boblarson]

Will it work with the MS Access runtime?

No, it will not as it isn't a full version of Access which is required to make "design changes" of which those are considered to be.