access+course+training - Access

Resolved · Low Priority · Version Standard

Wed 22 Aug 2007, 10:03 Delegate Adam said...

Adam has attended:
Excel Intermediate course
Excel Advanced course
Access Introduction course

Access

Within Access, is it possible to have have levels of access to certain tables so that you can incorporate say.... salaries with in the database, but still allow staff to use the database without being able to see the salaries.

Wed 5 Sep 2007, 10:50 Trainer David said...

RE: Access

Hi Adam

Yes this is possible. I have done this using Microsoft Access 2002. Basically every user has a log-in and password and you are able to set up which users have access to which tables.

Hope this helps
David

Access tip:

Open A Combo Box Automatically

This is helpful if users need to enter large amounts of data. There are two ways to open ComboBoxes when they get the focus by using the tab keys.

When the ComboBox gets focus:

Press Alt + Down Arrow on the keyboard

For it to happen automatically, needs a bit of coding:

1. Add a combo box and a text box control to the form
2. Set the combo box's On Got Focus property to the following event procedure:

Private Sub ComboBoxName _GotFocus()

Me!ComboBoxName.Dropdown

End Sub

3. Open your form in Form View and use the TAB key to make sure it works.

View all Access hints and tips

access+course+training - Access

Access

RE: Access

Access articles

Access tip:

Open A Combo Box Automatically