Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Developer Toolkits / February 2006

Tip: Looking for answers? Try searching our database.

Turn off Microsoft Office Access Prompt

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Red - 23 Feb 2006 23:38 GMT
The following message appears everytime I close an Access table useing
Office 2003.

HEADER:  Microsoft Office Access
'Do you want to save changes to the design of table 'dbo.xxxx_yyy'?

Question:  How does one turn this prompt off?

Have tried looking in Tools, Options, Custom with no success.

P.S.  Would you please direct me to the proper Newsgroup should this
newsgroup not be the correct newsgroup.

Thanks for your attention

RS
Alex Dybenko - 24 Feb 2006 06:02 GMT
Hi,
I think you can get this running docmd.SetWarnings false in immediate window

Signature

Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

> The following message appears everytime I close an Access table useing
> Office 2003.
[quoted text clipped - 12 lines]
>
> RS
Tony Toews - 24 Feb 2006 20:26 GMT
>The following message appears everytime I close an Access table useing
>Office 2003.
[quoted text clipped - 3 lines]
>
>Question:  How does one turn this prompt off?

You shouldn't be getting this message in normal use.  Unless you are
resequencing the view over the data by clicking on a column heading
and then clicking on the Sort Ascending (or Descending) button.

Tony
Signature

Tony Toews, Microsoft Access MVP
  Please respond only in the newsgroups so that others can
read the entire thread of messages.
  Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.