Ryan
Nothing is too simple for posting here. We help members with all levels of Access knowledge.
About the Save button...Access is built to save data straight into the underlying table. That is one of its most powerful features. If you want to stop an auto save, make whatever fields you want to be required in the table. That way if the user moves off the record and the required fields do not have entries Access will give the user a warning and halt the record insert. That might be all you need.
The Cancel button would need to have just a simple Click event. Create the button and select it. In the Properties sheet, Select the Click event. You will see a builder button (...) to the right of the line. Click it and pick Code. That will open the code window to the button's Click event.
It should look like this:
Private Sub YourButtonName_Click()
End Sub
Put a line inside the Sub so it looks like this:
Private Sub YourButtonName_Click()
Me.Undo
End Sub
That should remove all entered data provided the record has not been saved yet.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
---In MS_Access_Professionals@yahoogroups.com, <ryan.paschal@gmail.com> wrote:
Here is my case:
I have made the basic form using form wizard, but it saves everything into table anyway without confirmation because it's connected to employee table directly via RecordSource.
I want the form to:
- Have a button for saving the record; confirms whether or not user want to save the record
- Have cancel button to cancel all data entry & clean the form to start over
- In view mode, be uneditable unless clicked the edit button
Thank you in advance.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (24) |
Tidak ada komentar:
Posting Komentar