By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 1,588 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

data entry forms writing directly to the tables?

P: n/a
Hi,
I have a form for data entry and noticed that when i enter data and
close the form, there is no warning and it writes directly to the
table(s).

Is this the default action?
Is there a way to fire a warning saying "do you want to save the info or
press cancel to close and not save etc"....

Thanks

*** Sent via Developersdex http://www.developersdex.com ***
Jan 20 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Fri, 20 Jan 2006 03:24:14 GMT, jim Bob <fr****@gmail.com> wrote:

Yes. The same happens when you click a navigation button to go to a
different record. It's the way Access works. It won't take most people
more than a few days to get used to it, so for most applications it
doesn't pay off to fight it.

If yours is in that 0.01% class, you might want to put up a message
like this:
Private Sub Form_BeforeUpdate(Cancel As Integer)
If MsgBox("Wanna Save?", vbQuestion Or vbYesNo) = vbNo Then
Me.Undo
End If
End Sub

Again, you're going against the grain of Access. Only do this if you
REALLY have to.

-Tom.

Hi,
I have a form for data entry and noticed that when i enter data and
close the form, there is no warning and it writes directly to the
table(s).

Is this the default action?
Is there a way to fire a warning saying "do you want to save the info or
press cancel to close and not save etc"....

Thanks

*** Sent via Developersdex http://www.developersdex.com ***


Jan 20 '06 #2

P: n/a
Thanks for your comments.
Yeah, I know what you mean. I'm doing the db for highly un-tech people
and they posed this question. I'll "try" to convince them that this is
the way it is.
Cheers.

*** Sent via Developersdex http://www.developersdex.com ***
Jan 20 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.