Set Warning won't turn back on Brenda from Michigan 12/11/2008 2:10:04 PM User has Access 2002 SP3 She uses Set Warning in various places in her macro. She has turned off Set Warning during database design and now wants it back on. She has set it to yes, but the function to create a new table just runs and does not give the warning. For now we are restoring the file from a backup but are curious as to why the Set Warning does not come back on. I do not do macros, so if you need some code, let me know and I'll get it from the user. Thank you!

Re: Set Warning won't turn back on "Steve Schapel" <schapel[ at ]mvps.org.ns> 12/11/2008 7:09:17 PM Brenda, There is a way of turning off warnings universally. This is via the Tools=>Options menu, and then the Confirm Action Queries option under the Edit/Find tab. I would not generally recommend doing this. Maybe this is what your user has done. I suggest making sure this option is checked, and then put a SetWarnings/No action in the macros in those cases where they do not want to see the confirmation messages. -- Steve Schapel, Microsoft Access MVP "Brenda from Michigan" <BrendafromMichigan[ at ]discussions.microsoft.com> wrote in message news:ED868BC9-D2B5-47BA-B830-165997BA6F6C[ at ]microsoft.com... [Quoted Text] > User has Access 2002 SP3 > > She uses Set Warning in various places in her macro. She has turned off > Set > Warning during database design and now wants it back on. She has set it > to > yes, but the function to create a new table just runs and does not give > the > warning. > > For now we are restoring the file from a backup but are curious as to why > the Set Warning does not come back on. I do not do macros, so if you need > some code, let me know and I'll get it from the user. Thank you!

Re: Set Warning won't turn back on Brenda from Michigan 12/16/2008 1:45:02 PM This was exactly the problem and the fix. Thank you for making ME look good! Brenda "Steve Schapel" wrote: [Quoted Text] > Brenda, > > There is a way of turning off warnings universally. This is via the > Tools=>Options menu, and then the Confirm Action Queries option under the > Edit/Find tab. I would not generally recommend doing this. Maybe this is > what your user has done. I suggest making sure this option is checked, and > then put a SetWarnings/No action in the macros in those cases where they do > not want to see the confirmation messages. > > -- > Steve Schapel, Microsoft Access MVP > > "Brenda from Michigan" <BrendafromMichigan[ at ]discussions.microsoft.com> wrote > in message news:ED868BC9-D2B5-47BA-B830-165997BA6F6C[ at ]microsoft.com... > > User has Access 2002 SP3 > > > > She uses Set Warning in various places in her macro. She has turned off > > Set > > Warning during database design and now wants it back on. She has set it > > to > > yes, but the function to create a new table just runs and does not give > > the > > warning. > > > > For now we are restoring the file from a backup but are curious as to why > > the Set Warning does not come back on. I do not do macros, so if you need > > some code, let me know and I'll get it from the user. Thank you! >