Tracking multiple paste events in a form - A2K

  • Thread starter Thread starter tony
  • Start date Start date
T

tony

Hi,

I am currently working on a pricing database for our purchasers who
will use it to review our suppliers cost prices and update our selling
prices based on this information.

My problem is that I need to be able to track any amends that the
purchasing team make to the data - which in it's self is not too
difficult - I use the AfterUpdate event in the text box that has been
changed. The real difficulty is when the user selects a group of data
i.e. old selling prices and pastes this into another column. The first
paste event is recorded but the rest of the changes are not.

Is there a way of detecting which changes have been made during the
paste event bearing in mind that more than one user may be using the
database at any one time? Or if there is a better way of doing things
what is it!

In essence I am trying to achieve what 'Protect and Share' does in
Excel.

Many thanks

Tony
 
You will not get this to work. Cutting and pasting in a database application
is not ususally done. There is no way for Access to respond to such an
action. You will either need to restrict the user's ability to do this or
figure out a way to determine after the fact, what the user has done.
 
You will not get this to work. Cutting and pasting in a database application
is not ususally done. There is no way for Access to respond to such an
action. You will either need to restrict the user's ability to do this or
figure out a way to determine after the fact, what the user has done.
--
Dave Hargis, Microsoft Access MVP











- Show quoted text -
Click to expand...

Yep thought that might be the case.

Thanks anyway.

Tony
 
Back
Top