ono opo neng ?
---In MS_Access_Professionals@yahoogroups.com, <ryan.paschal@gmail.com> wrote:
Here is my case:
I want the form to:
On Wednesday, February 12, 2014 3:35 AM, "wrmosca@comcast.net" <wrmosca@comcast.net> wrote:
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:
Hi,
I am MS Access 2007's user. I hope experts here can help me with my problems. My problems perhaps too simple for experts here.
Here is my case:
I need a form to add/edit employee data.
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 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
Please help me.
Thank you in advance.
Thank you in advance.
Best regards,
Ryan
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (25) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar