Reference for DoCmd...

[santosm]

Hi All,
Does anybody know if a good reference for this:

Code: Select all

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

I would like to know what this command does and what the options are. I found some stuff on the web but most of it was cryptic at best.

Thanks,
Mark

[HansV]

DoMenuItem provides a way to invoke menu commands in VBA. It is a relic from early versions of Access.
Although it still works, it has been superseded by RunCommand. The equivalent of the line that you posted is

Code: Select all

RunCommand acCmdSaveRecord

See Converting DoMenuItem to RunCommand for a list of the RunCommand equivalents of some of the DoCmd.DoMenuItem instructions.

[santosm]

Hi Hans,
I am trying to find what the command is for "Add New Record". My searches have resulted in nothing....

Thanks,
Mark

[HansV]

You can use

Code: Select all

RunCommand acCmdRecordsGoToNew

This is the VBA equivalent of clicking the new record button on the ribbon or in the navigation buttons: it moves the form to a blank new record. The record won't actually be created until you enter a value in one of the bound controls, either manually or through code.