Rocky Smolin
rockysmolin at bchacc.com
Mon Mar 29 12:22:12 CDT 2010
I'm using W7 on the laptop now. You think that might be a problem?
R
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Monday, March 29, 2010 10:00 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] break key
Rocky,
Sorry to hear that my suggestion did not work for you.
I will try to help if you tell me what you ran into.
I didn't spell things out very well in my earlier e-mail.
Here are the steps that I would suggest.
1. Download AHK from www.autohotkey.com
2. Write a one-line AHK "Program" with this line #b::Send {CtrlBreak}
(note that the extension must be .ahk)
3. Fire up this program (you can name it whatever you like, as long as the
extension is .ahk) 4. Fire up your Access VBA program and get to the point
what you want to do the "Control + Break".
5. Hold down the Windows key and then push the "b" key
Good luck and feel free to ask any questions. I have found AHK to be a very
useful utility for a variety of purposes. Plus, the price is
right...(free).
Brad
~~~~~~~~~~
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Monday, March 29, 2010 11:27 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] break key
Brad:
Didn't work for me. :(
Now I'm thinking that I could use SendKeys to send the control break in the
code so the code would break under certain conditions. But I don't know
what the ASCII value is to send. Does anyone know what character comes off
the keyboard when you press Ctrl-Break?
I'm also thinking of a crude approach - put x=1/0 in line where I want the
break and it'll generate an error which will give me the Debug option.
Rocky
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Thursday, March 25, 2010 1:19 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] break key
About a year ago, I posted a question on another Access forum and someone
suggested that I look into AutoHotKey (AHK) to accomplish what I was trying
to do. I took their advice and dug into AHK a bit. I have found AHK to be
very useful.
AutoHotkey is a free, open-source utility for Windows.
One of the things that it can be used for is to "Send" keyboard button(s).
Here is one-line AHK "program" that sends a CtrlBreak when the Windows Key
and the "b" key are pushed.
#b::Send {CtrlBreak}
I have used AHK for many other purposes. It is easy to use. The
documentation on the internet is very good.
AHK can be downloaded at www.autohotkey.com
Brad
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert
Sent: Thursday, March 25, 2010 1:12 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] break key
It won't do you any good because it only allows you to remap the printable
characters on the keyboard: A-Z, 1-0, and the space bar. That is when
running under XP. When you start it up it tells you that 'certain features
may not be available when running on versions of Windows earlier than
Windows Vista'
Lambert
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Thursday, March 25, 2010 1:49 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] break key
That looks like it might work. Except...I just upgraded the laptop to W7
and it doesn't say that W7 is supported. You think it'll work anyway?
Rocky
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos
Sent: Thursday, March 25, 2010 9:52 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] break key
Remap the keyboard then???
Microsoft Keyboard Layout Creator 1.4
http://www.microsoft.com/downloads/details.aspx?FamilyID=8be579aa-780d-4253-
9e0a-e17e51db2223&DisplayLang=en
GK
On Thu, Mar 25, 2010 at 11:13 AM, Rocky Smolin <rockysmolin at bchacc.com>
wrote:
> Yes laptop - but I use it on the road. Having to pack and attach an
> external keyboard is not an attractive solution. :(
>
> Rocky
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos
> Sent: Thursday, March 25, 2010 8:05 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] break key
>
> That is a laptop I take it? Maybe you have to use an External USB
keyboard.
>
> GK
>
> On Thu, Mar 25, 2010 at 9:21 AM, Rocky Smolin <rockysmolin at bchacc.com>
> wrote:
>> None of them worked. :(
>>
>> Rocky
>>
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William
>> Hindman
>> Sent: Wednesday, March 24, 2010 11:57 PM
>> To: Access Developers discussion and problem solving
>> Subject: Re: [AccessD] break key
>>
>> Rocky
>>
>> ...depends on the model
>> ...on my inspiron 1501 laptop, its Fn + Pause ...some other inspiron
>> keyboards don't have that key and require Fn+F11, others Ctrl+Fn+F11
>> ...my dell user manual doesn't say a thing about it ...good luck
>>
>> William
>>
>> --------------------------------------------------
>> From: "Rocky Smolin" <rockysmolin at bchacc.com>
>> Sent: Thursday, March 25, 2010 12:34 AM
>> To: "List" <dba-tech at databaseadvisors.com>; "'Off Topic'"
>> <dba-ot at databaseadvisors.com>; "'Access Developers discussion and
>> problem solving'" <accessd at databaseadvisors.com>
>> Subject: [AccessD] break key
>>
>>> On my Dell Inspiron there's no Break key so I can't do Ctrl-Break to
>>> break into the CBF. Does anyone know if there's an equivalent to
>>> Ctrl-Break on this kind of keyboard?
>>>
>>> MTIA
>>>
>>>
>>>
>>> Rocky
>>>
>>>
>>>
>>>
>>
>>
>>
>>> --
>>> AccessD mailing list
>>> AccessD at databaseadvisors.com
>>> http://databaseadvisors.com/mailman/listinfo/accessd
>>> Website: http://www.databaseadvisors.com
>>>
>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>
>
>
> --
> Gary Kjos
> garykjos at gmail.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
Gary Kjos
garykjos at gmail.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
This message has been scanned for viruses and dangerous content by
MailScanner, and is believed to be clean.
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com