Prev: need band-aid for poorly constructed db
Next: Hidden Field in Datasheet view for a table
From: lastjackal1 via AccessMonster.com on 15 Dec 2009 13:19
Using Access 2007 working on databases made using ver 2003. After making a
design change to anything (table, query, form, report), Access does not ask
if I want to save the changes, it just saves them. This seems to happen only
when working with databases that were originally created in earlier versions
of Access, i.e., if I make a new database using Access 2007 (saved in mdb
format) it asks for confirmation before saving changes. Does anyone no why
this is happening or how to get it to function correctly?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200912/1

From: Adam Simpson on 17 Dec 2009 10:22
There is probably some code that has run that sets the warnings to off and
does not set them back on.
Ctrl G to the immediate window and type the following

docmd.SetWarnings -1

Then test saving

Adam

"lastjackal1 via AccessMonster.com" <u56450(a)uwe> wrote in message
news:a0a2d52da1f47(a)uwe...
> Using Access 2007 working on databases made using ver 2003. After making a
> design change to anything (table, query, form, report), Access does not
> ask
> if I want to save the changes, it just saves them. This seems to happen
> only
> when working with databases that were originally created in earlier
> versions
> of Access, i.e., if I make a new database using Access 2007 (saved in mdb
> format) it asks for confirmation before saving changes. Does anyone no why
> this is happening or how to get it to function correctly?
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200912/1
>


From: lastjackal1 via AccessMonster.com on 17 Dec 2009 19:02
That was it. I forgot to SetWarnings back to True in some code. Thanks Adam!

Lastjackal

Adam Simpson wrote:
>There is probably some code that has run that sets the warnings to off and
>does not set them back on.
>Ctrl G to the immediate window and type the following
>
>docmd.SetWarnings -1
>
>Then test saving
>
>Adam
>
>> Using Access 2007 working on databases made using ver 2003. After making a
>> design change to anything (table, query, form, report), Access does not
>[quoted text clipped - 6 lines]
>> format) it asks for confirmation before saving changes. Does anyone no why
>> this is happening or how to get it to function correctly?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200912/1

 | 
Pages: 1
Prev: need band-aid for poorly constructed db
Next: Hidden Field in Datasheet view for a table