Recent content by jammyo2k

Thank you, neileg, you were right. All I needed to do was change the Add Student query. Thanks for your help. I know its a mess but I'm only an A-level student and a pretty bad one at that. My knowledge of Access is pretty poor as you can see by looking at the database. I'm not going to do IT at...

Its a school project and I'm nearly out of time. It's not a marking system as such, it's a system for monitoring the individual performance of students. As well as doing this it also has to provide statistical data and print out standard letters. Is there not a quick fix just to make it look...

I've uploaded a copy to the net. You should be able to view it here: http://hometown.aol.co.uk/jammyo2k/jim026.zip Its a 400K zip file. Thanks for the help

I'm using a query to add records to a number of tables. I am using a numeric field called 'Admission Number' as my primary key. My problem is that as soon as I have five records in each table any new records that I add replace the records already present. Any help would be much appreciated...

For some reason I keep on getting the message: "Error accesing file. Network connection has been lost" whenever I press a button to carry out a form-related operation. This trouble did not exist before I made some changes to te tables in the forms (i.e. field length changes). This should not...

Well, practically speaking, changing the structure of the database will not be particularly easy. But I find that if I use more than two tables in a query then I cannot edit the data. Is there anything else that could be done?

This database has kept me up all night. I need to make a query storing performance data for students in a school. To produce input forms I need to have a query that I can use to update the data held within the tables. There is a single student entity which has a one to many relationship with a...