"Save Action Cancelled"

[Clois Beckwith]

I am getting the following in the Subject Line. This happens on two forms in
my frontend and I have checked the code for the forms and controls and
neither the form or the controls have a DoCmd.Save written into the code or
the controls. So I have no idea what is causing this. I have recently
converted from Office97 to version 2000-2003 Access. Any ideas?????

 

[steve]

sorry

you cant do this with microsoft access 2003.

you must upgrade to microsoft access 2004:
http://www.ammara.com/access_image_faq/access_loading_image_dialog.html


HTH

Steve

 

[Ray]

MS Access attempts to save a record (without telling you) when you press the
tab button on the last textbox of the form. For examlpe suppose your form has
three text boxes and you press tab until you arrive at the last textbox. At
that point if you press tab again, Access will see that you are at the last
field so it will try and save your record.

However, if you added validation rules or integrity rules to your tables,
Access cannot save the record so this message may appear.

When does the message appear? Do you press or click on something before it
appears? And what do you mean by "Subject Line"?

Ray

 

[Clois Beckwith]

The subject line or the error is " Save Action Cancelled". The form does have
buttons, but they are not the last buttons on the form, that is what is
puzzling and it only happens on two buttons, I have checked the code on both
buttons and the form code for both forms, and there is not any Event
Procedures for Open or Load.

 

[Granny Spitz via AccessMonster.com]

Any ideas?????

First, you need to determine *when* this error message occurs. Is it when a
form is closed? Or a button clicked? Or something else?

Do you have any macros that might be executing the save action when this
event occurs? Do you have any DoCmd.Close commands in your VBA code? How
about Quit? These would attempt to save an altered object before closing the
said object.

 

[Clois Beckwith]

This issue is "Resolved" Thanks to all who provided good information.