<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2722.900" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=086051717-25042003><FONT face=Arial color=#0000ff size=2>Hey,
no, that's not what I said, and least not what I meant! <grin> I
meant that the Macro is just an 'interface' to what is done in the
background. In Excel/Word, the macro is what runs a VBA procedure.
The VBA procedure IS VBA, but the Macro is just the process that kick starts
it. In Access, you have stepped macros, but those steps can also run code,
so they are just as powerful as an EXCEL/WORD MACRO. Macros (in either
platform) can be triggered by events...they have to be run by the user.
(Well, you can 'run' a macro from code within an event...but you know what I
mean).</FONT></SPAN></DIV>
<DIV><SPAN class=086051717-25042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=086051717-25042003><FONT face=Arial color=#0000ff size=2>I was
not saying that macros are as powerful as VBA. </FONT></SPAN></DIV>
<DIV><SPAN class=086051717-25042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=086051717-25042003><FONT face=Arial color=#0000ff
size=2>Drew</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> John W. Colby
[mailto:jcolby@colbyconsulting.com]<BR><B>Sent:</B> Friday, April 25, 2003
7:57 AM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> RE:
[AccessD] Macros<BR><BR></FONT></DIV>
<DIV><SPAN class=131135512-25042003><FONT face=Arial color=#0000ff size=2>Yes,
but now you are programming in VB. The argument was that Macros were
"just as powerful as VB". If you have to use VB to do something that
Macros can't accomplish, then the argument is proven
false.</FONT></SPAN></DIV>
<P><FONT size=2>John W. Colby<BR>Colby
Consulting<BR>www.ColbyConsulting.com</FONT> </P>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>Don
Elliker<BR><B>Sent:</B> Friday, April 25, 2003 8:51 AM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD]
Macros<BR><BR></FONT></DIV>
<DIV>
<DIV>
<P>Could it not be called in a function and the function called from
the macro?<BR>_d<BR></P></DIV>
<DIV></DIV><BR><BR><BR>
<DIV></DIV>
<DIV><FONT face="Geneva, Arial, Sans-serif" color=#6666ff size=2><EM>"Things
are only free to the extent that you don't pay for them." </EM></FONT></DIV>
<DIV><FONT color=#33cc66></FONT></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>>From: "Jim Dettman" <JIMDETTMAN@EARTHLINK.NET>
<DIV></DIV>>Reply-To: accessd@databaseadvisors.com
<DIV></DIV>>To: <ACCESSD@DATABASEADVISORS.COM>
<DIV></DIV>>Subject: RE: [AccessD] Macros
<DIV></DIV>>Date: Fri, 25 Apr 2003 08:23:56 -0400
<DIV></DIV>>
<DIV></DIV>>The other major distinction is that there is no way to call
an API function
<DIV></DIV>>from a macro.
<DIV></DIV>>
<DIV></DIV>>Jim Dettman
<DIV></DIV>>President,
<DIV></DIV>>Online Computer Services of WNY, Inc.
<DIV></DIV>>(315) 699-3443
<DIV></DIV>>jimdettman@earthlink.net
<DIV></DIV>>
<DIV></DIV>> > -----Original Message-----
<DIV></DIV>> > From: accessd-bounces@databaseadvisors.com
<DIV></DIV>> > [mailto:accessd-bounces@databaseadvisors.com]
<DIV></DIV>> > Sent: Friday, April 25, 2003 8:18 AM
<DIV></DIV>> > To: accessd@databaseadvisors.com
<DIV></DIV>> > Subject: RE: [AccessD] Macros
<DIV></DIV>> >
<DIV></DIV>> > >Because Access Macros are just as powerful as VBA,
since they have a
<DIV></DIV>> > RunCode command.
<DIV></DIV>> >
<DIV></DIV>> > Nope, gotta disagree there Drew. No developer worth his
salt will touch
<DIV></DIV>> > macros for development in Access for the simple reason
that errors cannot
<DIV></DIV>> > be handled. In a runtime errors will dump you to the
dos prompt.
<DIV></DIV>> > Furthermore there is no facility for getting at the
object model. Macros
<DIV></DIV>> > are an extremely simplistic "programming language" for
power users, and do
<DIV></DIV>> > not compare in any way to VB.
<DIV></DIV>> >
<DIV></DIV>> > John W. Colby
<DIV></DIV>> > Colby Consulting
<DIV></DIV>> > www.ColbyConsulting.com
<DIV><FONT face=Arial color=#0000ff size=2></FONT></DIV></DIV></BLOCKQUOTE>
<DIV>
<HR>
</DIV>
<DIV>Get your copy today at <A
href="http://www.eMailBoss.com">http://www.eMailBoss.com</A></DIV></BLOCKQUOTE></BODY></HTML>