COPY PASTING INTO ACCESS FORMS (1 Viewer)

adewale4favour

Registered User.
Local time
Today, 01:09
Joined
Aug 9, 2019
Messages
57
Hi there,

I am a Database Administrator for a Cement Production company in Nigeria and have recently needed to rebuild our Report database which was done in Access. Usually when users do an update, the date and time that is done shows, and they are not necessarily required to update all the records daily, only a few that need to be updated. One of the problems we have seen recently is that staff are copying from either Excel or even Word applications and paste into designated fields. When the data was pasted into our database, it caused some serious issues that made the database crash, and the date and time for all the fields got updated to now(), making it difficult to track when a specific event changed. This had started to affect people's confidence in our ability through no fault of our own.

What we would like to do in the updated Database Application is prevent users from copying and pasting text into the system. Perhaps by displaying a message when they press CTRL+V.

Does anyone know how this can be done?

Thanks

Michael
 
Do you mean you want to maintain the ability to edit the records manually? You just want to stop the copy and paste function?
 
Yes, I want to stop the copy-pasting option completely on the forms.
 
See if this helps
 

Users who are viewing this thread

Back
Top Bottom