<html><div style='background-color:'><DIV>
<P>I take your point. Perhaps there is a market for a library of these functions that could be called by the infamous Power Users.<BR>_d</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: "John W. Colby" <JCOLBY@COLBYCONSULTING.COM>
<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:57:24 -0400
<DIV></DIV>>
<DIV></DIV>>Yes, but now you are programming in VB. The argument was that Macros were
<DIV></DIV>>"just as powerful as VB". If you have to use VB to do something that Macros
<DIV></DIV>>can't accomplish, then the argument is proven false.
<DIV></DIV>>John W. Colby
<DIV></DIV>>Colby Consulting
<DIV></DIV>>www.ColbyConsulting.com
<DIV></DIV>>
<DIV></DIV>> -----Original Message-----
<DIV></DIV>> From: accessd-bounces@databaseadvisors.com
<DIV></DIV>>[mailto:accessd-bounces@databaseadvisors.com]On Behalf Of Don Elliker
<DIV></DIV>> Sent: Friday, April 25, 2003 8:51 AM
<DIV></DIV>> To: accessd@databaseadvisors.com
<DIV></DIV>> Subject: RE: [AccessD] Macros
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>> Could it not be called in a function and the function called from the
<DIV></DIV>>macro?
<DIV></DIV>> _d
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>> "Things are only free to the extent that you don't pay for them."
<DIV></DIV>> >From: "Jim Dettman"
<DIV></DIV>> >Reply-To: accessd@databaseadvisors.com
<DIV></DIV>> >To:
<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
<DIV></DIV>>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
<DIV></DIV>>touch
<DIV></DIV>> > > macros for development in Access for the simple reason that errors
<DIV></DIV>>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.
<DIV></DIV>>Macros
<DIV></DIV>> > > are an extremely simplistic "programming language" for power users,
<DIV></DIV>>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></DIV>>
<DIV></DIV>>----------------------------------------------------------------------------
<DIV></DIV>>----
<DIV></DIV>>
<DIV></DIV>>Get your copy today at http://www.eMailBoss.com
<DIV></DIV>>_______________________________________________
<DIV></DIV>>AccessD mailing list
<DIV></DIV>>AccessD@databaseadvisors.com
<DIV></DIV>>http://databaseadvisors.com/mailman/listinfo/accessd
<DIV></DIV>>Website: http://www.databaseadvisors.com
<DIV></DIV></div><br clear=all><hr>Protect your PC - <a href="http://g.msn.com/8HMYENUS/2755">Click here</a> for McAfee.com VirusScan Online </html>