VBA‎ > ‎

Permission denied error message when using Sendkeys in Access



Windows 10 generates an error message if you are using the sendkeys command in an Access database, such as Senkeys "{F9}".    You get a "permission denied" message.

The solution is to use wshshell instead.   Replace your sendkeys command with this:

Dim wshshell As Variant
Set wshshell = CreateObject("WScript.Shell")
wshshell.SendKeys "{F9}"
    

Comments