Copy/Paste in Subform - Limiting columns

  • Thread starter Thread starter Max Yaffe
  • Start date Start date
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
 
You should never use "Copy/Paste" as part of a real applicaton. There are so
many reasons why, both technical and esthetic, that I won't bother to list
them. Find another way.
 
Please disregard this non-answer. I find Copy/Paste works quite well
if used carefully.

Does anyone else have a real answer to my question?

Thanks,
Max
 
Before you get a real answer, you need a real application.

"if used carefully" - really? how many users do that.

But for a real answer, no. you wont be able to do that. Seriously, I'm not
just trying to be a smarta*s, there is not a way to do it.
 
I agree with Klatuu: there's no real place for copy and paste in an Access
application.

What I'd recommend is creating a button on your form that gets the data from
one set of fields and writes it to the other set of
fields.
 
Back
Top