Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 24th, 2010, 11:18 PM
Registered User
 
Join Date: Jun 2008
Posts: 6
Thanks: 0
Thanked 1 Time in 1 Post
Default How do I interrupt running code?

CTRL-Break is supposed to break into running code, e.g. say I have an infinite loop going in VBA.

BUT ... is there another way to get in?

My keyboard is "minimal" and doesn't have a break key. (Dell Studio 16 running Win 7). No "Pause" key so FN+Pause won't simulate a break key. The registry entry for "Scancode map" won't work because Break and Pause are 3 byte scan codes and the "Scancode map" works only for one and two byte scancodes.
 
Old November 25th, 2010, 11:07 AM
Registered User
 
Join Date: Jun 2008
Posts: 6
Thanks: 0
Thanked 1 Time in 1 Post
Default

Starting osk.exe and then holding down the CTRL and Fn keys and clicking PAUSE on the On-Screen Keyboard did the trick.
The Following User Says Thank You to dlipkie For This Useful Post:
HiTechCoach (November 25th, 2010)
 
Old November 25th, 2010, 01:36 PM
Friend of Wrox
 
Join Date: Sep 2010
Posts: 245
Thanks: 5
Thanked 24 Times in 23 Posts
Default

Thank you for posting your solution.

Using sticky keys was a great idea.
__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015

Last edited by HiTechCoach; November 25th, 2010 at 01:43 PM..
 
Old November 25th, 2010, 02:01 PM
Registered User
 
Join Date: Jun 2008
Posts: 6
Thanks: 0
Thanked 1 Time in 1 Post
Default

I just upgraded to Access 2010 on Win 7 Ultimate on a Dell Studio XPS 16 ... no Pause/Break, scrolllock etc. When I called Dell about a solution they basically said "You bought a gaming machine, not a development machine." Did not make me happy as I do a lot of personal tools on Access. I suspect there are a lot more keyboards out there lately with the same problem(s). I searched a lot and didn't find a full description of a solution. I hope this helps and gets out there.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Interrupt code Bjorn2Bjorn Access VBA 9 October 30th, 2007 02:52 AM
How to interrupt processing the LOOP in ASP.NET Dmitriy ASP.NET 2.0 Professional 2 November 29th, 2006 12:19 PM
How to interrupt processing the LOOP in ASP.NET Dmitriy General .NET 2 January 13th, 2006 08:43 AM
How to interrupt processing the LOOP in ASP.NET Dmitriy ASP.NET 1.0 and 1.1 Professional 2 December 15th, 2005 04:16 PM
How to interrupt processing the LOOP in ASP.NET Dmitriy Classic ASP Professional 0 December 13th, 2005 08:19 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.