Copy and Paste at Access Find and Replace

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

Guest

I always need to use the Find and Replace to locate records in Access tables
of which are related to a Excel file. All I need to do is to copy a key word
from the Excel file and paste it to the Find What text box of the Find and
Replace. The corresponding records will come out. It work perfectly in Office
97. However, when I upgraded to Office XP, it does not allow Paste in the
Find and Replace dialogue box. I have to type in key words to locate records
which create big trouble to me.
How can I use the Copy and Paste again at the new Find and Replace dialogue
box?
 
Warren Siu said:
I always need to use the Find and Replace to locate records in Access
tables
of which are related to a Excel file. All I need to do is to copy a key
word
from the Excel file and paste it to the Find What text box of the Find and
Replace. The corresponding records will come out. It work perfectly in
Office
97. However, when I upgraded to Office XP, it does not allow Paste in the
Find and Replace dialogue box. I have to type in key words to locate
records
which create big trouble to me.
How can I use the Copy and Paste again at the new Find and Replace
dialogue
box?
Click to expand...


I'm not sure how you are doing the paste, but it works fine in Office XP for
me (I use Ctrl-C Ctrl-V)
 
I just point the cursor to the Find What and right kick the mouse to call the
shortcut menu bar to paste. However, the shortcut menu does not come out and
only a "What's This?" is shown. The Ctrl-C and Ctrl-V also do not work.
 
Warren Siu said:
I just point the cursor to the Find What and right kick the mouse to call
the
shortcut menu bar to paste. However, the shortcut menu does not come out
and
only a "What's This?" is shown. The Ctrl-C and Ctrl-V also do not work.
Click to expand...


It works for me. Open Excel and select the text you want to search - hit
Ctrl-C.
Go to Access, open the Find dialog, click in Find What and hit Ctrl-V; it
pastes it in.

I don't know what to suggest.
 
Back
Top