Results 1 to 5 of 5
  1. #1
    trident is offline Competent Performer
    Windows 8 Access 2010 64bit
    Join Date
    Apr 2014
    Posts
    141

    Several fields, select what you want to show

    I have created a table with around 15 fields to enter.

    Know, when I open a form or report, I need only to enter a field name in a box or selection (could be around 1-8 fields) that I need and this is what ms access will show, I do not need to pass to a query to create the form or report I need.

    Is there a way for these.



    Thanks.

    Trident

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    How about telling us in plain English what it is you are dealing with generally? Remove any Access jargon and describe what you are trying to accomplish.
    Are you trying to search for something?

    eg. I work in a manufacturing shop. We sell manufactured Products. I need a report that shows which Products and How many were built during Dec 2015.

  3. #3
    trident is offline Competent Performer
    Windows 8 Access 2010 64bit
    Join Date
    Apr 2014
    Posts
    141
    I have 15 fields on a table, in a form/report, I want to choose only around 5 to 8 fields that will appear, this fields can change as what the user would like to appear.

    eg. fields are = ID, Name, Address, age, salary, position, location, hire date, separation date, tenure

    user 1 choose only name, age, salary, position
    user 2 choose only name, position, location, hire date, tenure
    user 3 choose only name, salary, position, location, hire date, separation

    so as you can see, it is like a dropdown list box, of fields that you want to appear in your form/report - this should not pass query.

  4. #4
    NTC is offline VIP
    Windows 7 64bit Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    If you want the user to decide which fields to display - about the only way to do that is to use the Datasheet form - as one can widen/narrow columns as well as drag/drop them in the order they wish.

    If you want the database to decide, based upon the user (or user class) - then one must have a log-in to establish who is the User; and then toggle field visibility based on code that fires during the opening of the form.

  5. #5
    trident is offline Competent Performer
    Windows 8 Access 2010 64bit
    Join Date
    Apr 2014
    Posts
    141
    is there a sample i can see.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 02-14-2015, 04:11 AM
  2. Replies: 3
    Last Post: 07-20-2014, 08:56 PM
  3. Replies: 3
    Last Post: 05-03-2014, 11:00 AM
  4. Replies: 1
    Last Post: 02-23-2013, 01:04 AM
  5. Replies: 7
    Last Post: 12-30-2012, 03:59 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums