Recent content by Divinite

  1. D

    Building an expression control on a form created through queries

    db layout The Attendees form holds a subform (Attendees Subform) which gathers data that is input on the Registration form. The registration form is separate and contains the information shown. The purpose is to add classes to the listings for each of the Attendees/Volunteers. What I need to...
  2. D

    Building an expression control on a form created through queries

    Only problem is that the registration uses that field in another form. If I remove it from the Registration table other forms will fail to work because of it. The picture attached here is one of the relationship structure for the whole database. My next post will have a screenshot of the...
  3. D

    Building an expression control on a form created through queries

    More fun problems I went back and added the Employees table to the SQL Query instead of the other query (SupervisorNames). Now I'm getting an error (as seen in the picture attached). No clue how to fix it (of course the help file doesn't actually HELP!)... If I can fix the query so that it...
  4. D

    Building an expression control on a form created through queries

    Still need more than one field... The fields are included in the recordsource already, however they are not tieing in correctly. I get a #Name? error for the expression that I'm using with them. The main problem is that I need 2 fields to appear LastName, FirstName which are drawn from the...
  5. D

    Building an expression control on a form created through queries

    I have a form that is created from multiple queries. In the form specific relationships, I have two tables, Events and Registration. I also have a query SupervisorName. They contain the following pertinent fields: Events EmployeeID Registration EmployeeID SupervisorName (Query) EmployeeID...
Top Bottom