One MS Access form to handle all tables. RRS feed

  • Question

  • We have dozens of MS Access databases, each with many tables. We want to give the users data entry/edit forms for the tables.

    Rather then building a separate form for each table we would like to build one dynamic form to handle whichever table they select, the selection could be from a drop down list of all the tables.

    when they select the table, we can get the fields, however what would be the best approach to build the dynamic form on the fly?

    Both functionally and somewhat aesthetically pleasing.

    is this doable?


    Sunday, March 25, 2018 12:21 PM

All replies

  • You will get much more capability and flexibility if you use VB.Net or C# in a WPF application. One possibility is to create a UserControl Class for each table. The main form for the application could change the user control being shown based on the selection in the drop down list.

    You imply that there are no tables joined together. You might consider the possibility that it will likely be beneficial to do that for some tables in the future so consider that in your design.

    SQL Server and other databases have more support for multiple users so your company or organization might want to convert, either now or in the future. If the database is accessed in a separate Class Library or in multiple Class libraries that are separate for the UI then it will be easier to convert to a different database. That is called n-tier. The following are for ASP.Net but also apply to desktop applications.

    Sam Hobbs

    Sunday, March 25, 2018 4:22 PM