[AccessD] VBA question

Drew Wutka DWUTKA at marlow.com
Fri Apr 25 01:21:15 CDT 2003


Actually, I think it is still a macro.  Otherwise a macro that had a RunCode
statement in access would no longer be a macro either.

Is it me or is this all getting confusing! <grin>

Drew

-----Original Message-----
From: Bryan Carbonnell [mailto:Bryan_Carbonnell at cbc.ca]
Sent: Thursday, April 24, 2003 9:51 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] VBA question


OK, so let me see if I get your points Scott,

1) A macro automates the UI, with things like dropping down the menus
visibly and such?

2) When you record a macro (in Word or Excel) as soon as you stop recording
the macro, it stops being a macro because it's VBA code that gets recorded?

Bryan Carbonnell
bryan_carbonnell at cbc.ca

>>> scott.marcus at ae.ge.com 24-Apr-03 10:40:05 AM >>>
OK. I guess what I'm getting at is that a macro is basically automation of
the
user interface. When you go beyond that, you are doing scripts or code. I
think
that in Word and Excel, it's a macro while you are recording it, but the
actions
are converted to code. It's no longer a macro at that point (even tho it is
still called a macro in Word and Excel). I could get into this deeper but
see no
reason why. What is this for exactly?

Scott

-----Original Message-----
From: Susan Harkins [mailto:harkins at iglou.com] 
Sent: Thursday, April 24, 2003 10:28 AM
To: accessd at databaseadvisors.com 
Subject: Re: [AccessD] VBA question




> I always looked at macros as "user recorded actions". The only problem
with that
> is, how do you record user actions in Access? I think Access uses the term
> "Macro" incorrectly. A "Macro" in Access should be called a "Script". Just
my
> two cents.

======I always thought of them strictly as commands, executed when needed by
the user. The recorded thing is a problem since many applications didn't
have macro recorders at first. Remember 1-2-3? You just entered commands
into the worksheet, named it, and then executed it from the keyboard -- no
events.

Susan H.

_______________________________________________
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

_______________________________________________
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