Search results

  1. Y

    one db works, a copied version doesn't. driving me nuts.

    hi, i made an attendance db for work and got it to work. i then copied it and made two more for years 2 and 3. Years 1 and 3 work perefectly but for some reason the year 2 db won't allow me to write the data. this is driving me nuts as i have already spent a few hours putting the students in...
  2. Y

    problem with 'order by'

    Hi, I work at a university and have come up with (+ some help) a db to monitor attendance. The db contains students, courses and an attendance table. So far, so good. the only probles i have are that i really need to order the results by surname or it is going to be hard to use. I'm using...
  3. Y

    please can you check table structure/concept

    hi, i need a db to monitor attendance (I know there are examples that do this but I need to satisfy my own curiosity and haven't seen one exactly like i need). My plan is to set-up the tables as below. I now have one-to-many relationships. There are many students. each student will study many...
  4. Y

    help with adding data to multiple tables

    hi, i am new to access and struggling so any help would be great... i have a db with 3 tables. students contains a Primary Key ('studentid') and then 'firstname' and 'lastname' fields. The two other tables (contactdetails, coursedetails) have 'studentid' as a Primary Key and then they each have...
Top Bottom