Search results

  1. C

    Need info on implementing self join with employees

    I am quite new to Access. I am using Access 2007. I think I am dealing with a "classic" issue - including supervisor employee number on records and having them refer back to the same "Employees" table. I have searched the forum and found several references to "self join", but I cannot get any...
  2. C

    repeating the same date in a text box on a form

    Hello forum, I'm a rookie looking for what I hope is a simple solution that I cannot find in help system. I have a data entry form with a date in a text box. I am entering one record at a time. I need to be able to change the date, but for multiple iterations, the date is the same. That is, I...
  3. C

    Lookups with related tables

    I am a new user and I am reading The Missing Manual for Access 2007 by Matthew MacDonald. He recommends the use of lookups fields on data entry forms (pg 162). I have received input from other users recommending against this practice, but for rather vague reasons. I wonder if a couple of...
  4. C

    displaying two team names on the same form

    A lot of sports involve two competitors (individuals or teams) at a time, so this question could apply to many sports. I want to display a simple form that has competing individuals or teams with both their names. Also other info like date or result, etc, but the names are the problem. I...
  5. C

    rookie needs help with linked field on form

    I apologize in advance for the likely simple-minded nature of this question. I want a simple database to track the English Premier Soccer League. Naturally I have a table "Teams" with team names and a unique autonumber as the key field. A "Games" table has game number (key field -...
  6. C

    datasheet lookup, with intermediate relationship

    I am working with Independent School Districts (ISD) in the state of Texas. The State is divided into 20 regions. Over 1000 ISDs are divided among those 20 regions. Each of the 1000+ ISDs has between 3 and several hundred individual school campuses. Each has a name, but as you would imagine...
Top Bottom