I'm trying to spruce up a database for pupil timetables at a tutorial college. I've been wracking my head over this problem for far too long: - I have created a query to indicate which students are currently at the tutorial college. It is based...
I'm trying to spruce up a database for pupil timetables at a tutorial college. I've been wracking my head over this problem for far too long:
- I have created a query to indicate which students are currently at the tutorial college. It is based on multiple queries (list of students; travel to the country; travel within the country)
- Basing a form on this, when you double click a student, I've set a macro to open a form that shows student timetables per week.
Altogether there are lots of queries and many tables involved - too many too explain probably. Therefore, I'll put my question abstractly:
"When I try to enter data for a student's timetable when it is sorted by weeks, I receive the message [Field Cannot be updated]. Despite saying this it will let me type in the info for that row, but when I try to update the row, I get the message [Microsoft Office Access database engine cannot find a record in the table "X" with key matching field(s) "Y"]"
Can anyone suggest why someone might get these two messages?
Thank you in advance!!
Dave