Enabling commands for different users

[glen]

here is the db.


I want to disable three commands in right side of switchboard.

[glen]

June I m waiting for your reply.

[June7]

Be patient. You posted db only this morning. I can't review it until late tonight or tomorrow.

[June7]

You are using 'nisar khan' as criteria in the SWITCHBOARD open event but there is no such user in tblEmployees.

[glen]

Ohh sorry I changed now it to "abc" and it working.
But the problem is now if I login as "abc" or "xyz" the command3 in switchboard is not visible.
and the textbox in switchboard which I binded with "strempname" in "tblemployees" is always showing "abc".

[June7]

That's because the login form is also bound to tblEmployees (unnecessary). The code to open SWITCHBOARD uses strempname field as criteria and that value is coming from the first record of the login form. Code should refer to the unbound combobox for criteria.

DoCmd.OpenForm "SWITCHBOARD", , , "strempname='" & Me.cboemployee & "'"

However, the combobox RowSource includes the lngEmpID field as the BoundColumn so the code should be:

DoCmd.OpenForm "SWITCHBOARD", , , "lngEmpID=" & Me.cboemployee

Code in the SWITCHBOARD:
If Me!strempname = "xyz" Then Me.Command3.Visible = False

Success is in attention to details, details, details! Learn debug techniques - refer to link at bottom of my post.

[glen]

Thank you very much June brother.
Now it working fine.
But don't delete my db.
Bcoz may be I will also ask another problems in this database.

[June7]

Glad it's working now.

I keep dbs for a while but eventually discard.

[glen]

Ok no problem. If in future there was some problem I will provide it again.Thanks again

One thing I observed now in my db.
If I login as "xyz" then everything working fine. means command3 not visible.
but if I go in desighn mode of switchboard and then go again in form mode.
then it showing command3.

[June7]

Probably because the reopened switchboard no longer has filtered recordset and is reading strempname value of first record which is 'abc'.

[glen]

so any solution for this without disabling design mode?

[June7]

As designer, you will have to deal with this if you want to edit the SWITCHBOARD then continue working in the db.

Repeat the login so the SWITCHBOARD opens filtered.

Don't allow users to interact with design features - disable navigation pane, ribbon, shortcut menus, F11 key. Review this thread about customization http://forums.aspfree.com/microsoft-...at-303789.html

Disable the X close button of the SWITCHBOARD so users cannot close it.

[glen]

Ok thanks.
I want to learn about all vb codes, access forms functions, Quarries function and macro function.
do you know some tutorial for this or online classes?

[June7]

No one-stop source. Just have to Google and see what's out there.

Start with:
http://office.microsoft.com/en-us/ac...010341717.aspx
http://w3schools.com/sql/default.asp