[AccessD] Modifying a query

Hale, Jim Jim.Hale at FleetPride.com
Thu Jun 8 15:01:18 CDT 2006


I guess if tables and queries have similar names it would be too easy to
accidently delete the wrong object. Besides, on error resume next always
creates a hassle when I turn off error checking when I'm debugging. I guess
I'm too lazy to use conditional compilation everywhere I should.
Hmmm.....OTOH if you want to add spice to your life coding without a net is
one way.
Jim Hale

-----Original Message-----
From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com]
Sent: Thursday, June 08, 2006 9:54 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Modifying a query


Jim:

That's going to be a really handy piece of code.

Would there be a downside, however, to using

On Error Resume Next
(Delete Object)
On Error GoTo 0

I've done that before but it seem s bit like working without a net. 

Rocky

Website: http://www.databaseadvisors.com

***********************************************************************
The information transmitted is intended solely for the individual or
entity to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or
other use of or taking action in reliance upon this information by
persons or entities other than the intended recipient is prohibited.
If you have received this email in error please contact the sender and
delete the material from any computer. As a recipient of this email,
you are responsible for screening its contents and the contents of any
attachments for the presence of viruses. No liability is accepted for
any damages caused by any virus transmitted by this email.


More information about the AccessD mailing list