Opening VBA Editor from a Command Button

[commandolomo]

Hey

Does anyone if it is possible / how to open the "Code" (VBA Editor) screens for modules and forms from a command button? Instead of going through Form>Design>(Code Icon), I want to be able to access the code from a command button.

Does anyone know the code to trigger the vba editor to open?

Cheers

PJL

 

[SforSoftware]

Private Sub Knop0_Click()
  DoCmd.OpenModule "Form_Form2"
End Sub

 

[KenHigg]

You can hit the code button after highlighting a form in the db window.

See the attached screenshot. Does this help?

kh

 

[commandolomo]

Cheers chaps

Bert - I will try the vb code, many thanks

kh - Thanks for this, but I have diabled all menus and command bars, and for an easy way for me view the modules, without having to re-enter the db using the shift bypass, I wanted to launch vb from a cmb button.

PJL

 

[grahamvb]

Private Sub btnTestCode_Click()
On Error GoTo btnTestCode_Click_Err
 
    DoCmd.RunCommand acCmdVisualBasicEditor
 
btnTestCode_Click_Exit:
    Exit Sub
 
btnTestCode_Click_Err:
    MsgBox "Private Sub: btnTestCode_Click" & Chr$(13) & _
    "Error number: " & Err.Number & Chr$(13) & _
    Err.Description, vbOKOnly, "frmTestCode"
    Resume btnTestCode_Click_Exit
    
End Sub