A little more FYI…
After doing a little more testing last night I did find something interesting. After installing Office 2007, then uninstalling v2007 and reinstalling v2003 SendKeys works fine.
As a test on a similar laptop, I completely uninstalled v2003 including cleaning the...
Just an FYI - I have a copy of Office 2007 (I use v2003). I uninstalled Access2003 then installed v2007. SendKeys works fine in v2007. However, now I'm having other VBA issues with projects written in v2003 that don't work with v2007. I'll work through it.
Again, thanks all...
I guess my point has progressed past "Is it good to use a SendKeys command or not". Again, this is probably really OT but why is this only happening with Win10 It works perfect with older Windows versions. Not to totally badmouth Microsoft but it looks like they are at it again...
Yes, not sure about that. A bit OT here but maybe it's some Microsoft Win10 update that's giving me this problem. There have been other updates that have screwed things up with our Dell laptops - some of them still unresolved even with Dell's help (ha-ha).
No I did not compile. But as I noted, I even get the error when there is no app, no tables, no coding, no nothing - just the Immediate Window and the SendKeys command.
Yes I even rebooted to be sure only one instance of Access was running. I tried running Access with no tables, etc. – only Immediate Windows and keyed in SendKeys “Hello”. I still received the Run-Time 70 error – Permission Denied. I tried it on two different (but similar) machines with same...
Yeah, it's got to be something with my Win10 setup. No idea how to resolve. Oh well - much appreciation you all for your intense concern and help. For now I'm going to have to move on.
Again, my thanks....
As a test I ran it on a similar Dell XPS13 laptop with Win10 -- same result. Maybe it's something with Dell XPS13's? I suspect not - still assume I have some Win10 settings wrong. I'd don't remember changing anything on either of these machines but may have.
OKAY, must be something setup goofy on my Win10 machine. When I entered:
SendKeys "Hello world" in the Intermediate Window I received the same Run-Time Error 70 - Permission Denied. Any ideas what could be set wrong on my end?
Thanks guys for your input. I received the same error when I entered SendKeys "{F11}" in the Intermediate Window. Apparently Win10 does not like SendKeys. I did do a search of this but was unable to find a resolution (probably just me). Any other ideas?
I’m having a problem with the SendKeys command.
I have an older Access 2003 routine that I have been using for years running under Win7 that does exactly what I want. However, I have moved it to one of my Win10 machines and now bombs on one small function. I have my UAC set to Never Notify...