Hi,
I've been reading over and over again on the thread(s) and the FAQ so many times. However, I still having trouble to have the Disable/Re-enable Shift Key working on the FrontMenu
1) I used the Tools/StartUp way to hide the Access Window Screen by uncheck the followings:
a)Display Database Window
b)Display Status Bar
c)Allow Full Menus
d)Allow Built-in Toolbars
e)Allow Default Shortcut Menus
f)Allow Toolbar/Menu Changes
g)Use Access Special Keys
Then, I chose my own form, "frmFront" in the Display Form/Page section and choose OK.
It works perfect: Only show the form, frmFront the next time I open the database.
Here comes the tricky part:
2) I put 2 buttons on the frmFront: Disable and Re-enables
'this code disables the shift key
1dim db as dao.database
2dim prp as dao.property
3set db = currentdb
4set prp = db.createproperty ("AllowByPassKey", dbBoolean, False)
5db.properties.append prp
'this code re-enable the shift key
1dim db as dao.database
2set db = currentdb
3db.properties.delete "AllowByPassKey"
4db.properties.refresh
The two buttons either sits there doing nothing (I click the Re-Enable key, and I press the Shift F11, it doesn't work) or it comes an error on line 3.
Thanks
I've been reading over and over again on the thread(s) and the FAQ so many times. However, I still having trouble to have the Disable/Re-enable Shift Key working on the FrontMenu
1) I used the Tools/StartUp way to hide the Access Window Screen by uncheck the followings:
a)Display Database Window
b)Display Status Bar
c)Allow Full Menus
d)Allow Built-in Toolbars
e)Allow Default Shortcut Menus
f)Allow Toolbar/Menu Changes
g)Use Access Special Keys
Then, I chose my own form, "frmFront" in the Display Form/Page section and choose OK.
It works perfect: Only show the form, frmFront the next time I open the database.
Here comes the tricky part:
2) I put 2 buttons on the frmFront: Disable and Re-enables
'this code disables the shift key
1dim db as dao.database
2dim prp as dao.property
3set db = currentdb
4set prp = db.createproperty ("AllowByPassKey", dbBoolean, False)
5db.properties.append prp
'this code re-enable the shift key
1dim db as dao.database
2set db = currentdb
3db.properties.delete "AllowByPassKey"
4db.properties.refresh
The two buttons either sits there doing nothing (I click the Re-Enable key, and I press the Shift F11, it doesn't work) or it comes an error on line 3.
Thanks