M
Max Yaffe
Dear Group,
I use a continuous view subform which contains data like:
Part Cost Calculated
123 5.00 4.00
125 2.50 2.00
920 15.00 12.00
The Part & Cost fields are editable, the Calculated is not as it is
calculated from the value of Cost. I have it locked out.
My users want to cut & paste records from one form to another. When I
highlight the first record, all three fields are copied to the
clipboard. Pasting to Excel as a test shows:
Part Cost Calculated
123 5.00 4.00
However, when I try to paste to a new record, Access chokes trying to
paste in the value of Calculated.
Is there any way to fine tune the paste so that only the Part and Cost
columns are pasted? For example, can I trap the BeforeInsert or
AfterInsert events and filter out the unwanted column? Or can I
actually modify the contents of the paste buffer?
Any ideas would be welcomed.
Thanks,
Max
I use a continuous view subform which contains data like:
Part Cost Calculated
123 5.00 4.00
125 2.50 2.00
920 15.00 12.00
The Part & Cost fields are editable, the Calculated is not as it is
calculated from the value of Cost. I have it locked out.
My users want to cut & paste records from one form to another. When I
highlight the first record, all three fields are copied to the
clipboard. Pasting to Excel as a test shows:
Part Cost Calculated
123 5.00 4.00
However, when I try to paste to a new record, Access chokes trying to
paste in the value of Calculated.
Is there any way to fine tune the paste so that only the Part and Cost
columns are pasted? For example, can I trap the BeforeInsert or
AfterInsert events and filter out the unwanted column? Or can I
actually modify the contents of the paste buffer?
Any ideas would be welcomed.
Thanks,
Max