[AccessD] Turn off delete buffer warning for Faster Delete Queries

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
>



More information about the AccessD mailing list