Replacing field names

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

Guest

I need to change the names of some of my fields in a table. How do I apply
these changes to all my querries, forms, reports etc.. Do I have to go and
change each one at a time or is there a way to replace the changed names in
all the querries etc..

Thank you
 
Hi Dan,

Here are three utilities that you can use:

Find and Replace Utilities
Find & Replace: http://www.rickworld.com/products.html
Speed Ferret: http://www.moshannon.com/speedferret.html
Ucora: http://www3.bc.sympatico.ca/starthere/findandreplace/

I only have experience using SpeedFerret, which is not free, but a very good
product. It will find all occurances of field names, including VBA code. I
think, but I'm not sure, that one of the other two utilities might be free.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
 
Thank you so much Tom.

Tom Wickerath said:
Hi Dan,

Here are three utilities that you can use:

Find and Replace Utilities
Find & Replace: http://www.rickworld.com/products.html
Speed Ferret: http://www.moshannon.com/speedferret.html
Ucora: http://www3.bc.sympatico.ca/starthere/findandreplace/

I only have experience using SpeedFerret, which is not free, but a very good
product. It will find all occurances of field names, including VBA code. I
think, but I'm not sure, that one of the other two utilities might be free.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
Click to expand...
 
I haven't used the Ucora utility, but I have used Find & Replace extensively
(albeit back in my Access 2.0 days). I liked it very much. And much as I
hate to admit it, I've never been able to figure out how to get Speed Ferret
to work properly for me!

Unfortunately, Smart Access won't be carrying my articles anymore. The
magazine has been sold to Eli Journals (who bought the Element K journals
last year). My understanding is that Eli Journals intends to keep the title
going, but they plan on using it to "repurpose" material (by which I think
they mean to re-publish material published elsewhere). The April issue will
be the last one from the old regime.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Tom Wickerath said:
Hi Doug,

It looks like the Ucora utility is free to use and distribute. Have you
ever
used this utility? Also, have you used the Find & Replace utility? This
might make a good article for an upcoming issue of Smart Access: A
comparison
of Find and Replace Utilities, by Doug Steele.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
Click to expand...
 
The April issue will be the last one from the old regime.

:-( :-( :-(

Although, since I was about to renew my sub, its good to know.

--
George Nicholson

Remove 'Junk' from return address.


Douglas J. Steele said:
I haven't used the Ucora utility, but I have used Find & Replace
extensively (albeit back in my Access 2.0 days). I liked it very much. And
much as I hate to admit it, I've never been able to figure out how to get
Speed Ferret to work properly for me!

Unfortunately, Smart Access won't be carrying my articles anymore. The
magazine has been sold to Eli Journals (who bought the Element K journals
last year). My understanding is that Eli Journals intends to keep the
title going, but they plan on using it to "repurpose" material (by which I
think they mean to re-publish material published elsewhere). The April
issue will be the last one from the old regime.
Click to expand...
 
I have used the Find And Replace and it works very well.

Thanks to all of you for your help

Dan
 

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

Changing the source of a report 5
Data Source 4
Need help on Iff Statement 1
Report order 7
Too many forms? 3
Querry Criteria 3
partial cell value query by date range? 2
Help Me Fix Min Max Avg Querry 1

Back
Top