Is there a way to open the MS Access VBA code window with vba? I want a button that can open the vba window.?

Question

Thanks, I tried to use the macro before I posted, but no code populated.

The sendkey way should be doable for the user...but i'm still curious what the vba for it is. Thanks for the response

Answer 1

do 'tools' > 'macro' > 'record new macro' in an office application then open the vba editor. stop it recording, and view if it's saved the code you need. transfer the code et voila.

but obviously the most basic way would be to use the sendkeys command to send alt+f11 to open it:
SendKeys "%{F11}"

EDIT:
the vba to open it the 'proper' way will probably lie behind one of the below bits of code - probably the second one because that is what deals with calls to vb editor stuff:
application.goto
application.vbe.

application.vbe. is incomplete, it's only a starting point. you'd need to have a read through the properties that are available when you hit the '.' at the end to see which one(s) might open the editor - i don't have access installed at the oment so i can't be more precise.

Answer 2

Ms Access Vba Code

Answer 3

A convenient way to get to a code window -- which I often do -- is to create a new form and put a Command Button on it.

Then, in the Property Sheet for the Command Button, go to the Event tab and select Event Procedure for the OnClick event. Double-Click the Build icon (the three dots) at the right of the property to open the code window.

Now you can write and run whatever code you desire, and make whatever changes you need -- all without ever saving the form (unless you want to save it).

You can also open the Immediate Window (aka Debug Window) by pressing Ctrl-G.

§

Answer 4

DoCmd.RunCommand acCmdNewObjectModule

This opens a new Module with the Name "Module1" (the default name for all new VBA modules).

Alternatively:
Save A VBA Module as "NewCODE", then use :

DoCmd.OpenModule "NewCODE"

This opens the Module "NewCode" in the VBA Editor. Put some instructions about "Saving As" so the module "NewCODE" stays blank.

Or replace "NewCODE" with a specific module name if You want them to Open a specific Module.

Answer 5

Hi,
U open ur MS-Access database and press Alt-F11, VBA will open. Now u can insert a Module then Procedure and do ur work.

Answer 6

DoCmd.OpenModule "[Module Name]","[Procedure Name]"