AutoKeys no longer working

[ghudson]

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]

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.

 

[jfgambit]

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

 

[Rich]

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

 

[ghudson]

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.

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

HTH

 

[shadow9449]

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.

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

HTH

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