<html><div style='background-color:'><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></DIV>> >
<DIV></DIV>> > -----Original Message-----
<DIV></DIV>> > From: accessd-bounces@databaseadvisors.com
<DIV></DIV>> > [mailto:accessd-bounces@databaseadvisors.com]On Behalf Of Drew Wutka
<DIV></DIV>> > Sent: Friday, April 25, 2003 2:42 AM
<DIV></DIV>> > To: 'accessd@databaseadvisors.com'
<DIV></DIV>> > Subject: RE: [AccessD] Macros
<DIV></DIV>> >
<DIV></DIV>> >
<DIV></DIV>> > Actually, that is the core of this discussion. Because Access Macros are
<DIV></DIV>> > just as powerful as VBA, since they have a RunCode command. Sure, it's
<DIV></DIV>> > moronic to write code, and run them all 'through' macros, but it
<DIV></DIV>> > definitely
<DIV></DIV>> > means that macros in Access can be more powerful then they appear. So the
<DIV></DIV>> > real difference, IMHO, is that a macro is a term used to describe a simple
<DIV></DIV>> > user automation interface, regardless of what they look like inside.
<DIV></DIV>> > Macros
<DIV></DIV>> > in general are 'simplistic' to write....for a common user. However, in
<DIV></DIV>> > Excel and Word macros can be built completely with code, never using the
<DIV></DIV>> > recorder, and since the macro IS VBA, they blend into VBA more fluidly
<DIV></DIV>> > then
<DIV></DIV>> > in Access. You still have strictly VBA capabilities in Excel and Word
<DIV></DIV>> > (events, forms, etc.) so macros in Excel/Word do not completely embody
<DIV></DIV>> > VBA.
<DIV></DIV>> > The blurry distinction is just 'crisper' in Access since the macro design
<DIV></DIV>> > window is a stepped command process, versus a recorder. Quite frankly I
<DIV></DIV>> > think they should have a macro recorder in VBA, but I think the issue with
<DIV></DIV>> > dealing with db data makes that a very daunting task.
<DIV></DIV>> >
<DIV></DIV>> > Drew
<DIV></DIV>> >
<DIV></DIV>> > -----Original Message-----
<DIV></DIV>> > From: Mwp.Reid@Queens-Belfast.AC.UK
<DIV></DIV>> > [mailto:Mwp.Reid@Queens-Belfast.AC.UK]
<DIV></DIV>> > Sent: Thursday, April 24, 2003 12:22 PM
<DIV></DIV>> > To: accessd@databaseadvisors.com
<DIV></DIV>> > Subject: [AccessD] Macros
<DIV></DIV>> >
<DIV></DIV>> >
<DIV></DIV>> > An Access Macro is not the same as a macro in Word or Excel or Powerpoint.
<DIV></DIV>> > In
<DIV></DIV>> > access its more recording an action.
<DIV></DIV>> >
<DIV></DIV>> > In WOrd and Excel and Powerpoint its writing code - VBA code. Thus its a
<DIV></DIV>> > good
<DIV></DIV>> > way to learn the model for those apps.
<DIV></DIV>> >
<DIV></DIV>> > Now how they actually work in Access, I think all they do is actuallyc
<DIV></DIV>> > arry
<DIV></DIV>> > out a menu command. They dont have the power of a Word Macro for example.
<DIV></DIV>> > Teh
<DIV></DIV>> > one I posted opens a document located in the file system. If I had wanted
<DIV></DIV>> > to
<DIV></DIV>> > I
<DIV></DIV>> > could have then applied styles etc to that doc and then the appropriate
<DIV></DIV>> > code
<DIV></DIV>> >
<DIV></DIV>> > would be created. Dont think an Access Macro will do that.
<DIV></DIV>> >
<DIV></DIV>> > Martin
<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></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></DIV>> >
<DIV></DIV>> > -----------------------------------------------------
<DIV></DIV>> > eMailBoss puts you in command of your email.
<DIV></DIV>> > Get your copy today at http://www.eMailBoss.com << File: ATT00050.txt >>
<DIV></DIV>><< winmail.dat >>
<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>Add photos to your messages with <a href="http://g.msn.com/8HMYENUS/2749">MSN 8. </a> Get 2 months FREE*.</html>