find record & rename record

G

George

Hi,
I want to run a macro that opens a table and locates all the records that
contain "SEEK" in the table and replace SEEK with SEK - is this possible?
I can only find renames for table or query names?
Thanks
George
 
S

Steve Schapel

George,

This is a job for an Update Query. Update the field(s) in question to...
Replace([NameOfField],"SEEK","SEK")
 
G

George

Thanks Steve - much appreciated

Steve Schapel said:
George,

This is a job for an Update Query. Update the field(s) in question to...
Replace([NameOfField],"SEEK","SEK")

--
Steve Schapel, Microsoft Access MVP
Hi,
I want to run a macro that opens a table and locates all the records that
contain "SEEK" in the table and replace SEEK with SEK - is this possible?
I can only find renames for table or query names?
Thanks
George
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Consolidation Table from Different Excel Tabs with Different Format 1
Improving Macro That Keeps First Letter 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
QBF & Query Malfunction 0
Copy previous record into form field 0
Word VBA - Want to test if Full Name is NOT Present in document 0
Automation of scanned file storage based on content 0
Problem with Upload Center on Office 2010 when using encrypted area on disk 0

Top