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

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
0
LJG
Asked:
LJG
  • 2
  • 2
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Not that I can think of. Why is not using the Add Ins menu sufficient, just curious ?
0
 
LJGAuthor Commented:
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. :)
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
There are a number of ways to invoke library code, the simplest of which is to set a reference in VBA (tools/References) to the Find and Replace MDE.

 Then call zFAR_StartFindAndReplace()

Jim.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
0
 
LJGAuthor Commented:
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!
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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