Open Forms

[peterbowles]

I have designed a register system where each member of staff has access to there register. But they can also see all the other member of staff's registers.

I have a a table with 5 different memebers of staff each has a user name and password.

What I want is a login window that they can enter there user name and password and it only opens the forms that they are listed on.

If any one has any examples this would be great I am no expert in writing functions

Thanks

 

[llkhoutx]

Why not use Access Secutiry?

 

[Autoeng]

Read up on Security first before running the wizard. There are several good articles around (on this board, Microsoft, ect.).

Autoeng

 

[Rich]

Pat Hartman posted a Table Maintenance db here which works very well without inbuilt Access security

 

[DJN]

Have a look at the following article on the Micrsoft Knowledge base.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q179371


Hope this helps


David