Results 1 to 6 of 6
  1. #1
    Dave14867's Avatar
    Dave14867 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Nov 2016
    Location
    Upstate NY
    Posts
    376

    Is it possible

    I just had a thought about enhancing a database that I created and use everyday and I am wondering if it is possible to do something to give me a view I would like possibly in a tabbed form or just any form I can create. If I look at one of my tables I see the plus sign in the far left and if I expand on it I see all records relating to that record based on the relationships set up.

    Can I change the relationship using VBA for a specific form? That way I could leave original relationship intact. Another thought I had while typing this out was to create a custom query in the form that would essentially do the same thing. I am trying to expand my Access abilities here and hoping you folks can point me in the right direction as you always have with your expert knowledge and experience.



    Thanks in Advance

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Can I change the relationship using VBA for a specific form? That way I could leave original relationship intact.
    I don't understand what you mean.
    Forms don't have relationships. The data in a form and the data in a subform can be related.

    Can you be more specific about what you want to do?
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi Dave

    It is recommended that you get rid of the small Plus Sign in you tables which are referred to as "Subdatasheets"

    This allows the user to enter records into related tables.

    All users should never be allowed access to the table view so subdatasheets should be set to None.
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

  4. #4
    Dave14867's Avatar
    Dave14867 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Nov 2016
    Location
    Upstate NY
    Posts
    376
    I am working on a new form now to test out an idea, I'll let you know how it works out.

    Mike I definitely do not want users to be able to change data and will restrict that ability for sure, I just want to display data.

  5. #5
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Dave,
    Do you have a mockup of what your proposed form would look like to share?
    You may get some insight from Dr. Vershuuren here.

  6. #6
    Dave14867's Avatar
    Dave14867 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Nov 2016
    Location
    Upstate NY
    Posts
    376
    Testing indicates that the idea I had while typing the original question is working just as I had hoped. Thanks for the responses but more for making me think, which you folks always do.

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

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