Cut and Past in Search window

[Guest]

In the Microsoft Access it appears that Access is the only program in the
office package that does not have cut and past in the search window. This
would be the most usefull place to have cut and past especially of
reconciling database entries in Access. Could Microsoft add that feature? It
is so frustrating when dealing with long numeric entries in the search window
and having to switch back and forth from the update e-mails to the Access
database to manually type in job ticket numbers where a simple one time cut
and past would speed up the process by 2 or 3 times.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-9e3a-90458cbdcae7&dg=microsoft.public.access

 

[Guest]

I meant to say Cut and Past in FIND window, if you have a database with
thousands of entries and all of them have 10 digits in them by far the most
effective way to find a particular entry for update would be just to copy
that number from say Outlook or another program past into the Find
window(CTL-F) and hit find, bam your done. Instead of scrolling through
thousands of entries, trying to memorize a 10 digit number, or typing it in
3-4 digits at a time and switching back and forth.

 

[Guest]

Mark,

Copy & paste, from an Outlook message to the Find dialog (Ctrl F) for a
form, works just fine for me. You might want to make sure that you do not
have any macro or code that is disabling your clipboard functionality.
Otherwise, you might need to try a repair of Office.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Tom,

Have you tried when trying to search a table? Thats where I do the searches.
Otherwize you may be right but this is a problem I have found with every
computer in our shop independed of hardware or O/S software build. We run
office 2003 and windows XP Professional don't know if you where using the
same version. Macros may have a part in it but I don't see a macro disabling
a software feature,

Mark

 

[Guest]

Hi Mark,

In my initial test, I used a form, not a table. I am using Access 2003 SP-2
with Windows 2000 Server, SP-4 to conduct my tests.

After reading your most recent reply, I composed a quick message in Outlook
Express and sent it to own e-mail address. I opened up Outlook to receive the
message--I rarely use Outlook at home. I included some text found in the
Northwind Customers table to use for searching. Here is a copy of the message:

From: Tom Wickerath
Sent: Friday, June 02, 2006 4:56 AM
To: Tom Wickerath (Home)
Subject: Test

Germany
011-4988260


I opened the Customers table in Northwind, and hit Ctrl F. I copied Germany
from the message received in Outlook and pasted it into the Find dialog. With
Look In set to "Customers : Table", I am able to find several records. I
repeated the search, by copying & pasting 011-4988260 from the message
received in Outlook to the Find table dialog. Again, not a problem. It
located this record, which includes Franchi S.p.A. as the CompanyName.

My comment about the macro is a long shot indeed. A few years ago, I was
playing around with an Autoexec macro (or was it Sendkeys?) in a heavily
hacked version of Northwind that I use for testing various things. It
included an Action to disable the ability to copy anything to the Windows
clipboard. Fast forward 4 months later, and for the life of me I couldn't
figure out for the longest time why copy and paste would not work in this
database! So, unless you've implemented such a procedure, this would not
apply to you.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Tom,

thanks for your troubleshooting effort. This may indicate a problem with the
software or a macro as you suggested. You my most definitely may be right
about the macro thing, the program does ask me to allow macros to run
whenever I open the database, I have no I dea what those macros are or what
they do. I havent ever actually executed one. I will have to investigate. I
am afraid to tweek anything because I dont know what happen untill I
understand what they do. If I make a discovery I wil let you know,

Mark

 

[Guest]

Hi Mark,

... the program does ask me to allow macros to run whenever I open
the database, I have no I dea what those macros are or what they do.

This was a *feature* ("It's a feature!") introduced with Access 2003. If you:

1.) Have antivirus software that you keep up-to-date (both engine and .dat
files) and
2.) You do not willy-nilly open database files that you might receive in an
unsolicited e-mail message

then you should be OK to set macro security to low, to avoid getting
pestered with this message every time that you open a database. Here is an
interesting perspective on this feature:

http://groups.google.com/group/micr..._frm/thread/d417a7c455f0265e/60586b5bb8d18c13

"While I do appreciate Microsoft's push towards trustworthy computing in
general, forcing this in Access users is as appropriate as forcing seatbeats
on bicycle riders in my view."

************************

I looked up the macro in question. It turns out that it was an Autokeys
macro, with the following settings:

Macro Name: ^v
Action:

The Action argument was left blank. This has the effect of intercepting a
normal Ctrl V (paste). I suppose you could have the same type of macro, but
with a macro name of ^c, to intercept Ctrl C (copy). When I imported all
objects into a new DB container, the problem appeared to be solved......until
I closed and re-opened the database. The reason is that the Autokeys macro is
run only when the DB is first opened, not after importing an Autokeys macro
from another DB.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________