Search results

  1. L

    Solved Query to Find Vacant Positions Using Start and End Dates

    I have a database with the following tables: tblPeople, tblSpaces, and tblMMPeople_Spaces, which is attached. The tblMMPeople_Spaces table is to record assignment of people to authorized space and records the start and end dates of the assignment, if known. If not known, the start or end date...
  2. L

    Solved Filter by date a variable number of days into the future.

    I am trying to filter a form that displays data from an employees table. Each employee record has a scheduled departure date: [EndDate]. I want a user to be able enter the number of days into the future that they want to see upcoming departures: textBoxDays. For example, if the user wants to...
  3. L

    Solved ComboBox Blank When Field Contains Data Not In Row Source

    I have a combobox with the following characteristics: Data Control Source: ContractingOfficerName Row Source: qryContacts_KOs Row Source Type: Table/Query Bound Column: 1 (ContactID, autonumber) Limit to List: Yes Allow Value List Edits: Yes List Items Edit Form: Inherit Value List: Yes...
Top Bottom