[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Save Table Layout Message

Posted on 2009-02-11
9
Medium Priority
?
388 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.
0
Comment
Question by:dwnn
  • 6
  • 3
9 Comments
 
LVL 75
ID: 23619449
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
0
 
LVL 75
ID: 23619457
Typo ... I meant

WITHOUT a corresponding DoCmd.SetWarnings True

mx
0
 

Author Comment

by:dwnn
ID: 23619603
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?
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 75
ID: 23619619
"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
0
 
LVL 75
ID: 23619623
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
0
 

Author Comment

by:dwnn
ID: 23619716
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.
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 500 total points
ID: 23619733
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
0
 

Author Closing Comment

by:dwnn
ID: 31545938
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.
0
 
LVL 75
ID: 23619887
Good ole reboot ... :-)

take care ...

mx
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question