Solved

Access VBA Find and replace within a table and field

Posted on 2006-11-09
3
373 Views
Last Modified: 2008-02-07
Hi

How do I do a find and replace within a table or a field
within that table.

eg replace "D" with "C" within tblTest
0
Comment
Question by:murbro
  • 2
3 Comments
 
LVL 65

Accepted Solution

by:
rockiroads earned 500 total points
ID: 17906521
All occurrences of the character?

e.g. run this query

update mytable
set myfield = replace(myfield,"D","C")


obviously do backups of your db/table before modifying data
0
 

Author Comment

by:murbro
ID: 17906546
Great thanks.

Yes all occurrences.

Thanks again for such a quick and concise answer

0
 
LVL 65

Expert Comment

by:rockiroads
ID: 17906583
no worries :)
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
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…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

746 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

12 Experts available now in Live!

Get 1:1 Help Now