D
Doug Sanders
I have a form with a button to copy the record (Access '97)
It gives me three problems:
1- It tells me that "Some of the field names for the data you tried to paste
don't match field names on the form"
It doesn't tell me which names they are and I don't see any differences.
If I click 'Yes' to 'Paste data that names match' everything seems to be
there.
2- On exiting the form it gives me a "You copied a large amount of data onto
the clipboard." message that I always to discard. Can this be done
automatically?
3- On inspecting the table where the record was copied, everything looks
fine except there is a blank record created too. Where is it coming from?'
This is my code:
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdCopy
DoCmd.RunCommand acCmdPasteAppend
Any help would be appreciated
Doug Sanders
It gives me three problems:
1- It tells me that "Some of the field names for the data you tried to paste
don't match field names on the form"
It doesn't tell me which names they are and I don't see any differences.
If I click 'Yes' to 'Paste data that names match' everything seems to be
there.
2- On exiting the form it gives me a "You copied a large amount of data onto
the clipboard." message that I always to discard. Can this be done
automatically?
3- On inspecting the table where the record was copied, everything looks
fine except there is a blank record created too. Where is it coming from?'
This is my code:
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdCopy
DoCmd.RunCommand acCmdPasteAppend
Any help would be appreciated
Doug Sanders