Getting label captions saved during a form crash

[twgonder]

I've been working with several forms over the past few months
and am not quite sure what causes this, and how to get it to happen deliberately.

I design a form with English captions in the labels.
I have a routine that runs at form load that converts the captions to other languages.

Some of the forms, in design view now show the captions in languages other than English.
This seemed to happen when I had a form crash, and I answered yes to saving the form's design,
thinking that it wanted to save the VBA code,
but I also got the captions for the labels saved in another language that I was testing in.

Now it would be nice for me to deliberately cause a crash that saves the labels back to English.
I tried putting a divide by zero in the VBA code for the form and then ending the VBA,
then go to the form and close it and sure enough it asks if I want to save the design,
but now that I want it to, it doesn't save the labels in English (as that's what they were at the moment).

Anyone seen why the form's design changes when it was open (not design view), and how to get it to happen deliberately?

[Minty]

If you close a form with VBA and use

DoCmd.Close acForm "MyForm", AcSaveYes

It will save any changes without the prompt

The default action is to prompt I believe.

[twgonder]

@ Minty, #2 The MS helps just say the "object" is saved, but they aren't clear as to which object.
After testing with various ways of stopping the form after the DoCmd.Close is executed,
I can confirm the object that the form is based on doesn't save. (Maybe MS means the record "object"?)
In other words, the label captions remain in Spanish, and are not replaced with English (which is what they are in while the form is open).

[Minty]

The AcSaveYes parameter in the expression above is specifically for the form changes, not the data.

It's a common mistake for new users to assume that the AcSaveYes option is going to save their data changes, but although Access does that automatically on a form closing, it's nothing to do with that parameter in the DoCmd.Close programming.

[twgonder]

@Minty, Post #4

Here are the screen shots after doing what you suggested (I added a "," and changed it to my form name).

The design view in Spanish:


The form when it's running, not as an instance:


Adding your close line while the form was stopped:


And then going back into form designer, and the label captions didn't change to English (which they were when it ran):


Did I do what you were describing?

Or is this another case of Access not saving when you tell it to, or like the example I gave in another thread where you tell it NOT to save your VBA code, and it does?

[moke123]

Have you tried the DoCmd.Save method?

DoCmd.Save acForm, "Your Form Name"

https://learn.microsoft.com/en-us/of...ess.docmd.save

[twgonder]

@Moke123, post #6

Just tried that too, still remains in Spanish in the form design.
In the early days, Access was always crashing and restarting on me.
It sometimes still happens, but I guess I've subconsciously learned to avoid what caused it.
However, if I'm in the VBA editor, changing several forms, when I go to the main Access window, and close all the forms, it will still often crash.

I'm just not sure how to duplicate the error that caused the newer loaded captions to save.
Often, I didn't notice it till sometime after whatever it was that did it.