Microsoft Access Duplicate Button stopped working with windows 11

Question

Duplicate Button = Command44 (Used to work with Windows 10, Not working with windows 11)

On Click = Event

Private Sub Command44_Click()

On Error GoTo Err_Command44_Click

DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70

DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70

DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70 'Paste Append

Exit_Command44_Click:

Exit Sub

Err_Command44_Click:

MsgBox Err.Description

Resume Exit_Command44_Click

End Sub

Answer 1

It seems that the Duplicate Button (Command44) in Microsoft Access is not functioning as expected after upgrading to Windows 11. This could be due to compatibility issues between Access and the new operating system. Here are a few troubleshooting steps you can try:

1. Check for Updates: Ensure that both Microsoft Access and Windows 11 are fully updated. Sometimes, updates can resolve compatibility issues.
2. Recreate the Button: Try deleting the existing Command44 button and recreating it. Sometimes, controls can become corrupted.
3. Review the Code: Make sure that the code in the Command44_Click event is still valid and hasn't been affected by the upgrade. You might want to test the individual DoCmd.DoMenuItem commands to see if any specific command is failing.
4. Run Access in Compatibility Mode: Right-click on the Access application, go to Properties, and under the Compatibility tab, try running it in compatibility mode for Windows 10.
5. Check for Add-ins: Sometimes, add-ins can interfere with functionality. Disable any add-ins and see if that resolves the issue.

If these steps do not resolve the issue, consider reaching out to Microsoft support for further assistance as they may have specific guidance for this compatibility problem.

---

References:

• Expected End Sub
• Exit Property not allowed in Function or Sub
• Exit Sub not allowed in Function or Property

Answer 2

Thanks for sharing the code. This isn’t a Windows 11 limitation. The issue comes from using legacy DoCmd.DoMenuItem with acMenuVer70 (old Access 97/2000 menu mappings), which is brittle on modern Access builds. Switch to the supported DoCmd.RunCommand equivalents (Select → Copy → Paste Append).

Updated VBA (drop‑in replacement): check the below code for updated VBA**
Updated VBA.txt

Notes:**

• If the table has AutoNumber PK, it will get a new value automatically.
• If you have natural keys/unique fields, clear or recompute them after paste to avoid duplicate key errors.
• Ensure AllowAdditions = True and that filters don’t block new records.
• Alternative (some builds): DoCmd.RunCommand acCmdDuplicateRecord.

If it still fails: Please share your Access version/build (File → Account → About Access), 32/64‑bit, and the exact error message/number.

Let us know if the issue persists after following these steps. I’ll be happy to assist further if needed. If the issue has been resolved, Kindly mark the provided solution as "Accept Answer", so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.