<html><div style='background-color:'><DIV>
<P>I wonder if M$ will ever actually eliminate them, as they have threatened to do?<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: "Hale, Jim" <JIM.HALE@FLEETPRIDE.COM>
<DIV></DIV>>Reply-To: accessd@databaseadvisors.com
<DIV></DIV>>To: "'accessd@databaseadvisors.com'" <ACCESSD@DATABASEADVISORS.COM>
<DIV></DIV>>Subject: RE: [AccessD] Macro Example
<DIV></DIV>>Date: Fri, 25 Apr 2003 09:46:39 -0500
<DIV></DIV>>
<DIV></DIV>><THEN DIV < little code in VBA and toy a Access consider who many are there again,>>more than macros.>
<DIV></DIV>>
<DIV></DIV>>Not to date myself too much but I remember the days when assembler
<DIV></DIV>>programmers pooh-poohed any "high level language" programmers as weenies
<DIV></DIV>>'cause "real men" program only in assembler. This disguised game of whose is
<DIV></DIV>>longer has been going on forever. IMHO whatever tool (no pun intended) fits
<DIV></DIV>>the job is the way to go. :-)
<DIV></DIV>>
<DIV></DIV>>PS While I agree with JC's comments about macros faults, I do believe they
<DIV></DIV>>have there place in a RAD environment. I use them for quick prototyping. I
<DIV></DIV>>later go back and create real code once I am satisfied I am on the right
<DIV></DIV>>track.
<DIV></DIV>>Jim Hale
<DIV></DIV>>
<DIV></DIV>>-----Original Message-----
<DIV></DIV>>From: Henry Simpson [mailto:hsimpson88@hotmail.com]
<DIV></DIV>>Sent: Thursday, April 24, 2003 11:40 PM
<DIV></DIV>>To: accessd@databaseadvisors.com
<DIV></DIV>>Subject: RE: [AccessD] Macro Example
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>In Word, there are Document New, Open and Close event procedure hooks that
<DIV></DIV>>are not invoked by a user but by one who writes code. As far as I know, a
<DIV></DIV>>user can only avoid the code by disabling macros or placing a break in the
<DIV></DIV>>code window and ending execution, and that is only possible if the document
<DIV></DIV>>is not locked. I believe code must be written or pasted into these hooks
<DIV></DIV>>and cannot be recorded directly into them. Note also that Access 97 has the
<DIV></DIV>>
<DIV></DIV>>facility to convert Access macros to code, complete with error handler.
<DIV></DIV>>Excel and Word also have a forms/controls interface and although the
<DIV></DIV>>procedures, both functions and subroutines, are commonly called macros, this
<DIV></DIV>>
<DIV></DIV>>deprecates the reality. I have written procedures in Word and Excel that
<DIV></DIV>>have updated a database. A Word form using code with a reference to DAO or
<DIV></DIV>>ADO is as capable as any unbound Access form. Then again, there are many
<DIV></DIV>>who consider Access a toy and VBA in code little more than macros. Maybe
<DIV></DIV>>when Access becomes fully object oriented and better supports collaborative
<DIV></DIV>>development??? Access macros are unique in comparison with the rest of the
<DIV></DIV>>Office suite.
<DIV></DIV>>
<DIV></DIV>>Hen
<DIV></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] Macro Example
<DIV></DIV>> >Date: Thu, 24 Apr 2003 17:42:24 -0400
<DIV></DIV>> >
<DIV></DIV>> >If I may chime in...
<DIV></DIV>> >
<DIV></DIV>> >Macros in Excel CREATE visual basic code. A macro recorder (in the olden
<DIV></DIV>> >days) was a recording of the keystrokes and mouse clicks that the user
<DIV></DIV>> >entered. Excel still works that way, but the "macro" is no longer just the
<DIV></DIV>> >recorded keystrokes, but rather a VB program that represents the results of
<DIV></DIV>> >those mouse clicks and keystrokes. Thus a macro in Excel isn't truly a
<DIV></DIV>> >macro in the original sense, but rather a true VB program that emulates the
<DIV></DIV>> >original intent.
<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
<DIV></DIV>> >rusty.hammond@cpiqpc.com
<DIV></DIV>> >Sent: Thursday, April 24, 2003 2:31 PM
<DIV></DIV>> >To: accessd@databaseadvisors.com
<DIV></DIV>> >Subject: RE: [AccessD] Macro Example
<DIV></DIV>> >
<DIV></DIV>> >
<DIV></DIV>> >If I may chime in. I think it was SusanH that posted the definition of a
<DIV></DIV>> >macro according to pcwebopedia that stated "In a way, macros are like
<DIV></DIV>> >simple
<DIV></DIV>> >programs or batch files. Some applications support sophisticated macros
<DIV></DIV>> >that
<DIV></DIV>> >even allow you to use variables and flow control structures such as loops."
<DIV></DIV>> >I think Microsoft has taken the sophisticated macro to an extreme with Word
<DIV></DIV>> >and Excel macros, nonetheless Microsoft obviously still considers them a
<DIV></DIV>> >macro since you get to them by going to Tools/Macros.
<DIV></DIV>> >
<DIV></DIV>> >If I were writing a book about Word or Excel, I would refer to these
<DIV></DIV>> >procedures as macros. If I were writing a book about Access, I would point
<DIV></DIV>> >out the difference betweeen macros and modules. If I were writing a book
<DIV></DIV>> >about all three, I would point out the modules in Access use the same VBA
<DIV></DIV>> >as
<DIV></DIV>> >Word and Excel macros. It all depends on what application you're talking
<DIV></DIV>> >about and that particular applications' use of the technology.
<DIV></DIV>> >
<DIV></DIV>> >just my 2 cents.
<DIV></DIV>> >
<DIV></DIV>> >RustyH
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>_________________________________________________________________
<DIV></DIV>>STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
<DIV></DIV>>http://join.msn.com/?page=features/junkmail
<DIV></DIV>>
<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><br clear=all><hr>Tired of spam? Get <a href="http://g.msn.com/8HMXENUS/2734">advanced junk mail protection</a> with MSN 8.</html>