Code:
'Disable Ctrl-F4 Hot Key in Access 2010.
Select Case KeyCode
Case vbKeyF4
'MsgBox "The F2 key was Pressed"
KeyCode = 0
Case Else
'MsgBox "No match!" 'testing
End Select
burrina
Last Activity: Dec 18 '14, 11:01 PM
Joined: Jun 29 '14
Location:
-
Your Very Welcome. FYI, for 2010 it is different.
-
Here is the Code to deal with this issue.
Code:If Shift = acAltMask And KeyCode = vbKeyF4 Then 'KeyDown Procedure KeyCode = 0 'Set Form KeyPreview Property to YES End If
HTHLeave a comment:
-
Is this combo bound and do you have code using the afterupdateeven t?Leave a comment:
-
This is not my thread. However, after looking back at it, yes that is true. I would have a command button that opens another password form that asks for confirmation.
...Code:If IsNull(Forms!frmPassword!Text0) Then 'No Blank passwords allowed MsgBox "You cannot enter a blank Password. Try again." Me!Text0.SetFocus Else 'No More Than 3 Attempts Allowed If Me.LIChk >Leave a comment:
-
Easy Way! Using OnOpenEvent. Of course, you can change the Msg and Password to your liking.
HTHCode:Cancel = (InputBox("Please Enter a Password ?") <> "authorized")Leave a comment:
-
Here is SQL code for tblProducts that may help you.
HTHCode:SELECT tblProducts.ProductID, tblProducts.ProductName, Sum(tblProducts.Inventory) AS StockLevel, Nz([ReOrderLevel],0-Nz([StockLevel],0)) AS ReStockAmnt, tblProducts.ReorderLevel FROM tblProducts GROUP BY tblProducts.ProductID, tblProducts.ProductName, tblProducts.ReorderLevel;
Leave a comment:
No activity results to display
Leave a comment: