Property Dialog sheet

[[nateobot]]

Anyway to disable this in Access 2k? I can disable the alt+enter functionality but is there a way for me to lock it down completely. I do not want them to be able to open it and then look through the various autokeys and other macros.

Thanks
-nate

 

[The_Doc_Man]

The only thing that comes to mind is to use the permissions to revoke their ability to ReadDesign or whatever they are calling that permission these days.

You could also try to intercept mouse clicks and customize your toolbar so the options aren't allowed there, either.

 

[[nateobot]]

Yeah sorry all the menu bars are gone except my custom ones. Shift has been disabled. The company does not want to use workgroups. It is pretty secure except for the possibility that they can open that Property sheet.

 

[ghudson]

Please explain how they can access the property sheet. What keyboard strokes or mouse clicks are they using?

 

[[nateobot]]

In access 2k you can tab to a control in runtime. Hit ALT-Enter and bring up the property sheet for that control.

I have been trying to eliminate the ALT-Enter combo with AutoKeys but it will not allow me to use that combination so now i am very not happy.

If anyone has an idea i would be glad to explore it.

I am currently looking at the prospect of checking the keystrokes they enter and seeing if it is an ALT-Enter combo but I do not want to do that for all the forms in the DB.

 

[Alexandre]

Did you try to set the AllowSpecialKeys property of your DB to False?

 

[Rich]

Is this a new "feature" in A2k? You can only open the property sheet in design view in 97.

 

[Alexandre]

I do not believe it is 'new', even for A97 addicted lightweight luddites. It is one of a few handy database properties that you would probably like to properly set when securing your DB (not that they allow to secure your DB at all by theyselves, but they are an important asset): this one disables most shortcut keys, there is another one disabling contextual menus... The best known disables the bypass key.
I said someone in another thread that I would post a code example, so I will... soon...

 

[[nateobot]]

Did you try to set the AllowSpecialKeys property of your DB to False?

Yes all options in the startup dialog are disabled. As I cannot make an autokeys alt-tab function I guess i will have to check keystrokes in all the forms and see if the alt-tab combo is used.

If there is some DB property i am missing that disables this i would love to know. I have scanned through the MS page showing all the SetOption properties but cannot find one that matches.

 

[Alexandre]

well, I gave it a try and the AllowDesignChanges property of the form (the last one in my A2k version) does what you want.
It is probably the ReadDesign-or-whatever-they-are-calling-that-permission-these-days the Doc was talking about...

And in case you would feel tedious to go manually through all your forms, here it goes :

Function AllowDesign(bAllowed As Boolean)
Dim objFrm As AccessObject, frm As Form

For Each objFrm In CurrentProject.AllForms
    DoCmd.OpenForm FormName:=objFrm.Name, View:=acDesign
    Set frm = Forms(objFrm.Name)
    If frm.AllowDesignChanges = Not bAllowed Then
        frm.AllowDesignChanges = bAllowed
        DoCmd.RunCommand acCmdSave
    End If
    DoCmd.Close acForm, objFrm.Name
Next objFrm
End Function

 

[[nateobot]]

Friggin awesome.

Thanks a ton for finding that.