Open Database window via Switchboard Manager

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

Guest

How do you provide the option to open the database window from the
switchboard manager. I have a switchboard form that opens first and I want
an option displayed that will allow the user to open the the database window
only if selected.
I cannot see an option within the manager that allows this from the
available list of possible commands.
As an aside I am also thinking of providing user level securiity to the
database and only want users a certain group to be able to have this window
displayed(admin. level).
Is this only possible by using VBA or can I do all or some of this from
switchboard manager.
 
1. Create a new standard module in your database.

2. Copy/paste this code into it:

Public Sub ShowDatabaseWindow()
' Show the database window
DoCmd.SelectObject acForm, "Switchboard", True
End Sub

3. Compile the code, save and close the module.
name it modShowWindow

4. Run the Switchboard Manager again.
Create a new entry with the following properties:
Text: Show Database Window
Command: Run Code
Function Name: ShowDatabaseWindow

5. Close the wizard, and then test this new entry.
This assumes you have not changed the name of the Switchboard
form. If you have, adjust the module code. Clicking on this option
will display the Database Window.

Yes you can "protect" this feature by implementing User
Level Security (ULS). You could test to see if a user is
a member of a particular group and then show or ignore
this command.

Do you have any experience with setting up ULS?
 
Thanks Jeff for your help.
No I do not have a lot of experience with ULS, I think I will make a fair
attempt at implementing it but as you know yourself, as soon as you think
you've got the hang of something there is another thing you have to learn
down the line.

Thanks again.
 
Hi Adey,

Glad you have that part working now.

For ULS, it will take a little time to properly understand how it all works.
It is not something you can just learn in an hour, trust me. When you have
it mastered though, it can be a substantial tool in your Access arsenal.

Study up on the subject before attempting by following the information
available here:
http://www.ltcomputerdesigns.com/JCReferences.html#Security

You can do it, just give yourself a little time.
Good luck with your project.
 
Thanks Jeff, Ithink I've just found out.....you were right... about it taking
more than an hour. Cheers for the link.
 
Thanks Jeff, I think I've just found out.....you were right... about it taking
more than an hour. Cheers for the link.
Click to expand...

You're welcome.
Good luck with your project.
 
Back
Top