Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.


DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70

DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70

I can't find an explanation in help, so I hope someone here knows...

I created a form and used the button wizard to create a delete button.  The code behind the button is:

    DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
    DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70

What does the "8" and "6" mean?


Jim DeGeorge

RE: DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70

Sorry to bother you all.  I searched the site again and found a thread with a similar question.

8 deletes the record
6 selects the record (so you dont see a #Deleted message)


Jim DeGeorge

RE: DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70

In the help file apparently the 8 stands for the delete command, and the 6 stands for the copy command.  What it is doing is going to the edit menu in Access and going down the list, starting at 0, to the delete command which is number 7 (the 8th command down the list).  Same with the 6, it goes to the 6th command down the list.  What it is copying I am not for sure.  But if you want to take a look at it do an index search for the DoMenuItem Method.

If I take a peek in your Windows, to fix a problem, does that make me a "Peeping Tom"? Hmmmmmmmmmm

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close