Append Query Error

[darth sidious]

Hi

I am having problems adding details from StudentForm to student table. When I click on the add student button it throws back an error Microsoft Access cant append all the records in the append query.

I have attached the error as a pdf and the database for info.

Your kind help would be appreciated.

Many Thanks

Darth

 

[namliam]

Your macro under the button runs the append query "AddNewStudent" in doing so you are trying to add all existing students to the same student table.

Seeing as your form is bound to the student table already why work with unbound at all and not simply bind your controls?

To fix your problem remove your student table from the query, or write some "proper" code to write your unbound controls into your table.

You already trying something along the lines off a name convention but you are not really keeping it up... Really a name convention will prevent issues down the line...
If you havent already, it may be smart to read this:
http://www.access-programmers.co.uk/forums/showthread.php?t=225837&highlight=name+convention

 

[darth sidious]

Your macro under the button runs the append query "AddNewStudent" in doing so you are trying to add all existing students to the same student table.

Seeing as your form is bound to the student table already why work with unbound at all and not simply bind your controls?

To fix your problem remove your student table from the query, or write some "proper" code to write your unbound controls into your table.

You already trying something along the lines off a name convention but you are not really keeping it up... Really a name convention will prevent issues down the line...
If you havent already, it may be smart to read this:
http://www.access-programmers.co.uk/forums/showthread.php?t=225837&highlight=name+convention

Thank you for the info much appreciated. Append query works fine after table removed.