Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: How to Find & Replace a Particular Phrase in Access 2003
Started 1 month, 1 week ago by lbohen
I have a database of over 10K records, each has the following phrase that I want to change from border="0" /centerstrongfont color="#990000"Free USA Shipping, Orders $50 or more!/font/strong/center/pp to border="0" / There must be a character that is preventing the finding of the phrase as the search does NOT find it and I know it is in each record. How do I find & replace...
Site: Microsoft Office (Excel, Word) forum - OfficeFrustration  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile
Forum: General Discussion  General Discussion - forum profile
Total authors: 5 authors
Total thread posts: 3 posts
Thread activity: no new posts during last week
Domain info for: officefrustration.com

Other posts in this thread:

John W. Vinson external usenet poster replied 1 month, 1 week ago
On Sun, 8 Nov 2009 14:15:01 -0800, lbohen wrote: I have a database of over 10K records, each has the following phrase that I want to change from border="0" /centerstrongfont color="#990000"Free USA Shipping, Orders $50 or more!/font/strong/center/pp to border="0" / There must be a character that is preventing the finding of the phrase as the search does NOT find it and...
Size: 1,692 bytes
Customize:  Customize "<b>Reply 1</b>: How to Find & Replace a Particular Phrase in Access 2003 :: General Discussion :: Microsoft Office (Excel, Word) forum - OfficeFrust..."

Frank H replied 1 month, 1 week ago
It appears as if you have used Find and Replace. Have you tried an update query? Make a backup of your table first!!!! In the query design view add the table containing your field. In the query menu, Query menu, change the query type to update. Add the field you want to change. As criteria enter the expression you are searching for, e.g.: Like "border="0" /centerstrongfont color="#...
Size: 1,826 bytes
Customize:  Customize "<b>Reply 2</b>: How to Find & Replace a Particular Phrase in Access 2003 :: General Discussion :: Microsoft Office (Excel, Word) forum - OfficeFrust..."

 

Top contributing authors

Name
Posts
lbohen
1
user's latest post:
How to Find & Replace a...
Published (2009-11-08 23:15:00)
I have a database of over 10K records, each has the following phrase that I want to change from border=&quot;0&quot; /centerstrongfont color=&quot;#990000&quot;Free USA Shipping, Orders $50 or more!/font/strong/center/pp to border=&quot;0&quot; / There must be a character that is preventing the finding of the phrase as the search does NOT find it and I know it is in each record. How do I find &amp; replace the...
John W. Vinson
1
user's latest post:
How to Find & Replace a...
Published (2009-11-09 00:03:00)
On Sun, 8 Nov 2009 14:15:01 -0800, lbohen wrote: I have a database of over 10K records, each has the following phrase that I want to change from border=&quot;0&quot; /centerstrongfont color=&quot;#990000&quot;Free USA Shipping, Orders $50 or more!/font/strong/center/pp to border=&quot;0&quot; / There must be a character that is preventing the finding of the phrase as the search does NOT find it and I know it is in each...
Frank H
1
user's latest post:
How to Find & Replace a...
Published (2009-11-09 01:13:00)
It appears as if you have used Find and Replace. Have you tried an update query? Make a backup of your table first!!!! In the query design view add the table containing your field. In the query menu, Query menu, change the query type to update. Add the field you want to change. As criteria enter the expression you are searching for, e.g.: Like &quot;border=&quot;0&quot; /centerstrongfont color=&quot;#990000&quot;Free USA...
Frank H external usenet poster
1
user's latest post:
How to Find & Replace a...
Published (2009-11-09 01:13:00)
It appears as if you have used Find and Replace. Have you tried an update query? Make a backup of your table first!!!! In the query design view add the table containing your field. In the query menu, Query menu, change the query type to update. Add the field you want to change. As criteria enter the expression you are searching for, e.g.: Like &quot;border=&quot;0&quot; /centerstrongfont color=&quot;#990000&quot;Free USA...
John W. Vinson external usenet...
1
user's latest post:
How to Find & Replace a...
Published (2009-11-09 00:03:00)
On Sun, 8 Nov 2009 14:15:01 -0800, lbohen wrote: I have a database of over 10K records, each has the following phrase that I want to change from border=&quot;0&quot; /centerstrongfont color=&quot;#990000&quot;Free USA Shipping, Orders $50 or more!/font/strong/center/pp to border=&quot;0&quot; / There must be a character that is preventing the finding of the phrase as the search does NOT find it and I know it is in each...

Related threads on "Microsoft Office (Excel, Word) forum - OfficeFrustration":

How do I replace #Error in access report with another...  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile Setting Up & Running Reports - forum profile How do I replace #Error in access report with another statement?
How do I replace #Error in access report with another statement?
Search and replace in ms access  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile Using Forms - forum profile Search and replace in ms access
Search and replace in ms access
Search all Access objects for a particular field  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile General Discussion - forum profile Search all Access objects for a particular field
Search all Access objects for a particular field
Database Name to replace "Microsoft Access" in...  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile New Users - forum profile Database Name to replace "Microsoft Access" in top pane
Database Name to replace "Microsoft Access" in top pane
Replace Word Doc with Access 2007 Report?  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile Setting Up & Running Reports - forum profile Replace Word Doc with Access 2007 Report?
Replace Word Doc with Access 2007 Report?
Access crashes when doing Find & Replace  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile General Discussion - forum profile Access crashes when doing Find & Replace
Access crashes when doing Find & Replace
Replace Access 2007 with 2003  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile General Discussion - forum profile Replace Access 2007 with 2003
Replace Access 2007 with 2003

Related threads on other sites:

How to Find & Replace a Particular Phrase in Access...  Discussions in microsoft.public.access - site profile microsoft.public.access - forum profile How to Find & Replace a Particular Phrase in Access 2003 in microsoft.public.access
How to Find & Replace a Particular Phrase in Access 2003 in microsoft.public.access
Interesting tripwire followers. Use one particular...  Twitter / Eriurana - site profile Eriurana - forum profile Interesting tripwire followers. Use one particular phrase and two people are following me. What happens with cannibalistic merkins? 6:22 PM Jun 30th from web
Interesting tripwire followers. Use one particular phrase and two people are following me. What happens with cannibalistic merkins? 6:22 PM Jun 30th from web
Is sampling the smorgasbord on the boat to Holland. Which...  Twitter / arnoldtrubshaw - site profile arnoldtrubshaw - forum profile Is sampling the smorgasbord on the boat to Holland. Which is the first time I've used this particular phrase... 3:13 PM Jul 31st from txt
Is sampling the smorgasbord on the boat to Holland. Which is the first time I've used this particular phrase... 3:13 PM Jul 31st from txt
Is there a particular phrase used when a musician *signs...  Twitter / Aronado - site profile Aronado - forum profile Is there a particular phrase used when a musician *signs with a big label or makes it big* ??? 02:33 AM November 04, 2008 from web Aronado
Is there a particular phrase used when a musician *signs with a big label or makes it big* ??? 02:33 AM November 04, 2008 from web Aronado
Brandon Jennings uses, you know, one particular phrase,...  Twitter / jeskeets - site profile jeskeets - forum profile Brandon Jennings uses, you know, one particular phrase, you know, 113 times in an interview — http://bit.ly/kU7z5 (via SRI) about 16 hours ago from TweetDeck
Brandon Jennings uses, you know, one particular phrase, you know, 113 times in an interview — http://bit.ly/kU7z5 (via SRI) about 16 hours ago from TweetDeck
Anyone know how to find the popularity of a particular...  Twitter / tdhurst - site profile tdhurst - forum profile Anyone know how to find the popularity of a particular phrase or search term? about 8 hours ago from Tweetie
Anyone know how to find the popularity of a particular phrase or search term? about 8 hours ago from Tweetie
How to find if a watched page contains a particular phrase  www.website-watcher.com :: Index - site profile WebSite-Watcher Support - forum profile How to find if a watched page contains a particular phrase
How to find if a watched page contains a particular phrase
Howto remove a particular phrase from a text file?  LinuxQuestions.org - where Linux users come for help - site profile Linux - Newbie - forum profile Howto remove a particular phrase from a text file?
Howto remove a particular phrase from a text file?
Http://tinyurl.com/6b6mlu 'But one particular phrase is...  Twitter / 37H3L - site profile 37H3R Infommandos - forum profile Http://tinyurl.com/6b6mlu 'But one particular phrase is so original and colourful that I have been running a small private campaign to ... 9:59 PM Apr 6th, 2008 from web
Http://tinyurl.com/6b6mlu 'But one particular phrase is so original and colourful that I have been running a small private campaign to ... 9:59 PM Apr 6th, 2008 from web
@ realrossnoble you should use dorito as an everyday...  Twitter / RobGlen - site profile RobGlen - forum profile @ realrossnoble you should use dorito as an everyday saying but don't tie it down to a particular phrase 'how the dorito are you?' 2:40 PM Dec 3rd from mobile web
@ realrossnoble you should use dorito as an everyday saying but don't tie it down to a particular phrase 'how the dorito are you?' 2:40 PM Dec 3rd from mobile web
Thread profile page for "How to Find & Replace a Particular Phrase in Access 2003" on http://www.officefrustration.com. This report page is a snippet summary view from a single thread "How to Find & Replace a Particular Phrase in Access 2003", located on the Message Board at http://www.officefrustration.com. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity