Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 598
  • 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 Access MVP)Database ArchitectCommented:
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 Access MVP)Database ArchitectCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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