ACCESS FEED: RE: [MS_AccessPros] HELP

Sabtu, 25 Mei 2013

RE: [MS_AccessPros] HELP - Auto Save Bound Form

ZJubias-

I found some examples here:

http://msdn.microsoft.com/en-us/library/office/bb238523(v=office.12).aspx

.. and here:

http://www.databasedev.co.uk/confirm-record-update.html

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of ZJUbias
Sent: Saturday, May 25, 2013 8:32 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] HELP - Auto Save Bound Form

John,

Thank you, could you please give more help on the Form Before Update, how
could I use it.

I was trying to find a demo in goggle but I could not find one.

Thank you again,

zjubias

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas
Sent: Saturday, May 25, 2013 10:50 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] HELP - Auto Save Bound Form

ZJubias-

If you are using an AutoNumber field to generate RegID, then the number gets
"used up" as soon as someone starts typing in a new record - even if they
don't save it.

You can use the Form Before Update event to catch each record just before it
gets saved and verify that it is complete. You can also prompt the user to
ask if they want to save. If you need to kill the save, set Cancel = True
and tell the user to press Esc to clear edits before closing the form.

You can also provide a Cancel button that does this:

Private Sub cmdCancel_Click()
If Me.Dirty Then Me.Undo
DoCmd.Close acForm, Me.Name
End Sub

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of ZJUbias
Sent: Saturday, May 25, 2013 12:23 PM
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: [MS_AccessPros] HELP - Auto Save Bound Form

Hello pro's,

I need help to control the auto-save of the bound form. Today some of the
new employees did unknowingly mistake to my registration database.

What was happened, open the database, put some data in the data entry form
after filling some controls, they decided to close the form, then again it
comes the other new, open again, then close again..

Then it comes the real data entry they noticed that the serialized RegID is
not in sequence from the last ID they got, they asked me what was happened
with the database, and I was not aware too.

Please someone feed me how to get rid of this auto-save, am not good in code
yet, so if you can give me or direct me where I can find a demo that would
be a nice start. I need to have a button of my form such; Add, Save, Cancel,
Close..

Thank you in advance,

Zjubias

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links