Building Access Apps with User Definable Fields



Anyone have experience in building Access apps with user definable fields? (Not the kind of fields where you just let the user define the label for a pre set number of predefined fields.) I recently saw an app that uses an MDB database and allows the user to define totally new fields. The app maintains a table of the data fields. When a new field is added, it is actually added to the table in the MDB.

He uses multi-column form into which he places the fields, using predefined formats. His app is not Access so I can't just decipher how he does it. However, I would be more interested in a way to dynamically add new fields to specific that they be displayed at specific locations on the form.

Would appreciate any information you may have from experience doing such.

Bob
.



Relevant Pages

  • Re: Access apps with user definable fields?
    ... I have never seen this type of functionality in an Access application. ... > app that uses an MDB database and allows the user to define totally new ... The app maintains a table of the data fields. ... > He uses multi-column form into which he places the fields, ...
    (microsoft.public.access.formscoding)
  • Access apps with user definable fields?
    ... Anyone have experience in building Access apps with user definable ... label for a pre set number of predefined fields.) ... app that uses an MDB database and allows the user to define totally new ... The app maintains a table of the data fields. ...
    (microsoft.public.access.formscoding)
  • Re: Principles of a database in vb?
    ... > app to open and work with an MDB database. ... > Access, run your SQL queries, etc. ... >> standalone app. ...
    (microsoft.public.vb.general.discussion)
  • Access 2003 converts mdb when opened by VB app
    ... I wrote a standalone VB6 app a few years ago that maintains a .mdb database. ... reporting missing indexes, fields etc. ... the Access dlls are converting the mdb automatically to ...
    (microsoft.public.access.conversion)