[AccessD] break key

Brad Marks BradM at blackforestltd.com
Mon Mar 29 12:47:59 CDT 2010


Rocky,

It might be a conflict with W7.

I am running XP and I don't have access to any PCs with W7 to test with.

Here is a link to some info from another person.  

http://www.howtogeek.com/howto/windows-vista/add-run-as-administrator-for-autohotkey-scripts-in-windows-vista/


It could be that you are running into some W7 security issues that do not surface with XP.

You might try compiling the .ahk program into an .exe file.  To do this, simply right click on the .ahk member while viewing the list of files in the folder.  You should receive a little pop-up window that has compiling as one of the options.  This will create an .exe file in the same folder.  

Good luck with this.  I may learn some new stuff about W7 as a result of this exchange of info.

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 12:22 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] break key

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


-- 
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.





More information about the AccessD mailing list