Security is working, but....

[doran_doran]

Hi,

Open the Database so you can be on the same page. (Access 97 version)
http://www.southernselectbeer.com/database/Log On Cmplx.zip

I have a form where I have about 50 buttons (frmReports)

Some of the button needs to be password protected. So I created security Table with User ID, password and all that.

Currently, I am using the security for 2 of the button and it works fine.
Open frmReportMenu > Click on Staff Analysis
> Click on Individual Dashboard

But For each button I am having to create two extra forms so I can validate the user level and give appropriate access to the report if they happen to pass the security.

I dont want to create so many log in forms and startup forms. My next goal is to give Manager and up access to QR report Under Unit (frmReportMenu) (frmRptQRMgr).

Thanks
Moe

 

[doran_doran]

I can't believe this....

I can't believe this. I have everything working and just needed some advice and NO ONE is willing to give me that.