AutoKeys no longer working

ghudson

Registered User.

Local time

, 22:26

Joined

Jun 8, 2002

Messages

6,194

• Mar 31, 2003

• #1

Any clues on why my AutoKeys macro is not working on my home PC [Windows 98 & Access 97]?

I have searched around and there have been others in the same situation but nobody has posted a definite fix (that I can find). Reinstalling Windows is not an option and I would prefer not to reinstall Access 97. I have imported all of the objects into a new db, decompiled, compiled, repaired and compacted the darn thing.

Thanks in advance for your help!

 

ghudson

Registered User.

Local time

, 22:26

Joined

Jun 8, 2002

Messages

6,194

• Mar 31, 2003

• #2

Is it my home computer (Windows 98) or the db's AutoKeys macro? I have attached a sample Access 97 db that has my AutoKeys macro.

After you download and open the Test_AutoKeys.mdb file...

Press any Function key [F1, F7, etc.] and notice if the normal Access function works or does my ghudson form open. The AutoKeys macro is not working if the normal Access function works for you. The macro is working on your computer if the ghudson form opens when you press any Function F? key.

Thanks in advance for your help and please post back your results with my AutoKeys macro test.

 

Attachments

• test_autokeys.zip

  47.7 KB · Views: 215

jfgambit

Kinetic Card Dealer

Local time

Today, 02:26

Joined

Jul 18, 2002

Messages

798

• Mar 31, 2003

• #3

ummmmm....I must be special...cuz it worked for me

 

R

Rich

Guest

• Mar 31, 2003

• #4

They didn't work on my machine, but then I stopped using autokeys long ago for that reason, just not reliable

 

ghudson

Registered User.

Local time

, 22:26

Joined

Jun 8, 2002

Messages

6,194

• Apr 1, 2003

• #5

Thanks to tomhendrickx for I have the fix to reset AutoKeys so that the AutoKeys macro will work on my computer.

Copy this into a public module and run it. The AutoKeys macro will now work for all of your db's. The problem is machine specific but I have no idea how I altered my computer to no longer recognize the AutoKeys macro.

Code:

Option Compare Database
Option Explicit
    
Global Const voKEY_ASSIGNMENT = "Key Assignment Macro"
    
Public Sub ResetAutokeys()
    
    Application.SetOption voKEY_ASSIGNMENT, "Autokeys"
    
End Sub

HTH

 

S

shadow9449

Registered User.

Local time

, 22:26

Joined

Mar 5, 2004

Messages

1,037

• Oct 30, 2006

• #6

ghudson said:

Thanks to tomhendrickx for I have the fix to reset AutoKeys so that the AutoKeys macro will work on my computer.

Copy this into a public module and run it. The AutoKeys macro will now work for all of your db's. The problem is machine specific but I have no idea how I altered my computer to no longer recognize the AutoKeys macro.

Code:

Option Compare Database
Option Explicit
    
Global Const voKEY_ASSIGNMENT = "Key Assignment Macro"
    
Public Sub ResetAutokeys()
    
    Application.SetOption voKEY_ASSIGNMENT, "Autokeys"
    
End Sub

HTH

Click to expand...

Thanks a lot, GHudson

The autokeys just decided to stop for no apparent reason on my laptop. I did a search on the forum and found this code bit that solved it.

I'm not surprised that Microsoft (who SHOULD be documenting their software that they sell) does not have this in the Access documentation.

Thanks again

SHADOW