Disable problem

[neilmcmor]

The code to disable shift keys at start up that has been posted here numeroous times is causing me problems. I am a complete novice with vba. but i cannot seem to get it to work and there seems to be a problem with the following line of code:-

db.Properties(strPropName) = varPropValue

Can anyone explain what may be going wrong. The shift key still by-passes and no password is asked for. If I do click the button on the start-up screen and enter the password I get error 3270 and the line above is highlighted.

 

[RuralGuy]

Did you copy the code *exactly* including the Error handling code? I don't have a link to the example to double check but it seems to me that error is handled in the error handler. If you get into the code module with <ALT> F11 and then go to Tools>Options>GeneralTab do you have ErrorTrapping set to Break on Unhandled Errors?

 

[neilmcmor]

It appears to work well now. Just sort of righted itself. Thanks anyway

 

[RuralGuy]

Thanks for posting back. Glad it sorted itself out.