Switchboard opens password protected FORMS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,

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!
 
Thanks ! I'll implement it this way.

Joe...

Lynn Trapp said:
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
Click to expand...
 
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....
 
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.
Click to expand...

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.
Click to expand...

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
 
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
 
Back
Top