Search results

  1. B

    Linking Databases

    I have a number of databases in my system and I created a database that only has a switchboard form in it. This switchboard form has links to all of the various databases I have created and opens their default input form. This works fine but now I wish to place a button on the switchboard to...
  2. B

    Three Fields Searched in One Query

    I have a database that records information on the staff working in the building (over 400). This information includes the licence number of any vehicles (up to three) they might be parking in the parking lot. I have created three fields in the table to record the licence numbers of the...
  3. B

    Query by Month

    I have a database that keeps track of tasks my staff does through the day, I have a simple query that counts the number of times each task was performed. I have been running the database for a few months now and I would like to modified the query to perform the query by month and not just the...
  4. B

    Query Form Problem

    I have build a Access 2003 database for my Movie Collection. I have set up an form query to search the database for things like year, MPAA Rating, Gender. I have used the following criteria in the query [Forms]![Query Form]![txtField Name] and it works just fine When I set up the search...
  5. B

    linking fields in a form

    I wish to set up a DB to control the issuance of keys. I want to set up an input form where when you enter the key number a one field it will populate the Name field with a list of people who are allowed to have that key. The DB will have around 30 keys each one has it's own list of people who...
  6. B

    Conecting table main form and sub form

    I have had some experience working with Access 2003, but only with simple standalone databases, which I designed using the Access wizards. I am now working on a database that uses sub forms. My problem is this: I have a main form called frmProblems with a sub form called frmInvolved, which is...
Back
Top Bottom