Login Form

How you manage access to various objects (forms etc) is really very much dependent on your intentions and design. For instance, where and how are you storing the operator's identity?

The checks should be done whenever attempting to access a resource. This can either be hard-coded into the resource itself (a form's Form_Open() event) or into the calling code that opens the form. An alternative to hard-coding is to dhave a system where your configuration is stored in a table.

1. Add the line "Option Explicit" after "Option Compare Database".
2. Set this as the default (From VBA Editor select Tools / Options / Editor Tab / Require Variable Declaration).
3. Compile your code (always) before posting it. This avoids confusion as we expect any posted code to be compiled unless otherwise stated.
4. You are still comparing controls against "". As far as I'm aware this is never a possible value. This is not exactly wrong. It's simply wasting time and makes the code harder to understand easily.
5. intLogonAttempt s needs to be declared in one of two ways (The way you have it won't work as there is no looping within the procedure itself. Every time it is called intLogonAttempt s will be reset to 0 before the code executes).
   1. Declare it as Private in the module OUTSIDE of any procedures (preferably before any of your code).
   2. Declare it as Static within the procedure itself. Simply replace Dim intLogonAttempt s As Integer with Static intLogonAttempt s As Integer.
   I recommend looking up Private & Static in Access Help.

I store the operator identity in a table as i mention previously...hm m...I dont really understand,can u give some example about this

"An alternative to hard-coding is to have a system where your configuration is stored in a table."

I want administrator to have the access to add,update,dele te and search form while user only have the access for the search form...do i need to insert this in the table because there are about many form...