The windows API call AllocConsole no longer seems to work in VBA Access 2016 on Windows 10.
It functions correctly on Windows 7 with Access 2016 and I've been googling for the past few days tring to find an answer. The code is a follows...
Private Declare Function AllocConsole Lib "kernel32" () As Long
'do other stuff
Loop While True
AllocConsole always return 0 on windows 10.
Running Access as an Administrator and enabing macros and adding trust centre setting etc have no effect.
Is there a work around to get a console window to open?