find record & rename record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
George,

This is a job for an Update Query. Update the field(s) in question to...
Replace([NameOfField],"SEEK","SEK")
 
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...
 
Back
Top