[AccessD] Using macros - good thing or bad? Was RE: OT searchinname attachments in outlook2003

Rocky Smolin rockysmolin at bchacc.com
Mon Feb 22 17:26:44 CST 2010


Now we're getting somewhere.   

"Enough said."  Well, not quite enough.  Tell us more.  What kind of errors
do macros create that can't be handled?

R

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Monday, February 22, 2010 2:32 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Using macros - good thing or bad? Was RE: OT
searchinname attachments in outlook2003

1. Error handling.
Enough said.

2.  Simplicity.
There are many things which I need to do in code that  can't be done in
macros, I don;t want to look in one place for half of my application and
somewhere else for the other half - so I do it all in code.

3.  Maintainability.
It's much easier to search through and edit code modules than it is to
search through macros and the actions in them.


-- 
Stuart

On 22 Feb 2010 at 16:13, Drew Wutka wrote:

> Interesting question Rocky.
> 
> Macros serve their purpose, but if it can be done in code just as
> easily, there is no real reason to use a Macro.
> 
> Drew
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
> Sent: Monday, February 22, 2010 8:42 AM
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] Using macros - good thing or bad? Was RE: OT search
> inname attachments in outlook2003
> 
> General question on macros:   why have they fallen into disfavor?  
> 
> I had an opportunity to fill in as a teacher of an advanced Access
> course
> and a lot of the course was on macros which I never use.  Got a legacy
> 2007
> app to work with last month and it was full of macros.
> 
> Macros:  good or bad?  
> 
> TIA
> 
> Rocky
> 
>  
> 
> The information contained in this transmission is intended only for the
person or entity 
> to which it is addressed and may contain II-VI Proprietary and/or II-VI
Business 
> Sensitive material. If you are not the intended recipient, please contact
the sender 
> immediately and destroy the material in its entirety, whether electronic
or hard copy. 
> You are notified that any review, retransmission, copying, disclosure,
dissemination, 
> or other use of, or taking of any action in reliance upon this information
by persons 
> or entities other than the intended recipient is prohibited.
> 
> 
> -- 
> 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