Hiding things when starting Access2000

[directred]

Can the following be done and if so how.

1. Hide the database window, user unable to view it
2. Compact/repair a database from a command button
3. How do you stop a user viewing/designing a form/query etc
4. Can you disable the right mouse click so user cannot use it
5. Basically the only the thing the user can do is use the database you designed.

Thanks in advance

 

[EndersG]

Answers:

1. Go to Tools of the Access menu item, select Startup and uncheck the Display Database Window option. Also, make sure the AllowBypassKey property is set to False so a user cannot use the Shift key to circumvent hiding the database window

2. On the OnClick event of the Command Button type this line of code:
SendKeys "%(TDR) & ~ & %(TDC)", False

3. Save your database as an MDE file.

4. Not sure. I'll leave something for the other members to resolve

 

[Rich]

Search the archives here, all the answers will be magically revealed

 

[ghudson]

This will hide ALL toolbars and menu bars...
Dim I As Integer
For I = 1 To CommandBars.Count
CommandBars(I).Enabled = False
Next I

This will unhide all toolbars and menu bars...
Dim I As Integer
For I = 1 To CommandBars.Count
CommandBars(I).Enabled = True
Next I

An added bonus is the right click option is disabled if the menu bars are disabled with the above code.

Ensure that you have a way to unhide all the toolbars and menu bars before you hide them. You could use the unhide code with a transparent command button.

HTH

 

[Newman]

To disable the right mouse click, go to Tools of the Access menu item, select Startup and uncheck the second checkbox on the left.
Newman