How to add a submit button in Microsoft Access?
December 6th, 2009 | by admin |I’m new to this program, just started learning it this morning. I created a form, and I want to add a submit button to the form such that it saves the data and open up a new form. I can already save the data, but I still have the ability to edit the forms I saved earlier, which is not what I want. How should I do it?
The nature of Access means that you won’t be able to do it easily.
Access is designed to let you insert and edit records.
In your case you have already inserted the records.
I’m guessing that your form was created directly from the table.
A different solution would be to create a form that performs an insert.
You create a form with text boxes for the forms.
When you hit the Submit button the button calls some VBA which will perform an insert statement.
This isn’t a small project though.
Can you say which version of Microsoft Access you are using?
If you want more advice then you can email me using the email link on my profile.
2 Responses to “How to add a submit button in Microsoft Access?”
By Gh on Dec 6, 2009 | Reply
You need to use web tools
References :
By mark r on Dec 6, 2009 | Reply
The nature of Access means that you won’t be able to do it easily.
Access is designed to let you insert and edit records.
In your case you have already inserted the records.
I’m guessing that your form was created directly from the table.
A different solution would be to create a form that performs an insert.
You create a form with text boxes for the forms.
When you hit the Submit button the button calls some VBA which will perform an insert statement.
This isn’t a small project though.
Can you say which version of Microsoft Access you are using?
If you want more advice then you can email me using the email link on my profile.
References :
Too many years developing database applications