Problem with CTRL+BREAK not working for either code debugging or halting a query

Posted on 2007-08-08
Last Modified: 2012-08-14
I have a problem with CTRL+BREAK not working for either code debugging or halting a query in MS Access. I've read the posts concerning CTRL-BREAK and tried everyting (AllowBreakIntoCode, AllowSpecialKeys, scancode remapping, etc.)

Recently moved to a new Sony VGN-SZ340P notebook. Keyboard has Pause accessible via Fn + Insert and Break via Fn + Delete (When press Fn + Insert, nothing happens. When press Fn + Delete, keyboard turns on NumLock.) RegEdit shows a Scancode Map with only remapping of Left Ctrl and Caps Lock. Have tried every combination of keys but nothing works. Have tried mapping F12 to the Pause/Break scancode, doesn't work. Talked with Sony about it, they don't have a clue (said to remove battery, reset bios, etc. - useless).

Any suggestions appreciated - must go on road to clients in 3 days and need this to work!!!!!
Question by:MOinReno

    Expert Comment

    Can't you use the CTRL-C combination?
    LVL 28

    Expert Comment

    Does it work correctly with an external keyboard?

    Chris B
    LVL 58

    Accepted Solution

    On my laptop, Break is Fn+Pause. Quite logically Ctrl+Break is Fn+Ctrl+Pause. Since it's a Dell, Ctrl+Pause naturally works also. In your case, among "every combination of keys", have you tried the obvious Fn+Ctrl+Delete?

    To test this easily in Access, create a form with a button running:

    Private Sub Command0_Click()
        MsgBox "press ctrl+break"
    End Sub

    Press the button to display the prompt. If you manage a Ctrl+Break, you will see the "code interrupted" message with the [Continue], [End], [Debug], and [Help] buttons.

    Good luck!

    Author Comment

    Ctrl+C didn't do anything either. External keyboard behaves the same.

    Continued to try different sequences, finally found the solution:
         Alt + Fn + Break

    Don't know why....bad, bad, bad Sony

    Great site. Will come back to it again for future issues....

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    this article is a guided solution for most of the common server issues in server hardware tasks we are facing in our routine job works. the topics in the following article covered are, 1) dell hardware raidlevel (Perc) 2) adding HDD 3) how t…
    In this article we have discussed the manual scenarios to recover data from Windows 10 through some backup and recovery tools which are offered by it.
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now