Setting a Page Invisible based on User/Group 1

[iamedwardkim]

Is there a way to set a "Page" on a form invisible based on the User that is logged on? or the group the user is a member of?

 

[scriverb]

Sure, but when you are referring to page to you really mean the page of the form or the page of a tab control? How do you navigate between your pages? Command buttons? Post back with this information and I can help you.

Bob Scriver
Want the best answers? See FAQ181-2886
Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???

 

[iamedwardkim]

The page of a tab control. Thanks~!

 

[scriverb]

In the OnOpen event procedure of the Form put code to make the page invisible. Here is an example of the VBA code to do this:
If CurrentUser() = "Bob" Then
Me![SecurityInfo].Visible = False
End If

Post back with questions.

Bob Scriver
Want the best answers? See FAQ181-2886
Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???

 

[iamedwardkim]

Thanks scriverb, works great~! Is there also a way to have a conditional statement based on group?

 

[scriverb]

Yes, there is but I won't be able to post that one until sometime on Saturday.

Bob Scriver
Want the best answers? See FAQ181-2886
Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???

 

[iamedwardkim]

Hi scriverb,

I could still use the assistance if you're still available.

 

[JeremyNYC]

You can get code to determine whether or not the user is in a specific group in the security faq. You can get that from microsoft or from my website.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Professional Development for Clients Large and Small

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[scriverb]

Sorry about the delay in responding. Here is a link that should also help:

http://securityadvisor.info/doc/08691

Post back with questions concerning this code if you have any.

Bob Scriver
Want the best answers? See FAQ181-2886
Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???