Computer Programming web Web programming Tips



How to create MS Access Application. Continue

By Sergey Skudaev


Click Tool box icon on main tool bar. See Figure 9.

ms access Modify the form's design

Figure 9.

Tool box displays. See figure 10

ms access Tool box

Figure 10.

On tool box click button control and draw it on the form. Command Button Wizard window displays. See Figure 11

ms access draw button control on form

Figure 11.

ms access draw button control

Figure 12.



Select Find Record and click Next button. See Figure 12, 13.

ms access table Find Record

Figure 13.

Select Text radio button. Click Next button. See Figure 14.

ms access form Next button

Figure 14.

Enter button name: Find Record. Click Finish button.

Select View Form View. See Figure 15

ms access form

Figure 15.

The form displays in form view. See Figure 16

ms access View Form

Figure 16.

The Password Keeper Application is ready. Now you have to set password for its database. Close your application. Select File open. Open dialog displays

ms access design view

Figure 17.

Select a small arrow next to open button. Drop down menu displays. See Figure 17. Select Open Exclusively. To be able to set password, you have to open database exclusively. It means, nobody else can open it or connect to it at the same time.

Select Tools, Security, Set Database Password from main tool bar. See figure 18.

ms access Set Database Password

Figure 18.

Enter password two times. Click OK. See Figure 19

ms access Set Database Password

Figure 19.

Now your database password protected. Click Password form and Login window displays See figure 20.

ms access Login window

Figure 20.

Enter password and form displays. In target field enter your account url or application name. In login field enter login. In password field enter password. In Note field you can enter whatever you like, for example, secret question and answer that you entered while created your account. To save record click arrow button at the bottom of the form. Empty fields are displayed for the next record. The first record is saved. You are done.

ms access form save record

Figure 21.

To download Password Keeper MS Access application It was created with MS Access 2003 and may not work with previous versions of MS Access.

Download MS Access App Password Keeper: password.zip

Download MS Access App Password Keeper: password.mdb

If you have any question or comments please post them here

Password Keeper VB Application

My eBooks on Amazon.com

US    UK    BR    CA
US   UK   BR   CA
US    UK    BR    CA