Solved

Trouble with rickworld\FindAndReplace9 for Access 2007

Posted on 2010-11-19
12
298 Views
Last Modified: 2012-05-10
F&R9 doesn't appear to work with Access 2007 as with 2003. It only finds strings in Macros (not in Tables or elsewhere).

Anyone had any experience with this and overcome it??
0
Comment
Question by:gliese581
  • 6
  • 4
  • 2
12 Comments
 
LVL 30

Expert Comment

by:hnasr
ID: 34175654
Try to download the latest version 9 from the website.

What is your OS?

I have it working for Access 2007 and windows 7.
0
 

Author Comment

by:gliese581
ID: 34176782
Hmm...  

That's helpful hnasr.  Thanks for your quick response.

I'll try to reinstall tonight and see what happens.  I also have windows 7.
0
 
LVL 75
ID: 34177785
This is the version you want:

http://www.rickworld.com/beta

*Do Not* let the word 'beta' scare you. It's only because there is one minor unresolved issue with Macros in A2007/10 that Rick has not been able to workaround.  I've been using F&R for 18 years, and I am currently beta testing the A2010 version.

mx
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

Author Comment

by:gliese581
ID: 34181443
Thanks DatabaseMX. I tried the beta, carefully following it's unique installation requirements. Still no go.

Could it be me? Am I the only one using FR who's having this problem?  Starting to think so.

Rick earlier suggested reinstalling Access. Tried that too.

This is terrible.  I love this product. Access is not the same without it.
0
 
LVL 75
ID: 34181482
Can you elaborate more on exactly what the problem is ?  Specific examples.  Maybe upload an ACCDB that I can test on my A2010 system ?

mx
0
 

Author Comment

by:gliese581
ID: 34182808
Hi MX.

The attached doesn't contain Macros, so it's not the best example. Still, what happes is I get the ususal search screen, and run my search. I only get a pop-up that says Search Completed, but no search results. If I log the results, the log is empty.

HOWEVER, in those mdbs with Macros, any Macros (only) containing the search string are reported.  In those cases, there are match reults in the log and in a pop-up window.Go figure!

There's something about an exception for Macros in Access 2007 on Ricksworld. Don't now remember the details. I've tried to follow that instruction to rule it out as the culprit, and Rick didn't (automatically)  link the two issues when I inquired, but it's curious.

Thanks very much for your continued intrest. [Embeded file:372116]
Database2.mdb
0
 
LVL 30

Expert Comment

by:hnasr
ID: 34182836
It is working with your database!

I replaced field name Check with Checks and back to Check.

0
 

Author Comment

by:gliese581
ID: 34183193
I didn't think it was the files 'cause it youzta work.

Will later try to revert to Access 2003 to see if problem persists. I'll keep youz posated.

More thanks, gliese
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 500 total points
ID: 35875301
Has this question been resolved?  Can we close the question ?

thx.mx
0
 

Author Closing Comment

by:gliese581
ID: 35879817
Thanks for your interest and help.  I must be doing something wrong. Never managed to make it work.
0
 
LVL 75
ID: 35880072
"Don't now remember the details."
Yes ... there is still some anomaly (also in A2010) with Macros. So, Rick did respond ?

Also, if ... you can supply a db to Rick with the issue, I'm sure he would be interested, as I would also.  Would like to get this resolved for you ...

mx
0
 

Author Comment

by:gliese581
ID: 35888426
You're the best.  Can't really get back to this right now.  Thanks mx. I'm grateful.
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Dsum Function for List Box Data 7 43
VBA Access 2016 syntax 6 38
Top 1 of each supplier 55 54
backup programme - VBA 3 22
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

813 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now