Opening a Query as Read Only in the On Click Event
Posted on 2005-03-30
I currently have a query that I normally open from an On Click Event of a "form". I now want to modify the "On Click Event
of the " the query to open as "Read Only" such that when the query view is launched, ALL "MENU" and "Tools / Shortcut" for "COPYING", "PASTING" and "PRINTING" should be "locked or invinsible" as well.
The DB itself has been converted to MDE with all "Tools" disabled in the "StartUp" but with this command button below, the "Menu" and "tools" like, the "Copy & Paste / Print" are enabled.
I want them disabled. Any suggestion will be appreciated.
I am open to other suggestions. I have locked
Private Sub btnOpenQuery_Click()
On Error GoTo Err_btnOpenQuery_Click
Dim stDocName As String
stDocName = "qryWaterPermits"
DoCmd.OpenQuery stDocName, acNormal, acEdit