Form saves data to tables but not form view.

[Arron315]

Hi,
I am makign a database for my ICT A level course and I have gotten pretty far without the need for help. I have finaly got queries workign and was getting proud of myself until today the form that I made at the start has decided to act up and not function correctly. It used to add data to 5 tables (Block A, Block B , Block C, Block D, Student Details). It still adds data to the tables but when i save and exit the form and re open it, the data is gone from the form. Data entry mode is turned to no. If anyone can help it would be much appreciated as I need this finished within the next week.


Thanks to all who help.
Arron.

[June7]

Post your project for analysis.

Have to wonder why you have 4 tables with similar names. Are these tables identical in fields? If so should be one table with another field for BlockType (A, B, C, D)

[Arron315]

Thanks for replyign so quick. I have actualy fixed it so that it adds again now it was a lock file that was for some reason makign ti impossible to add data to forms but ok in tables. weird thing... anyway now I have another question. Is it possible to make a query that would search through the tables and pull out subjects that havent got enough students applying? eg. minimum amount of students needed for a course to run is 5 students but french has only got 4 people applying. Could that be foudn using a query? and how?
Thanks for any help.

[June7]

You have to search all 4 tables? Still sounds like should be one table. Answer question in my previous post.

[Arron315]

The reason I have done it accross 4 tables is because I was told it would get me more marks. Bizzarre I know but I do need the high score so I suppose thats what i got to do :P and each table contains one field called Block A, Block B etc. I also have a table that links them together using relationships (thats where the extra marks come in) which contains StudentID Block A ID etc. If you want I can upload you the database?
thanks

[June7]

Yes, I need to see what you are doing. If this is a class assignment and requirement is to demonstrate table relationships, probably a better way than with unnecessary table replication. Because now you want to query all 4 tables and this requires a UNION of the 4 tables, which essentially results in the 1 table structure they should have been in the first place!

[Arron315]

Ok I cant upload the file could i possibly email it to you? i tried compressing with 2 different packages and it says invalid file so email will be easiest way.

[June7]

You used Windows Compression to zip file? Never heard of issues with that. You will have to figure out the zip and attach file to post. Windows Compression is usually the only zip file I can extract.

[Arron315]

Ok ill use the fileshare site and post a link.

[June7]

Or upload to fileshare site such as box.com and post link(s) to file(s). No need to zip that upload but will need your Word document also.

Be sure to run Compact & Repair on the Access file.

[Arron315]

http://www.box.com/s/gmle24qnur3qvxpcotfi Thats the link to the database unrared and compacted.

[June7]

And where is the Word document? You could attach that to post without zipping if it is small enough.

[Arron315]

I dont know why but my database has no word document. What should I do is this going to cause problems?

[June7]

Sorry, mixed up threads. Ignore that about Word document. I will try to download your file tonight.

[June7]

As I suspected, bad db design. If I were instructor I would not give high score. Would each student have only one record in tblLink? If so, might as well have those fields in tblStudent.

A normalized table structure would be more like:

table Students

table Tutors
TutorID, LastName, FirstName, Address, Phone, etc

table Classes
ClassID (PK)
ClassName
BlockCode (A, B, C, D)

table StudentClass
StudentID (foreign key)
ClassID (foreign key)
Grade

Tutors teach all subjects? Will each student always have a class from each block?