Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Cut and Past in Search window

Discussion in 'Information Technology' started by Mark J., Jul 28, 2006.

  1. Mark J.

    Mark J.
    Expand Collapse
    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
     
  2. Loading...

    Similar Threads Forum Date
    Which Cuts Deeper ? - Regret Or Remorse! General Nov 17, 2016
    Cute Video Explaining The Turban New to Sikhism Apr 30, 2016
    Cute Video Explaining Sikhi And Equality (kids) New to Sikhism Apr 9, 2016
    SALDEF Announcing An Executive Director Transition At SALDEF Sikh Organisations Mar 22, 2016
    Haircut or not. Blogs Oct 21, 2015

  3. Mark J.

    Mark J.
    Expand Collapse
    Guest

    Edit: Cut and Past in Find(CTL-F) window

    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.

    "Mark J." wrote:

    > 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
     
  4. Tom Wickerath

    Tom Wickerath
    Expand Collapse
    Guest

    RE: Edit: Cut and Past in Find(CTL-F) window

    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
    __________________________________________

    "Mark J." wrote:

    > 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.
    >
    > "Mark J." wrote:
    >
    > > 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
     
  5. Mark J.

    Mark J.
    Expand Collapse
    Guest

    RE: Edit: Cut and Past in Find(CTL-F) window

    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

    "Tom Wickerath" wrote:

    > 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
    > __________________________________________
    >
    > "Mark J." wrote:
    >
    > > 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.
    > >
    > > "Mark J." wrote:
    > >
    > > > 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
     
  6. Tom Wickerath

    Tom Wickerath
    Expand Collapse
    Guest

    RE: Edit: Cut and Past in Find(CTL-F) window

    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
    __________________________________________

    "Mark J." wrote:

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

    Mark J.
    Expand Collapse
    Guest

    RE: Edit: Cut and Past in Find(CTL-F) window

    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


    "Tom Wickerath" wrote:

    > 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
    > __________________________________________
    >
    > "Mark J." wrote:
    >
    > > 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
     
  8. Tom Wickerath

    Tom Wickerath
    Expand Collapse
    Guest

    RE: Edit: Cut and Past in Find(CTL-F) window

    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
    __________________________________________

    "Mark J." wrote:

    > 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
     

Share This Page