William Benson
vbacreations at gmail.com
Sun Dec 4 22:09:20 CST 2011
Yeah code or a macro step I guess is all I got. I'd hoped a hot key variant on run might turn up. On Dec 4, 2011 11:05 PM, "Rocky Smolin" <rockysmolin at bchacc.com> wrote: > I suppose it's there in case you mistakenly start to delete all records in > a > table or mean to delete 100 and delete 10,000 instead. The only way I know > is DoCmd.SetWarnings False but that's in code. > > Rocky > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Benson, William > (GE Global Research, consultant) > Sent: Sunday, December 04, 2011 7:25 PM > To: Access Developers discussion and problem solving > Subject: [AccessD] Turn off delete buffer warning for Faster Delete Queries > > Is there a way to turn warnings off through the interface and back again, > without using a macro that has such steps or calling a VBA routine? Or is > there a way to get rid of that message that interrupts query execution to > inform me about exceeding Access's rollback buffer, thus continuing without > undo. I understand why Access offers this but frankly for me it is > superfluous, I would never change my behavior regarding that message other > than to click ok, so the warning is useless and an annoyance to me > personally. > > TIA. > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >