save automatically on form close

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,
Is there a way to save the form from run mode when the form is closed
(hide the prompt asking yes, no, cancel).


Thx
 
Can't do it from there. Normally, you would have a close button on the form
and the code would go there. If you don't want to see the message then in
the Open event of the form:
docmd.SetWarnings False
 
but if i choose not to display the warning, will it default to yes, or no?
also, by setting warning to false, it'll turn off every warning. I m only
interested in saving the design automatically without prompting the user.
 
Therein lies the problem. Setting Warnings off will supress all warnings,
and act as if you answered yes to every occurance.
There are two problems I have with your design:
1. I never put the close icon on a form so it has to be closed via my
command button.
2. I never allow changes to a form by a user. You don't know what state it
will be in when you open it the next time.
But, these are subjective opinions not to be confused with the "correct" way.
 
Jeff said:
but if i choose not to display the warning, will it default to yes,
or no? also, by setting warning to false, it'll turn off every
warning. I m only interested in saving the design automatically
without prompting the user.
Click to expand...

Why would a user be making design changes to the form in the first place?
Are you just talking about filters and such?
 
Be carefully here: Do you want to save the data currently displayed on the
Form or the *design* of the Form?
 
I entered a question a couple of hours ago under 'General' entitled 'Error
encountered while saving.' Despite seeing the msg when saving new records,
my data saves to tables correctly.

So, even though I see it's not recommended, I've chosen to use this tip to
hide warnings, however it's not running. I'm using:
DoCmd.SetWarnings = False

on the form's Open event, however, I'm getting a compile error "argument not
optional" highlighting the "SetWarnings" phrase.

Can you offer suggestions on syntax please?
 
Back
Top