Solved Key Events - Ctrl-Delete UnDetected

[isladogs]

Thanks for the reminder. My tired old brain remembered the change but not when it actually happened. Mostly because it had no effect on my work at the time, but later on a few differences WERE noted, mostly reference issues. By now, long ago resolved, but I was wondering if that interpretation of CTRL/DEL had become "global" by being part of the library.

Sorry but I still do not understand what you are referring to here
The built-in VBA library has been based on different versions of the VBE.dll file for as long as I can remember

In Access 2000, it is the first item in this list of references:

REFERENCES
-------------------------------------------------
Description: 'Visual Basic For Applications', Name: 'VBA', FullPath: 'C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL', Guid: {000204EF-0000-0000-C000-000000000046}, Type: '0', BuiltIn: True, IsBroken: False, Major: 4, Minor: 0
Description: 'Microsoft Access 9.0 Object Library', Name: 'Access', FullPath: 'C:\Program Files\Microsoft Office\Office\MSACC9.OLB', Guid: {4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}, Type: '0', BuiltIn: True, IsBroken: False, Major: 9, Minor: 0
Description: 'OLE Automation', Name: 'stdole', FullPath: 'C:\WINDOWS\System32\stdole2.tlb', Guid: {00020430-0000-0000-C000-000000000046}, Type: '0', BuiltIn: False, IsBroken: False, Major: 2, Minor: 0
Description: '', Name: 'utility', FullPath: 'C:\Program Files\Microsoft Office\Office\1033\utility.mda', Guid: , Type: '1', BuiltIn: False, IsBroken: False, Major: 0, Minor: 0
Description: 'Microsoft Visual Basic for Applications Extensibility 5.3', Name: 'VBIDE', FullPath: 'C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB', Guid: {0002E157-0000-0000-C000-000000000046}, Type: '0', BuiltIn: False, IsBroken: False, Major: 5, Minor: 3
-------------------------------------------------
5 references found, 0 broken.

In Access 97, it is VBE.dll v5.04.41.21 in C:\Program Files\Common Files\Microsoft Shared\VBA. Once again, built-in and shared across the whole of Office

The first version of Access with VBA was Access 95. In that version the VBA library was a .olb file at C:\WINDOWS\system32\ven2232.olb.
I haven't been able to check whether that library also applied to other Office apps such as Excel etc

 

[The_Doc_Man]

There was a time when a format change affected Access's VBA when it would NOT affect Excel's VBA because VBA had a different structure than it does now. Some time after I started with the Navy, we got to the point that if you diddled with the VBA-page edit options in Excel, those changes popped up in Access - but before that moment, they did not. In other words, I recall a time when VBA was NOT uniform across the components of Office. BlueSpruce seems to remember as well that VBA changed in some way. My freaky memory says it happened and I can offer the details of how things changed, though I'll be honest: At the time, I wasn't quite as interested in the mechanics of the situation.

Where this relates to the thread topic is that CTRL/DEL has special meaning to Office members and therefore it is POSSIBLE (and I admit, speculative) that a different layer of Access is intercepting that keystroke combo as a keyboard shortcut, which is why you don't see the event. Do you see the CTRL/ALT/DEL keyboard event or does Windows intercept it? I believe that CTRL/ALT/DEL is considered a "secure" method of obtaining control of the session's security page. (Might have incorrect nomenclature here.) I offer the speculation that something deeper in the stack is intercepting CTRL/DEL, perhaps when the app is in a state or context where that shortcut has a meaning. Because it is intercepted and acted upon, you do not get the event for CTRL/DEL.

 

[The_Doc_Man]

@BlueSpruce - actually, my question was rhetorical. I knew about the Secure Attention Sequence and knew it would be intercepted. I'm just wondering if some of the problems in this case were ALSO an intercept case. You suggest that they make it through, though there is a delay involved. Thanks for clarification.