How to save a record using form in MS Access

Asked By 0 points N/A Posted on -
qa-featured

I  am using MS Office 2007 on Windows 7, and I am developing a small database in MS Access.

I have created the form below to save data to the database. 

Now the problem is when I press "save" button the form does not save the data to the database.

How can I do that?

Note: I want to save record to table1

Thanks.

SHARE
Best Answer by iqbal_imran
Best Answer
Best Answer
Answered By 0 points N/A #117881

How to save a record using form in MS Access

qa-featured

This problem has occurred due to table problems as you did not define relationship among the tables. If you have done it properly, the next thing is that your primary key is not functioning properly or you didn’t define it. If you are using composite primary key, it is a possibility that it is not getting null value. Try to reduce the primary key to a single key. This method is done through a process called "normalization of tables" which reduces big tables to small tables. Check out the relationship. Or redefine your table as a final solution.

Answered By 0 points N/A #117883

How to save a record using form in MS Access

qa-featured

The possibility is the value you are passing from form doesn’t matches data type. Kindly also ensure the formats or any constraints you defined while defining the structure of your table.

Related Questions