Results 1 to 5 of 5
  1. #1
    SLSHELL is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2017
    Posts
    3

    NumLock/CapsLock/ScrollLock turns off


    I have a windows 7 (64-bit) device running Office 2013; when I run a Access database it does not turn NumLock/CapsLock/ScrollLock off. I also have a Windows 10 w/ Access 2016 and Windows 7 (64-bit) with Access 2010 that everytime I click on a specific button in the same Access database it turns off any "lock" (num, caps and/or scroll) that is on. I have copied the entire folder where the database runs from locally to each PC yet only one of them does not turn the lock functions off. On the one that it doesn't run them off on I can see the lights blink briefly but they remain on. I am not Access database literate or under VBS but I'm hoping I can get some help from this forum as to why one PC would work fine yet others do not.

  2. #2
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,511
    Search to see if the database is using SendKeys anywhere in the DB/Form opening code or events, etc. I think there are bugs with it sometimes turning things off.

  3. #3
    SLSHELL is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2017
    Posts
    3
    I have read a lot about this but if I'm copying the entire folder that contains the database from the PC that works; I would think that would cause it to work on the PCs I copy it to. I'm not knowledgeable about databases or macros--are macros created on the PC and not copied over as part of the database files?

  4. #4
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,511
    No all that should be on the Access side but SendKeys sends out commands to so something outside of Access and you listed different versions of Microsoft OS and different versions of Office so could be an issue.

  5. #5
    SLSHELL is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2017
    Posts
    3
    I was able to find a way to log into the database with creator rights and modify the vb script to include SendKeys "{NUMLOCK}", True and SendKeys "{CAPSLOCK}", True at the points where the button was pressed that would turn off num lock and caps lock. I still don't understand why one PC doesn't do this and others do turn them off but I'm moving on since I found a workable solution

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Printing report turns me mad!
    By kubisztal in forum Access
    Replies: 2
    Last Post: 10-13-2017, 08:44 AM
  2. Printing report turns me mad!
    By XP_2600 in forum Access
    Replies: 1
    Last Post: 03-09-2017, 06:51 AM
  3. Num Lock turns off ??
    By Gina Maylone in forum Access
    Replies: 3
    Last Post: 02-08-2017, 06:02 PM
  4. Set NumLock
    By June7 in forum Programming
    Replies: 7
    Last Post: 07-05-2011, 06:05 PM
  5. Capslock
    By Fifa in forum Access
    Replies: 4
    Last Post: 03-21-2011, 11:17 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums