Access 2003: Am I looking to use a Macro or Visual Basic Editor?

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

Guest

I am basically looking to program a command to search the database (Find and replace) for specific characters such as commas and exclamations and replace them with other characters, then after it has finished that, automatically remove rows that are no longer needed.

Should I go with a macro or create something in VB editor???

I am a newbie incase you have not noticed.
Thanks!
 
On Wed, 9 Jun 2004 09:01:01 -0700, Blackie Lawless <Blackie
I am basically looking to program a command to search the database (Find and replace) for specific characters such as commas and exclamations and replace them with other characters, then after it has finished that, automatically remove rows that are no longer needed.

Should I go with a macro or create something in VB editor???

I am a newbie incase you have not noticed.
Thanks!
Click to expand...

Are you searching data in your tables? or searching your VBA code?

If the former (as I suspect), then neither a macro nor a module is
either needed or appropriate: an Update query will do it.

I don't know how you define "rows that are no longer needed" but a
Delete query would let you get rid of them.

There is a builtin Replace function in A2002 and later; for instance,
if you wished to replace all exclamation points with periods in the
field named MyText in a table, you could create an Update query on the
table, and put

Replace([MyText], "!", ".")

on the Update To line under MyText.
 
Back
Top