asked on

Looking for VBA to run Add-in (Rick Fisher Find & Replace)

Version -->: Access 2010

I'm looking for VBA code to run an Add-in.

I have Rick Fisher Find & Replace that I normally get to by
Database Tools / Add-ins / Find & Replace

I can use Send Keys in VBA (SendKeys "{F11}" & "%tif") and then call it from a button or macro

Is there a better way?

Thanks for any help.
LJG

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

Not that I can think of. Why is not using the Add Ins menu sufficient, just curious ?

LJG

ASKER

I'm from the old school -

1) Tools that you use all the time you want at your fingertips (Ctrl R)
2) Send keys are not a good solution to almost anything as u look at the future. I have a couple of things that I use them for (I've been programming in Access since version 1) but each time a version causes something not to work, I try to replace all of them.

So I'm looking for suggestions.

One other thing on Send Keys - I notice the function is not available in macros anymore (you can import it from 2003 and it works, but I can't find it 2010).

That's my story and I'm sticking to it. :)

ASKER CERTIFIED SOLUTION

Jim Dettman (EE MVE)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

Well Jim, I guess that was obvious, lol.

However - you still have to invoke that Call somehow, so not sure we've saving much from accessing the Add-Ins menu ...

mx

LJG

ASKER

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

Accepted answer: 0 points for LJG's comment #a39194112
Assisted answer: 250 points for JDettman's comment #a39194332
Assisted answer: 250 points for DatabaseMX's comment #a39195124

for the following reason:

Thanks!

Looking for VBA to run Add-in (Rick Fisher Find &amp; Replace)

Looking for VBA to run Add-in (Rick Fisher Find & Replace)