ghudson's shift key

[drschlong]

Hi all,

Sorry if this sounds a bit thick but I have GHUDSONS code for disabling and enabling the Shift Key when people open a database, but I have no idea what to do with it. He says after the first lot of code to add the next lot of code to a transparent command button. Where do I create this button, would it be in an existing form or a brand new form.

If somebody could guide me through this step by step I would be most grateful.

Many thanks in advance.

Steven. C.

 

[Autoeng]

Create a command button on your form (have more than one? you could put it on all of them). Make it at least .25" x .25". Put it in a corner or somewhere that you will know where it is even after you have made it invisable. Now put the code in the On Click event of the button. Compile, save and try it out (keeping it visable for the time being). Worked? Great, back to form design and open the properties for the button. Change the properties for the command button. Set Transparent to yes and set Tab Stop to No and Display When to Screen Only. That should do it.

Good luck

Autoeng

 

[R. Hicks]

I prefer not to clutter the app with the code to do this. You can set the property remotely and not worry if the user stumbles upon you "backdoor".

Go to the location below for a utility that will do this for you.

Bypass ShiftKey Utility

HTH
RDH

 

[Autoeng]

How do you get in if you need to using this utility?

Autoeng

 

[R. Hicks]

You keep a copy of the utility on your developement machine and simply unset the property with it.

Then the question comes up ... what if you are not at your developement machine?
This utility is small enough to fit on a diskette ... so you can keep a copy with you and you can execute the process from the diskette.

HTH
RDH

 

[Autoeng]

Say you have a split db. FE's are on each user's machine. To open the db the user clicks a batch file which downloads the FE to their local drive and then starts up the db with the appropriate security workgroup. Will the utility work in this scenerio?

Autoeng

 

[R. Hicks]

I don't think so .....

I wrote this utility a few of years ago and then added the browse ablity before posting it at the location I provided. This utilty will not pass the username and password information to a secured database in it's current version. I have been saying to myself that I was going to add this ability when I can find the time ... but you know how that goes .... I never seem to find the time. But this functionality could be added to the utility.

RDH