Search results

  1. Z

    Storing numbers and not text

    Hi, I have a table with an auto number primary key field, and then several other fields, Address, Unit, Owner. I created a form with a combo box that looks up the Address from another table and populates the three fields when you click a record. I have it set to store the first value, (Address)...
  2. Z

    Importing Lookup Fields from Excel

    Hi! I have a table that contains about 75 fields. Each field is going to be a Lookup field that will allow the user to enter multiple values. This is for a home inspection service. So the first field name will be ExteriorShingles. The user clicks the dropdown arrow, and is allowed to select...
  3. Z

    Date Fields

    Hi, I created a query with one expression field that updates a user inputted date field on a form. The expression adds a certian amount of time to the field (usually six months) so I know when the next inspection should take place. Everything works great except when I put a parameter in the...
  4. Z

    Date Fields

    Hi All, I'm somewhat of a beginner when it comes to VBA, and I don't even know if I need VBA for this one. I have a form that contains three fields, LASTINSPECTIONDATE, FREQUENCYOFINSPECTION, and NEXTINSPECTIONDATE. The FREQUENCYOFINSPECTION is a combo box containing only three choices; "one"...
Back
Top Bottom