
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 the Username is 
then passed to form '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 with type 'acDialog' so that the
code in the main form is suspended until 'fPwd' is either
hidden or closed. In this example, form 'fPwd' is hidden until
the Username and Password have been copied to the main form.

Clive Williams (C-Tek) 30Jan2007




