Recent content by lbenjaminl

  1. L

    I need help with conditional Icons/Pictures

    I guess I can cheat and make the subform update-able. And then set all the fields to not enabled and not Tab stops. I will try that.
  2. L

    I need help with conditional Icons/Pictures

    Both the master form AND the subform are read only. They are not update-able. The tick boxes are a part of the recordset of the subform recordset, as they are normalized attributes of the table.
  3. L

    I need help with conditional Icons/Pictures

    I might as well add: I also want to modify a table field to become a weblink if another column (defined as a link) is populated. Any clue? I dont want to have a naked web address.
  4. L

    I need help with conditional Icons/Pictures

    I have a Access 2016 DB. I am working on a Form that has a master/child relationship. This works perfectly. The subform works perfectly and loads the filtered rows as designed. The problem that I am tring to solve is that I have 9 Yes/No (-1/0) ControlSource fields. I am trying to relate each of...
  5. L

    Solved New To Access and VBA; Stupid Question

    I'm new, but cannot find an answer in the documentation. I have a controling subform (DisplayOptions). It has 6 checkboxes that control which columns to display throughout the application in addition to the three default columns. What I want to have happen is that when a checkbox is checked or...
  6. L

    Solved I want to return only the top three records

    I have a query that is defined by date and Activity Level. It excludes any Activity that has already been performed for the selected date. I get the right esults returned. I only want the first three records returned. Does anyone know how to do this?
  7. L

    Combo Boxes and Dynamic lookups (NOT Cascading)

    I have long lists in my combo boxes. I have already catorized the data as much as possible. I am looking for a solution that will use a dynamic LIKE clause as the user types and requery or filter the combo box. I have tried a couple of different things, but with no success. Help.
Top Bottom