Access 2007 create a button using VBA code instead of macro

[DougP]

Access 2007 create a button using VBA code instead of macro
is there a way to have Access 2007 create VBA code when using the wizard to make new buttons instead of a macro for items?
I se there is a convert macros to VBA but it does nothing ?
It make a Command 27 for example but nothing in it.
I want to get the code for a Save record.
I used this for years, but I know the menus of old are not the ribbon of new.
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70


DougP
< I Built one

http://www.robots2000.com

 

[PHV]

Use DoCmd.RunCommand instead of the deprecated (since ac97) DoMenuItem.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[MajP]

Here is a great website for the runcommand

http://www.accessruncommand.com/docmd.htm

This guy put in a lot of work. The runcommand does all of your macro actions and he lists them all.