We help IT Professionals succeed at work.

Save Table Layout Message

Medium Priority
400 Views
Last Modified: 2013-11-29
I am using Access 2000 with some vba coding. In the past, when I have made layout changes to a table or form, on exit a message asked me if I wanted to save the changes to the layout or design. All of a sudden, I am not getting those messages and the changes are automatically saved, which I do not want to do. What has changed? Is there a setting somewhere to get the warning messages back? It doesn't feel like a coding problem.
Comment
Watch Question

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
Most likely, you did a DoCmd.SetWarnings False somewhere with a DoCmd.SetWarnings True

Open the VBA Immediate window and enter

DoCmd.SetWarnings True

and hit Enter

mx
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
Typo ... I meant

WITHOUT a corresponding DoCmd.SetWarnings True

mx

Author

Commented:
Nothing changes when I use the immediate window to set the warnins on. I didn't knowingly add any code anywhere that changed the warnings to false...at least not directly. Are there any property settings or database default settings that could account for this?
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
"Nothing changes when I use the immediate window to set the warnins on. "

Nothing will be visible or obvious ... it just executes the command.

Open a table in datasheet view ... sort some column ... and click the X and see IF ... it asks you to save the 'design' changes.

mx
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
The only other properties are in

Tools>>Options>>Edit/Find tab ... in the Confirm section.  For good measure, be sure all of these are checked.

mx

Author

Commented:
Thanks. I was incomplete in my last answer. I executed the immediate code you mentioned with a return and then tried calling up a table, changing the column width, and then exiting. No warning. I tried changing a form in design view and exiting, still no warning. I made sure the 3 boxes in the Confirm section were all checked before I did any of this. Still no warnings. The change in status ocurred sometime during a session where I was adding some code for combo and command buttons for 2 forms, but the code was all about setting the current record to an ID value and nowhere did I mess with a SetWarnings statement. I must have done something, however, as I called up a backup copy I made before starting the code session and the warnings worked just fine on that one. If nothing else avails itself, I guess I could use the backup copy and recode to get a fresh new code. Might take a little time, but I need the warnings.
Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007
Commented:
Humm

Ok.. if you haven't already, try rebooting your system.

if no joy, open any Office app ... then from the Help menu ... Detect And Repair ...

Really can't think of any thing else, well I suppose a Compact and Repair wouldn't hurt either ...

mx

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
The reboot seems to have solved the problem--go figure. Windows XP Pro still contains some mysteries, I guess. Thanks for all your help. I have my warnings back. Take care out there.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
Good ole reboot ... :-)

take care ...

mx
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.