Greetings

I have Dell Inspiron but there is no Break key yet i need it for debugging purposes

Is the substitute for CTR+Break when debugging VBA?


Ronald

Ronald,

Is it possible that "Break" is written in Blue on one of your keys, like the Pause button? In that case, it would probably be CTRL-Function-Pause.

Hope this helps,

Dennis

Hello Denis

Thank you for the reply

I have looked at the key board, but nothing like that

It is Dell Inspiron 1545

May be Dell overlooked that key

Ronald

Ronald,

Based on a few Google image searches, it looks like Dell may have neglected to print all of the function equivalents on their black 1540 keyboards. Based on the image here, try using Ctrl-Function-Delete for Ctrl-Break in debugging.

Hope this helps,

Dennis

Hello Denis

Sorry for the late reply

tried that key combination still no luck !

Ronald

I have an XPS and have found the same thing .... No Break key. I'm sure there is some combination that works, but until I find out what it is, I use the On Screen Keyboard.

Start> All Programs> Accessories> Ease of Access> On-Screen Keyboard

Hello Niesz

Thank you so much

That works great

Ronald

Walter,

Thanks for chiming in. That would drive me straight up the wall. Especially after I found that image of a white keyboard for the same model laptop that DOES include the Break command.

Ronald,

If you want to pursue it further, I'd say contact the manufacturer and see if you can get any good news.

Good luck,

Dennis

Hello all,

I have some input here. I started with a post in the Errors & Error Handling forum (My Other Post) that has led me on quite a click trail. I then decided to see if there is anywhere obvious to post my findings as that forum isn't it.

My issue is that I use Apple Macbook dual booting into Windows 7 64 Bit, and I was not getting CTRL BREAK to work on the external PC Keybaord plugged in, via a KVM, to Windows 7-64 on the macbook to interrupt code execution.

The issue was the KVM somehow stopping the key sequence getting through.

The Apple Macbook also has no BREAK key.

When I plugged in my PC Keyboard direct as a USB device and not via the KVM, and installed the correct Keyboard Driver from Microsoft then the CTRL BREAK sequence works (after a while... I think the log uot log in and re plugging of the keyboard in the USB socket made it start working)

After much googling I found a great utlity SharpKeys that allows you to low level map the BREAK key to another key on the keyboard.

HOWEVER - I couldn't understand why the utility wasn't working until I stumbled upon some esoteric (read: monospaced courier font) Linux webpage all about keyboard scan codes that apparently the key combination CTRL and BREAK generates a unique scan code sent to the PC that, in essense, makes it look like a separate Key and not a key-but-modified-by-holding-CTRL-down.

In SharpKeys, when setting the 'To' Key, use the TypeKey option, and hold CTRL & BREAK down. It will list Unknown 0xE046, as opposed to Special Num Lock 00_45, if you don't hold the CTRL key down. The From key you need to set to a key you never use. I mapped the right hand Windows Start key, as most Macbooks also have that key, and I never use the left hand start key, let alone the right hand one. Fortunately whilst the two keys do the same thing in Windows, they are seen as different keys on the keyboard, so the left hand Windows key still works after this modification.

THEN you must write to the Registry and THEN log out and re log in, or reboot Windows for the hack to work.

Now, to break execution in Access (I'm using Access 2010 on Windows 7-64) after this kind of modification you JUST press the right windows key - no CTRL needed. Works even on the Macbook laptop keyboard as well as the USB PC keyboard I have plugged in. So I guess a similar hack done on the Dell Laptop mentioned in this thread will also get this to work.

Hope this helps some folk out there!

Timbald.