Solved

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

Posted on 2013-05-23
5
553 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
  • 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 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

773 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