Assign Ctrl+P for Print Command in VBA instead of Alt+P

[accessonly11]

dears
how it could be possible to assign ctrl + p key to call print command event through vba, instead of using hotkeys.
thanks

 

[isladogs]

You can assign our own preferred shortcuts to many actions using an autokeys macro.

However in this case, there is no need as Ctrl+P is already used to open the Print dialog.
Keyboard shortcuts for Access - Microsoft Support

 

[arnelgp]

create a macro and name it Autokeys.
see this demo using Ctrl+P.
be warned that this macro overrides the default behavior of Ctrl+P (print).

 

[accessonly11]

create a macro and name it Autokeys.
see this demo using Ctrl+P.
be warned that this macro overrides the default behavior of Ctrl+P (print).

yes i want to disable default ctrl+p behaviour. and assign it to a command button

 

[CJ_London]

here is some code that can easily be adapted to specifically disable ctrl-p

Disabling Ctrl key and Alt Key in access visual basic

how will I disable the Ctrl Key in my Access? in order not to perform Ctrl + S, etc... hoping for someone could help me in my Project. thanks...

stackoverflow.com

as to assigning 'print' to a command button, depends on what you want to print and how, but to open the print dialog box use

DoCmd.RunCommand acCmdPrint

 

[accessonly11]

You can assign our own preferred shortcuts to many actions using an autokeys macro.

However in this case, there is no need as Ctrl+P is already used to open the Print dialog.
Keyboard shortcuts for Access - Microsoft Support

I am unable to assign "call button click event" action using an autokeys macro. To assign an action to ctrl+p keys combination, i am using this code

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
Select Case KeyCode
Case vbKeyRight
Call cmdNext_Click
Case vbKeyLeft
Call cmdPrevious_Click
Case Shift = acCtrlMask And vbKeyP
Call cmdInvoice_Click
Case Else
End Select
End Sub

but when ever i press keys combinations for second time it open default print dialog box, how to disable this permanently.