Fix Duplicate Record Macro Error in MS Access

In this Microsoft Access tutorial, I will show you how to fix the "Paste isn't available now" error when using the duplicate record macro button, especially on Windows 11. We will troubleshoot the issue and correct it with a simple VBA code adjustment to introduce a necessary timing delay.

Leah from Pflugerville, Texas (a Gold Member) asks: I'm following along with your video from three years ago about creating a duplicate record button using the button wizard in Microsoft Access. However, when I try it now, I get an error saying "The command or action 'Paste' isn't available now." Did something change, or am I missing something?

Members

There is no extended cut, but here is the file download:

•  File Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Duplicate Record

Links

• Intro to VBA
• Indexing

Recommended Courses

• Table Agnostic Copy - Access Developer 48
• Copy Record with Children - Access Developer 24

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, Duplicate Record Macro Error, Paste Isn't Available Command, VBA Timing Issue Fix, Convert Macro to VBA, Windows 11 Access Bug, Macro to VBA Conversion, DoEvents VBA Function, Microsoft Access Error Solutions, Indexed Fields No Duplicates, Access Button Wizard Issue