Search results

hi gemma, thanks for the advice. i have removed the invalid entries but it still doesn't work for me. sorry - i am not so good at access. would you be able to post the file you got working? if you are too busy i understand. thanks mark

hi there. i can't update the students attendance. i set up a row source "Present";"Absent";"Holiday";"Other" for each week and when you select one of these it doesn't accept it.It just leaves the cell blank. This data is in form: Attendance_tbl Subform3 did you manage to get this part...

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...

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...

cheers for the tip

hi, thanks for taking a look. i think i need to have the weeks in there in some way as i need to query if someone is away in consecutive weeks. i did think they were repeating groups but wasn't sure of an alternative. should i create a table for each week? cheers mark

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...

thank you very much scottgem. that is very helpful and i appreciate your help. cheers mark

Can a very kind person take a look at this to check I am going in the right direction? I have had a look at ClassAssignments db but still find myself struggling... I now have three tables. Students studentID (PK, number) other fields for address, phone, etc FirstSupervisorID SecondSupervisorID...

cool. i am looking through the past help now and will let you know how i get on. thanks.

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...