Search results

  1. N

    Combo box in subform only populating half the time

    In Access 2007, I have a form which contains the summary information of a store, and a subform which is intended to log records on employee hours for that store. The subform is supposed to display store employee names in a drop-down combo box using the store ID as a link. It's a straight link...
  2. N

    returning records for one-to-many tables for missing "many" record

    I attempted to search on this question but couldn't figure out the right search terms. Sorry if it's a repeat - and if so just point me to the post with the answer. I am trying to figure out how to write a select query that accomodates the following situation. Suppose I have a table of...
  3. N

    report displays multilist ID but not associated value

    I have a report based off a query. The query includes a table field that is collected from a multilist on a form (e.g. check all that apply). The multilist is based off another table that includes an ID field and a value field (1 = value1, 2 = value2 etc). The form shows the multilist...
  4. N

    changing field format based on variable value of another field

    I just spent an hour searching on this and didn't see anything - sorry if it's a duplicate! I have a form and subform. The form has basic info related to a client, one field is "total volunteer hours required" (totreqhrs). The subform has individual records of each volunteer appointment...
  5. N

    update table based on value checked in related table's subform

    Here's another question. I have two tables - one is a "family member" table and the other is an "events" table. The tables are linked one to many to allow tracking of which events are attended by which family members. I would like to be able to easily add records to the events table. My...
  6. N

    would like blank data entry record to appear at the top of continuous subform

    Hi there! New to posting but have been helped immensely by other posts/responses. You guys rock. Anyway - I have two tables, a "person" table w/some basic demographic information (person_id is primary key), and a "contact" table (contact_id is primary key, table includes person_id field and...
Back
Top Bottom