COPY PASTING INTO ACCESS FORMS

[adewale4favour]

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

 

[Uncle Gizmo]

Do you mean you want to maintain the ability to edit the records manually? You just want to stop the copy and paste function?

 

[adewale4favour]

Yes, I want to stop the copy-pasting option completely on the forms.

 

[Gasman]

See if this helps

how to capture multiple key strokes at once

anyone know a way to capture multiple key strokes when a form is open? when a form is open and the user presses a combination of keys at the same time (ie cntrl+j) i want an event to fire. (much like when you hit cntrl+alt+del in windows) microsoft access 2003

www.access-programmers.co.uk

 

[moke123]