View "AllowByPassKey" property

[Number Cruncher]

I want an administrator to lock and unlock a database by enabling and
disabling the shift key via the property "AllowByPassKey". I have used the
code
db.Properties("AllowByPassKey" = False) - or
db.Properties("AllowByPassKey" = True)

It is working great.

Before the Administrator leaves the database, I want the condition of the
ByPass property to be able to be displayed on a form so that the
admininstrator can readily see the state of that property.

How would I go about retrieving the current condition of that propery and
showing it on a form?

Thanks much!

 

[Dirk Goldgar]

I want an administrator to lock and unlock a database by enabling and
disabling the shift key via the property "AllowByPassKey". I have used
the
code
db.Properties("AllowByPassKey" = False) - or
db.Properties("AllowByPassKey" = True)

It is working great.

Before the Administrator leaves the database, I want the condition of the
ByPass property to be able to be displayed on a form so that the
admininstrator can readily see the state of that property.

How would I go about retrieving the current condition of that propery and
showing it on a form?

Does it work to have a text box on the form with this controlsource:

=CurrentDb.Properties("AllowBypassKey")

?
Note: that will display #Error if the property hasn't been created, but it
sounds like that will not be the case in your situation.

--

Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)