Search results

  1. V

    Display lookup data on a form

    Hey, I am creating a database of all the equipment that we have and also a record of when it is checked for safety and inventory. I would like to have the primary key (from another table) stored in the database but the description for each item been shown on the form to the user that relates...
  2. V

    Store primary key but show another field

    I am creating a database of all the equipment that we have and also a record of when it is checked for safety and inventory. I am currently having problems getting the primary key stored in the database but the description for each item been shown on the form to the user. I have currently got...
  3. V

    Type Mismatch Error

    Hey, I get a 'type mismatch' error when i run this code, the field 'equipment_checked' is of type 'memo' and i understand that the rowsource can only hold 2048 characters but i have no idea how to get around either issue. The idea is that i am using a list box to display data on a form and...
  4. V

    Search and update form field query (i think)

    Hey, Objective I am creating an equipment database and this includes recording when the equipment is checked for damage etc. I have a field on the form which records when the last check was carried out. I would like to keep this field up to date so the latest date appears whever the user view...
Back
Top Bottom