?
Solved

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

Posted on 2013-05-23
5
Medium Priority
?
571 Views
Last Modified: 2013-05-27
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
Comment
Question by:LJG
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 75
ID: 39193117
Not that I can think of. Why is not using the Add Ins menu sufficient, just curious ?
0
 
LVL 2

Author Comment

by:LJG
ID: 39194112
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
 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 total points
ID: 39194332
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
 
LVL 75
ID: 39195124
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
 
LVL 2

Author Comment

by:LJG
ID: 39199143
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question