Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    990
    Thanks
    56
    Thanked 106 Times in 91 Posts

    Moving Access 2003 project from XP to Windows 7

    I have a moderately complex project written in Access 2003 which I am migrating from XP to Windows 7.

    I have nearly completed the process but there's at least one outstanding issue: SendKeys.

    On opening the database I get the message that "The SendKeys action requires the Microsoft Office Access Utility Add-in to be loaded".

    When I checked the MS support database I found this article: http://support.microsoft.com/kb/145773

    Now I am uncertain how to proceed: do I try and install the Add-in or do I follow the instructions in the MS article to re-write the SendKeys statements without the quotes ?

    A typical line reads:

    DoCmd.GoToControl "Field Home Address"
    SendKeys "^c", True
    If I understand the MS article, this should be changed to

    DoCmd.GoToControl "Field Home Address"
    SendKeys {^}c, True
    Am I correct ?

  2. #2
    WS Lounge VIP access-mdb's Avatar
    Join Date
    Dec 2009
    Location
    Oxfordshire, UK
    Posts
    1,729
    Thanks
    148
    Thanked 156 Times in 149 Posts
    Why not try the latter in a copy of the database, if that's possible, and see if it works?

  3. #3
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    990
    Thanks
    56
    Thanked 106 Times in 91 Posts
    Thanks for the prompt reply.

    I could do that. I would rather not "suck it and see" as my first try as there are quite a few instances of Sendkeys with different characters and I could be experimenting forever, I fear.

    Is there any definitive information on either the syntax that is needed in the SendKeys statement (if that is really the issue) or on the advice in the popup to install the Microsoft Office Access Utility Add- ?

  4. #4
    WS Lounge VIP access-mdb's Avatar
    Join Date
    Dec 2009
    Location
    Oxfordshire, UK
    Posts
    1,729
    Thanks
    148
    Thanked 156 Times in 149 Posts
    All my databases with VBA (Access 2003) work fine in Win 8.1 (my OS) but I don't use sendkeys, so I can't help there. However, I would have thought that if one works then they would all work. A quick Google (using sendkeys as the search term) found this https://msdn.microsoft.com/en-us/lib...vs.110%29.aspx example at bottom. There were plenty of other links as well.

  5. The Following User Says Thank You to access-mdb For This Useful Post:

    MartinM (2015-02-05)

  6. #5
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    990
    Thanks
    56
    Thanked 106 Times in 91 Posts
    Just the link I needed - thank you for that.

  7. #6
    WS Lounge VIP access-mdb's Avatar
    Join Date
    Dec 2009
    Location
    Oxfordshire, UK
    Posts
    1,729
    Thanks
    148
    Thanked 156 Times in 149 Posts
    You're welcome

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •