Switchboard opens password protected FORMS

[Joe Leon]

I've searched and could not find an discussion to the following. Please
inform me. Thanks!!

I have a switchboard that automatically opens and contains three buttons.
One to open a form for data entry only. The second to open a report which I
want to password protect so that I only open it. The third button opens a
report that is password protected and depending on the password will open a
report that contains only the information of the particular employee. This
third form could have a combination of employee name with password to print
the report.

I would like to use User Level Security if possible. How can I do this?

Thanks in advance!!!..... Joe....

 

[Lynn Trapp]

Get a copy of the Security FAQ, read it several times, and follow it to the
letter. There is a link to it on the Security page of my website.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Joe Leon]

Lynn,

Thanks! I've taken a good look at the ULS and will be implementing it. I
still have a question. How do I show only the information for the person that
logs in? As I wrote in the earlier post,
" The third button opens a report that is password protected and depending
on the password will open a report that shows only the information of the
particular employee."

I don't want an employee see other employees data.
Would it help if I posted my *.mdb file somewhere so that you can look at it?
Thanks!

 

[Lynn Trapp]

Once you have ULS implemented, there is a function called CurrentUser that
will return the currently logged in user. You store this value in your
tables and, then, base your data entry forms on a query that finds only
records entered by CurrentUser.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Joe Leon]

Thanks ! I'll implement it this way.

Joe...

Once you have ULS implemented, there is a function called CurrentUser that
will return the currently logged in user. You store this value in your
tables and, then, base your data entry forms on a query that finds only
records entered by CurrentUser.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Joe Leon]

Hi Lynn... hope you see this message....

I've implemented the ULS and the =CurrentUser and it worked fine!! Now here
are additional things I'd like to do.

I would like to have one of the of the buttons of the switchboard only open
when a particular current user is logged in. This is because I need to have
only the manager of the group generate a group report.

The other thing I would like to have available is for the user to be able to
change his/her password when logged in.

Thanks for all the help it's been great !!! Joe....

 

[Lynn Trapp]

I would like to have one of the of the buttons of the switchboard only

open
when a particular current user is logged in. This is because I need to
have
only the manager of the group generate a group report.

Probably the easiest way would be to add your own command button to the
Switchboard form and add the following code to the Open event of your form

Me.Command0.Visible = CurrentUser = "ManagerUserName"

The other thing I would like to have available is for the user to be able
to
change his/her password when logged in.

As long as the users have access to the Tools menu, they can change their
logon password anytime.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Joe Leon]

Hi Lynn,

I tried the

Me.Command0.Visible = CurrentUser = "ManagerUserName"

and I'm having problems making it work.

Here is what I did:
1. Opened the switchboard in design view.
2. Opened the properties of the command button I wanted to change.
3. Under events, did the Event Procedure for On Click and inserted the
following:

Private Sub Option3_Click()
Me.Command0.Visible = CurrentUser = "Joe Leon"
End Sub

When I run and click on the command button, I get a Compile error:

Method or data member not found.

and the Me.Command0 is highlighted.

What am I doing wrong? Thanks... joe