how can i record a macro in access 2003

[Tom]

I have upgraded to Access 2003 and I don't have any Record macro options. Has
this utility been removed in this version, or do i need to install and
additionaly component ??

 

[Ken Snell [MVP]]

It's never been a feature in ACCESS. You build your own macros in the macro
design view window.

 

[Sverk]

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)

 

[Sverk]

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

 

[Nottahobby]

It's been three years since this discussion, and now we have Access 2007. I
am dismayed that there still is no macro recording capability, such has I've
enjoyed for a decade in Word. This is yet another reason why Microsoft should
not even allow this product to be sold to non-certified consumers (end-users)
without a warning. Even without the new ribbon concept (yet another
timesink), I've found Access to be almost unintelligible and highly
frustrating. (And, it seems, 2007 is even a little buggy.) I do understand
the concept of relational databases, and am handy with technical concepts.
But as my sig suggests, I do not need a hobby, and should not have to "build"
macros. I just need to get some relatively simple, relatively small flat-file
databasing and reporting done, without having to deal with spreadsheets,
multiple db programs, or third-party add-ins (yet more to evaluate, buy,
learn and worry about). No product in my 25 years of PC computing has so
consistently demonstrated the difference between "user" and "end-user." My
hats off to all you qualified users. A kick in the shins to Microsoft.