Copy and Paste at Access Find and Replace

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Warren Siu - 18 May 2005 04:38 GMT

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?

Reply to this Message

Joan Wild - 18 May 2005 17:36 GMT

>I always need to use the Find and Replace to locate records in Access
>tables
[quoted text clipped - 10 lines]
> dialogue
> box?

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)

Signature

Joan Wild
Microsoft Access MVP

Reply to this Message

Warren Siu - 19 May 2005 01:42 GMT

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.

> >I always need to use the Find and Replace to locate records in Access
> >tables
[quoted text clipped - 13 lines]
> 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)

Reply to this Message

Joan Wild - 19 May 2005 13:46 GMT

>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.

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.

Signature

Joan Wild
Microsoft Access MVP

Reply to this Message