A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Saving form on changes



 
 
Thread Tools Display Modes
  #1  
Old February 2nd, 2010, 07:10 PM posted to microsoft.public.access.forms
szag via AccessMonster.com
external usenet poster
 
Posts: 99
Default Saving form on changes

I don't know how but somehow I must have disabled asking if I wanted to save
my form changes when closing a form. It has been ok up till now but today I
made a ton of changes (that I did NOT) want to save and there was no way of
not saving because when I closed it automiatically saves without asking. I am
using 2007.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201002/1

  #2  
Old February 2nd, 2010, 07:43 PM posted to microsoft.public.access.forms
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default Saving form on changes

You, quite possibly, turned off warnings. You should be able to turn them
back on in Options (In the Office button). If you used code to turn them
off, you must remember to turn them back on again in your code, or this will
keep happening.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"szag via AccessMonster.com" u2885@uwe wrote in message
news:a30ad3f8cbb0a@uwe...
I don't know how but somehow I must have disabled asking if I wanted to
save
my form changes when closing a form. It has been ok up till now but today
I
made a ton of changes (that I did NOT) want to save and there was no way
of
not saving because when I closed it automiatically saves without asking. I
am
using 2007.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201002/1



  #3  
Old February 2nd, 2010, 08:02 PM posted to microsoft.public.access.forms
szag via AccessMonster.com
external usenet poster
 
Posts: 99
Default Saving form on changes

thanks. I don't know why I am missing it but do you know where that shows up
in "Access Options" - 2007

Arvin Meyer [MVP] wrote:
You, quite possibly, turned off warnings. You should be able to turn them
back on in Options (In the Office button). If you used code to turn them
off, you must remember to turn them back on again in your code, or this will
keep happening.
I don't know how but somehow I must have disabled asking if I wanted to
save

[quoted text clipped - 5 lines]
am
using 2007.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201002/1

  #4  
Old February 3rd, 2010, 12:31 PM posted to microsoft.public.access.forms
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default Saving form on changes

Office Button Access Options Advanced Confirm
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"szag via AccessMonster.com" u2885@uwe wrote in message
news:a30b467779039@uwe...
thanks. I don't know why I am missing it but do you know where that shows
up
in "Access Options" - 2007

Arvin Meyer [MVP] wrote:
You, quite possibly, turned off warnings. You should be able to turn them
back on in Options (In the Office button). If you used code to turn them
off, you must remember to turn them back on again in your code, or this
will
keep happening.
I don't know how but somehow I must have disabled asking if I wanted to
save

[quoted text clipped - 5 lines]
am
using 2007.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201002/1



  #5  
Old February 3rd, 2010, 01:50 PM posted to microsoft.public.access.forms
szag via AccessMonster.com
external usenet poster
 
Posts: 99
Default Saving form on changes

I looked at that but I have them all checked.

Plus I don't understand how "Record Changes", "Document Deletions" or "Action
Queries" has anything to do with asking me to save changes to a form.



Arvin Meyer [MVP] wrote:
Office Button Access Options Advanced Confirm
thanks. I don't know why I am missing it but do you know where that shows
up

[quoted text clipped - 10 lines]
am
using 2007.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201002/1

  #6  
Old February 4th, 2010, 03:23 PM posted to microsoft.public.access.forms
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default Saving form on changes

Document Deletions does. You must have warnings turned off in a macro or in
code somewhere in your app.

If it's in code, it will be easy to find. Open any code window, go to Edit
Find, then look for "Set Warnings" in your project. Macros will be more

difficult since you'll have to go through each one of them, looking at each
argument.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"szag via AccessMonster.com" u2885@uwe wrote in message
news:a3149aad834ec@uwe...
I looked at that but I have them all checked.

Plus I don't understand how "Record Changes", "Document Deletions" or
"Action
Queries" has anything to do with asking me to save changes to a form.



Arvin Meyer [MVP] wrote:
Office Button Access Options Advanced Confirm
thanks. I don't know why I am missing it but do you know where that
shows
up

[quoted text clipped - 10 lines]
am
using 2007.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201002/1



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:36 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.