Results 1 to 2 of 2
  1. #1
    peasoup42 is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Sep 2015
    Posts
    2

    Yes/No selected to show certain entries on form

    First, I'm a babe when it comes to Access. I've never worked with it and avoided it at all costs by using Excel when I could. I now have a requirement that I'm forced to keep record of events. Within each event, I have one and/or multiple resources that are used. In each resource used I have data entries that must appear on the final report of each event.

    What I've created so far is a form for data entry, for simpleness, I've titled that form "Add Event". It contains the identifying information for the event (event number, title, date, time, internal data destination). It also currently contains the 20 possible resources that can be used by the event and the resources are listed with a Yes/no Data Type (check box).

    QUESTION #1-
    My goal is this, for ONLY those resources with Yes/no that is a "Yes", I would like to have what I believe is a sub-form appear where I can enter further details associated with that resource. The Tuned Freq, Data Rate, and Signal Modulation are text format entries. Example of this sub-form with Resource #1 selected (sorry I had to add dashes to space them out):

    Resource #1 - Combined ----------------------------------External Data Destination (these will be titled, Yes/No Date format, any combination of the 5)
    Tuned Freq-------Data Rate-------Signal Modulation -----#1-----#2-----#3-----#4-----#5

    Resource #1 - Left -----------------------------------------External Data Destination


    Tuned Freq-------Data Rate-------Signal Modulation------#1-----#2-----#3-----#4-----#5

    Resource #1 - Right----------------------------------------External Data Destination
    Tuned Freq-------Data Rate-------Signal Modulation------#1-----#2-----#3-----#4-----#5

    **Note: if any part of the "Combined" has data entries, both the "Left" and "Right" must be shaded/blocked from accepting data. And vice/versa, any entry in "Left" or "Right" blocks out the "Combined" entries.

    If I can figure out this part, I can easily just cut/paste for the remaining 237 resources.

    I greatly appreciate it.

    I'd like to avoid VBA if possible, the server this file is on doesn't chew on that or macros very well due to security settings. :-(

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    If you have a yes/no field for each 'resource', that is not a normalized data structure and will likely cause you lots of difficulty.

    Really need to know more about the data structure. If you want to provide db for analysis, follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. show text box if tick box is selected
    By zac123 in forum Access
    Replies: 16
    Last Post: 09-06-2015, 12:14 PM
  2. Replies: 3
    Last Post: 12-29-2014, 10:14 AM
  3. Replies: 3
    Last Post: 03-03-2012, 03:54 PM
  4. Replies: 2
    Last Post: 11-30-2011, 07:24 PM
  5. Query to show blank entries
    By jo15765 in forum Queries
    Replies: 1
    Last Post: 12-09-2010, 08:15 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