Change right click in report

[Mehvan]

Hello Everyone

How can I change right click in report ?
when I click in report by using right click give me a list such as : ( print , close , Export Excel , Export PDF ...) , but by using Visual basic in Ms Access 2010
I mean using code , not by using Macro .

[ranman256]

there's no need to alter this.

[Mehvan]

I changed it , but by using Macro
I want to know How I will change it by using VBA

[orange]

You could research http://www.iaccessworld.com/how-to-c...ro-to-vb-code/

Is this just an academic exercise or is there an underlying need for this?

[Mehvan]

thanks Orange for your help
I know to convert Macro to VBA , but How will I call those code in VBA , I mean when change Macro to VBA , because when change it to VBA , it will change to an independence Function code , Like this below code :

Option Compare DatabaseOption Explicit


'------------------------------------------------------------
' PrintingCommands_Print
'
'------------------------------------------------------------
Function PrintingCommands_Print()
On Error GoTo PrintingCommands_Print_Err


    DoCmd.RunCommand acCmdPrint


PrintingCommands_Print_Exit:
    Exit Function


PrintingCommands_Print_Err:
    MsgBox Error$
    Resume PrintingCommands_Print_Exit


End Function


'------------------------------------------------------------
' PrintingCommands_Export_To_Excel
'
'------------------------------------------------------------
Function PrintingCommands_Export_To_Excel()
On Error GoTo PrintingCommands_Export_To_Excel_Err


    DoCmd.RunCommand acCmdExportExcel


PrintingCommands_Export_To_Excel_Exit:
    Exit Function


PrintingCommands_Export_To_Excel_Err:
    MsgBox Error$
    Resume PrintingCommands_Export_To_Excel_Exit
End Function

How I will call that code by using right click , when I click by right click in report it gives me both (Print and Export To Excel ....) ?