T
Tim
ACCESS 2000
On my switchboard I have 3 standard Command Buttons: MAIN MENU, CLOSE
SWITCHBOARD, EXIT ACCESS. The questions I have concerns the CLOSE
SWITCHBOARD button which closes the switchboard form but not ACCESS.
My database has multiple users with various levels of acces the purpose of
the button would allow top level users to close the switchboard and go into
the database itself to make modifications.
Here is what I need to accomplish:
1. When one presses the CLOSE SWITCHBOARD button it would open the database
window only for top level users, all other users would get an error message
saying: "Access Denied"
2. When I "X" the switchboard (no matter what user I am using) Access is
still open and all I have to do is press FILE and the #1 entry on the
Recently Used File list and I am back into the database window. What code do
I need to put in that would bring up the LOGON window and not the Database
Window?
On my switchboard I have 3 standard Command Buttons: MAIN MENU, CLOSE
SWITCHBOARD, EXIT ACCESS. The questions I have concerns the CLOSE
SWITCHBOARD button which closes the switchboard form but not ACCESS.
My database has multiple users with various levels of acces the purpose of
the button would allow top level users to close the switchboard and go into
the database itself to make modifications.
Here is what I need to accomplish:
1. When one presses the CLOSE SWITCHBOARD button it would open the database
window only for top level users, all other users would get an error message
saying: "Access Denied"
2. When I "X" the switchboard (no matter what user I am using) Access is
still open and all I have to do is press FILE and the #1 entry on the
Recently Used File list and I am back into the database window. What code do
I need to put in that would bring up the LOGON window and not the Database
Window?