Duplicate Record Questions (A2k (9.0.4402) SR-1)

Topic

New Reply

Duplicate Record Questions

A2k (9.0.4402) SR-1

I have a Duplicate Record button on a form that was built with the wizard and generated the following code:

DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70 ‘Paste Append

1. How do I translate the above three statements? What do the commands mean?

2. I thought RunCommand replaced DoMenuItem, why does DoMenuItem get generated?

3. How do I find out the events a duplicated record goes through?

4. How do I get rid of the following message when I Duplicate record then exit form,

Reply | Quote

Replies

You can “translate” the DoCmd.DoMenuItem commands by opening your form in form view, then looking at the Edit command on the MenuBar. The commands in code relate to the various commands in the Edit dropdown menu.

For some obscure reason, Microsoft never updated the wizards to use RunCommand! Offhand, I don’t know what the RunCommand constants are to duplicate a record, but you should be able to figure it out yourself. for example, the first DoMenuItem might correspond to Select a Record, so you would use “Runcommand accmdSelectRecord”.

Reply | Quote

I’m with Mark. I don’t understand why the wizards still write Access 95 code, especially when DoMenuItem has been marked as obsolete in the help files for the last 3 versions. Futhermore, the newer code is much easier to read and understand.

Anyhow, here are the equivalent lines in Access 97-forward code:

‘select the current record
DoCmd.RunCommand acCmdSelectRecord

‘copy the current record
DoCmd.RunCommand acCmdCopy

‘append the copy to the recordset
DoCmd.RunCommand acCmdPasteAppend

Reply | Quote