• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 833
  • Last Modified:

I would like more info on Access DoCmd.RunCommand acCmdFind

There are numerous "acCmd" functions that are available in access.
They make things easier and a lot faster then writing code.

However, where can I find the actual code for the "DoCmd.RunCommand acCmdFind"
so that I can change it some? Is there a book? Is it in access some where?

2 Solutions
Priya SudharsanCommented:
It's a system method and you cannot change it.
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
To expand a bit on what Priya wrote:

The "acCmd" functions are internal commands, written into the Access codebase. You do not have access to the code that implements those functions, and cannot change them.

Many of those commands do little more than replicate menu/ribbon commands. For example, clicking the Find button is exactly the same as issues DoCmd.RunCommand acCmdFind ... it opens the internal Find dialog, and Access takes it from there. You can't intercept that, or do anything else with it. You just tell Access to open it, and that's it.

Essentially, if you need anything other than the functionality provided by those system commands, you'll have to write it yourself. Access works with the VBA language, which allows you an enormous amount of flexibility to write your own custom routines.
BillxxxxAuthor Commented:
That's what I thought.

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

BillxxxxAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for Billxxxx's comment #a40277629

for the following reason:

I was just looking for information on some routines. And although there was no correct
answer he just confirmed what I already new. He was the first to respond.
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You accepted your own comment as the answer, when you should have accepted one or more of the Experts. I'm objecting to this closure so that you can try again.
Force-accepted to close.

Senior Admin

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now