Re: how can i record a macro in access 2003

[Guest]

I have the whole Office XP, and I too was disappointed that Access doesn't
let you do macro recording.
However, I read in the "Access 3003 Bible" by C.N. Prague et al., about
"Using Office's Macro Recorder", page 1098ff.
Seems they want to say that one could use the macro recorder in, eg, Word to
record an Access macro. But I don't see how to do that.
Start a macro recording in Word, then switch to Access and do the clicks,
then back to the Word recorder? I tried and it recorden nothing.
Or should one somehow invoke Access from within Word, then record, or what?
Anyone know?
Thanks for any hints,
Sverk

"Ken Snell [MVP]" skrev:

 

[Douglas J. Steele]

I suspect you may have misunderstood what Cary was saying.

You cannot record an Access macro using any tool.

What may have been meant is that if you're trying to automate Word or Excel
from Access, you can record the macro in Word or Excel, and then use that as
the basis for the VBA code you use in Access. (While they're called "macros"
in the other Office products, they're really VBA, and bear no resemblence to
macros in Access)

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

 

[Guest]

OK, so it can't be done in reverse, too bad.
What I really wanted to do was to cheat by recording Access keystrokes in
order to get code to modify and use in Access VBA code, instead of figuring
it out through the Access documentation. Won't work then.
Then, what is the right place to find useful systematic lists of Access VBA
commands, keywords, methods, etc?
Sverk

"Douglas J. Steele" skrev:

 

[expert-services]

You can try our macro program, Workspace Macro Pro. You can get more
information and free trial download for Workspace Macro Pro from
http://www.tethyssolutions.com/macro-automation.htm

Many of our customers use it with Access.

Tethys Solutions, Expert Services Group
http://www.tethyssolutions.com/ask-the-expert.htm
SMART Macro & Automation Solutions