The 'TestPassword' database illustrates one way of creating a 
Dialog Box similar to the old Access Logon Dialog.

Form 'fTestpassword' represents your main form and 'fPwd' 
represents the Access Logon Dialog. The Username is obtained
using the Environ("Username") function and this is passed to
the 'fPwd' as the 'OpenArgs' parameter.

The checking of the passwords is not included because it 
depends on how and where the passwords are kept. They could
be in a table, in the main form, or held in 'fPwd'.

Note that 'fPwd' is opened as type 'acDialog' so that the
code in the main form is suspended until 'fPwd' is either
hidden or closed.

Clive Williams (C-Tek) 29Jan2007




