Search results

  1. N

    Form design question

    I'm looking for some high-level guidance here. I have two tables, tblVolunteers and tblSkills. tblVolunteers contains a lookup column listing every skill for each volunteer. I'm writing a form that has a listbox with all skills; I want the user to highlight whatever skills she's interested...
  2. N

    Combo box starts with blank value

    I have a form with a combo box whose row source is a query: SELECT [Lname]+", "+[tblVolunteers].[Fname] AS Name, tblVolunteers.ID FROM tblVolunteers WHERE (((tblVolunteers.Lname)<>"")) ORDER BY tblVolunteers.Lname; When you open the form, the combo starts out blank: the values are all...
  3. N

    "Conditional total" field in a form

    This is probably simple, but I seem to be stuck... I have a form that displays data like this (based on a query): Description VehicleType Cost F150 TRUCK $100 Miata CAR $80 Taurus CAR $70 VehicleType is a combo box, so the user can select one of...
  4. N

    Sorting by date not working

    Hi guys -- I imported a TSV into an Access table. One of the columns was dates, and I set the corresponding table column to "Date/Time." However, Access seems to be treating the column as a string. For instance, in a query, it sorts the column like: 1/1/2001, 2/1/2001, 1/2/2001, etc. So I...
  5. N

    Newbie form question: combo box populated by one table, but writes to another

    Ok, I have a simple question. I have a database containing volunteers and the hours they worked. There's two tables: tblVolunteers: ID AutoNumber FName Text LName Text tblHours: workID AutoNumber workerID Number (foreign key) StartTime Date/Time EndTime Date/Time I want a...
Back
Top Bottom