How to save a record using form in MS Access

Asked By Jerick K 0 points N/A Posted on - 08/23/2011

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.

• Status: Open
• Question Views: 1211
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Access

Best Answer by iqbal_imran

Go To Solution

Best Answer

Best Answer

Answered By iqbal_imran 0 points N/A #117881

How to save a record using form in MS Access

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.

About iqbal_imran

Questions
0

Answers
6

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 08/23/2011
• Question Category: MS Access

Answered By Abe Adrian 0 points N/A #117883

How to save a record using form in MS Access

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.

About Abe Adrian

Questions
4

Answers
10

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 10/17/2012
• Question Category: MS Access