Disable Toolbar

N

NoviceIan

Hi,

After browsing the current threads it appears that I have a unique problem.
Basically I have created a specialist toolbar which all users have as their
default toolbar (not changeable) at all times.

However I also have a form that opens when the database is opened which
requires users to accept the company’s IT policy. The problem is that users
can bypass this screen using the specialist toolbar.

What I want to do is disable this toolbar on this screen alone. Is that
possible?

Ian
 
A

Arvin Meyer [MVP]

Use code similar to the following:

Sub Form_Open()
On Error Resume Next
DoCmd.ShowToolBar "Specialist", acToolbarYes
End Function

Sub Form_Close()
On Error Resume Next
DoCmd.ShowToolBar "Specialist', acToolbarNo
End Function
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top