Solved Clear Clipboard 📋 (1 Viewer)

Sarah.M

Member
Local time
Today, 13:41
Joined
Oct 28, 2021
Messages
335
Hi, Plz note, My VBA is blocked by IT for security reason.
I can use only Expression builder, Macros, Queries, Tables, Forms and Reports only.
------------------------------------------------
Can I clear Clipboard by Macro Action?
Because I have a command button on click it will duplicate the record. sometimes I got error message, so I want to put clear Clipboard Macro Action before trigger duplicate
Is that possible?

Plz help 🙏
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 05:41
Joined
Feb 28, 2001
Messages
27,001
I have an old version of Access (2010) at home - all I've got now that I'm retired. It does not appear to have any clipboard commands. I cannot address other version capabilities.
 

Mike Krailo

Well-known member
Local time
Today, 06:41
Joined
Mar 28, 2020
Messages
1,030
Can you simply use the macro action "On Error" > Next, right before the command that is causing the harmless error.
 

isladogs

MVP / VIP
Local time
Today, 10:41
Joined
Jan 14, 2017
Messages
18,186
Prevention is always better than cure
Suggest you prevent duplicate records being allowed by indexing appropriate fields in table design and setting allow duplicates = false
 

Mike Krailo

Well-known member
Local time
Today, 06:41
Joined
Mar 28, 2020
Messages
1,030
I thought that was the whole point of the button in the first place, to duplicate the record. No idea why that is necessary but...
 

Sarah.M

Member
Local time
Today, 13:41
Joined
Oct 28, 2021
Messages
335
Hi, thank you for your replying
If I use duplicate record multiple times i got this message, it is working fine but I got error sometimes
"The Clipboard isn't responding so can not paste the Clipboard's contents"

1647149388341.png
 
Last edited:

Sarah.M

Member
Local time
Today, 13:41
Joined
Oct 28, 2021
Messages
335
Prevention is always better than cure
Suggest you prevent duplicate records being allowed by indexing appropriate fields in table design and setting allow duplicates = false
Thanks for replying @isladogs
No I mean copy and past the record plz see my post #6
 

theDBguy

I’m here to help
Staff member
Local time
Today, 03:41
Joined
Oct 29, 2018
Messages
21,358
Hi, thank you for your replying
If I use duplicate record multiple times i got this message, it is working fine but I got error sometimes
"The Clipboard isn't responding so can not paste the Clipboard's contents"

View attachment 99089
If I read that macro correctly, you go to a new record, copy it, and then paste it. That means you are copying an empty record, which is probably why you're getting the error when you try to paste it.
 

Eugene-LS

Registered User.
Local time
Today, 13:41
Joined
Dec 7, 2018
Messages
481
My VBA is blocked by IT for security reason.
What is your MSO version?
Are you able to write to system reester?
For MSA 2016 - .reg file:
Code:
Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Access\Security\Trusted Locations\Location0]
"Path"="D:\\AProjects\\"
"AllowSubfolders"=dword:00000001
"Description"="My VBA Projects"
Just replase "Path"="D:\\AProjects\\" - to your locatoin ...
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 18:41
Joined
May 7, 2009
Messages
19,175
if you created the macro using the Command Button Wizard, you'll get a different macro:
2022-03-14_20-07-43.png

2022-03-14_20-08-36.png
 

Sarah.M

Member
Local time
Today, 13:41
Joined
Oct 28, 2021
Messages
335
What is your MSO version?
Are you able to write to system reester?
For MSA 2016 - .reg file:
Code:
Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Access\Security\Trusted Locations\Location0]
"Path"="D:\\AProjects\\"
"AllowSubfolders"=dword:00000001
"Description"="My VBA Projects"
Just replase "Path"="D:\\AProjects\\" - to your locatoin ...
Thanks for replying
Office Pro Plus 2016
I tried I could not, becuse my user is limited permission WinOS asked me for admin permission
 

Users who are viewing this thread

Top Bottom