Re: Access apps with user definable fields?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I have never seen this type of functionality in an Access application. I
guess I have never seen an application that needs to allow users to define
new fields. New fields would need to added to tables, queries, forms,
reports,...

This raises a red flag regarding your application design. It might be
justifiable but I can't see it.

--
Duane Hookom
MS Access MVP
--

<user@xxxxxxxxxxxxxx> wrote in message
news:u5rARegGGHA.1028@xxxxxxxxxxxxxxxxxxxxxxx
> 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
>
> bobalston9 AT yahoo dot com


.

Relevant Pages

  • 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)
  • 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)
  • Building Access Apps with User Definable Fields
    ... Anyone have experience in building Access apps with user definable fields? ... I recently saw an app that uses an MDB database and allows the user to define totally new fields. ... He uses multi-column form into which he places the fields, ...
    (comp.databases.ms-access)
  • Re: N-Tier Design Question?
    ... but sharing the same class definition. ... > I understand exactly what you are saying, but when I spoke of Business ... >> organizes and maintains all functionality for a single user of your app. ...
    (microsoft.public.dotnet.framework.aspnet)