Question Locked

question on Ms - Access

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

hi!

i have develop a simple inventory system using Ms - Access for keeping track of all staff bought, when was it bought, who use it, when was it assigned to him, .....

how can i make it easier for me to extract user information from the table and once i select one user come with all his information from the table concern?

and how can i add a log on passwords for different users who want to use it?

also how can i make it shared throughout the network and user can lod on with username n password of his own and add required data?

thanks.

2 replies

by john.a.wills

In a main form show the user information, e.g. name, office number. In a continuous subform show the stuff details, e.g. broomstick bought in May 2006. To connect the user to the stuff use the user number from the user table and the user number from the stuff table - the subform wizard will ask you for this.

This discussion is closed to new replies.