Find and Replace

[Miker]

For some time I have been using Access 2000. I have
heavily used (and depend on) a feature in the app that
allows me to copy from the clipboard into the "Find What"
field in the Find and Replace Window. I have recently
updraded to Access 2002 SP2 (Office XP) and am unable to
copy from the clipboard into this field anymore. I
desperately need the ability to do this. Does SP3 provide
that change or any other update available? If not, how
can I get around it. I am not a developer but do have
enough know-how to create a query or whatever it takes to
do this. I need this!
Does anyone know why Access 2002 no longer offers this?
Was it an application development oversight or what?

Thanks

 

[John Vinson]

I am not a developer but do have
enough know-how to create a query or whatever it takes to
do this. I need this!

Find and Replace is a quick and dirty method, not really suitable for
routine use. Use an Update query instead; put

[Find this:]

on the Criteria line under the field to be searched, and (if
necessary)

[Replace with this:]

on the Update To line under the field to be updated.

 

[Guest]

-----Original Message-----

I am not a developer but do have
enough know-how to create a query or whatever it takes to
do this. I need this!

Find and Replace is a quick and dirty method, not really suitable for
routine use. Use an Update query instead; put

[Find this:]

on the Criteria line under the field to be searched, and (if
necessary)

[Replace with this:]

on the Update To line under the field to be updated.


.
Thank you John,

That worked as far as finding the contents of the field.
However, what I am trying to do is, while I have my form
open, search for the specific contents of a field and
have the search bring up the record for which I am
looking in my open form - just as if I opened the Find
and Replace window and did a search that way. I also need
to be able to copy and paste into the search field like I
used to be able to do in Access 2000 using " Find and
Replace."

Thanks