0
do the controls nee to save into database...i was thinking that maybe we can draw the control on the form dynamically and then save it as new form(for example form3.vb)...it just like we use mc access..if this way can be done ..then we don't need database to load the controls on the form right?basically the controls r quite standard textfield,combolist ..
do u have any idea or alternative for this?
0
You can certainly devise a way to do this, but I think you need to write the code for it.
You can cycle through each field in access and create the controls dynamically on your form in one method.
In the other method (to save the form). Cycle through the Controls collection in the form and write each control to the database using the OleDbAdapter
Sorry this is vague, but I suppose it would make an interesting article in the future.
If your controls are standard enough, then there is less information that you would need to write about the control in the database, but at a minimum you would need to write the x,y position of the control and perhaps the width, font, color, etc.
-Mike