How to create dynamic column heading in Access form?

Discussion in 'Microsoft Access Getting Started' started by kande_ian, Nov 25, 2010.

  1. kande_ian

    kande_ian

    Joined:
    Nov 25, 2010
    Likes Received:
    0
    Apologies if this should be obvious but I'm only an occasional Access user and after several hours of Googling I've not found a solution.

    I am creating a simple database containing records with multiple fields of the form:
    Filename;Date;Location;Method;Parameter1........Parameter12.

    I have a tableMethodParameter that allows the user to define the Parameter names associated with each Method.

    I want to allow the user to view all records containing a particular Method (selected using a ListBox or ComboBox) and to display these in a form with column headings for the Parameter columns dynamically populated using the appropriate values from tableMethodParameter.

    It is this last part that is defeating me and any suggestions on how to do it, where to look for further help or even just appropriate terms to narrow my search would be much appreciated.

    Ian
     
    kande_ian, Nov 25, 2010
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Stephen

    Remove Col Heading in Subform

    Stephen, Dec 2, 2003, in forum: Microsoft Access Getting Started
    Replies:
    3
    Views:
    225
    Van T. Dinh
    Dec 2, 2003
  2. Guest

    Using user selected criteria in a report heading

    Guest, Aug 27, 2004, in forum: Microsoft Access Getting Started
    Replies:
    2
    Views:
    175
    Joan Wild
    Aug 28, 2004
  3. Hepzibuh

    Two line heading

    Hepzibuh, Aug 31, 2004, in forum: Microsoft Access Getting Started
    Replies:
    1
    Views:
    174
    Brendan Reynolds
    Aug 31, 2004
  4. Guest

    WHEN I Create A Access Data base It won`t Create a Switchboard ?.

    Guest, Sep 12, 2004, in forum: Microsoft Access Getting Started
    Replies:
    2
    Views:
    340
    Larry Linson
    Sep 14, 2004
  5. Guest

    Dynamic filling of Data in a form

    Guest, May 27, 2005, in forum: Microsoft Access Getting Started
    Replies:
    3
    Views:
    247
    John Bartram
    Sep 16, 2009
  6. Guest

    Wizard form does not let me create a form

    Guest, Dec 19, 2005, in forum: Microsoft Access Getting Started
    Replies:
    1
    Views:
    234
    Rick B
    Dec 19, 2005
  7. cho

    how to create a password form to open a form

    cho, Dec 29, 2006, in forum: Microsoft Access Getting Started
    Replies:
    0
    Views:
    221
  8. MShek

    Turning data into field heading, similar to a pivot table

    MShek, Feb 24, 2008, in forum: Microsoft Access Getting Started
    Replies:
    7
    Views:
    255
    Larry Daugherty
    Feb 28, 2008
Loading...