Unless I take out the required attribute from each field in my table design in the Table I am trying to copy using the code in this awesome developer Tutorial, my application errors with a 3314 Error and no record is copied at all.
I have downloaded the DB from this tutorial and looked at the CustomerT table in design mode and noted all the fields attributes in the table are set Required=No
Have I got something wrong or is there some additional code we need for fields that are set to required?
Regardss
Ron de Boer
Ronald de BoerOP
@Reply 20 months ago
Hi Richard, On further investigation required attribute isn't the problem. I have a Composite Key which incorporates 7 fields so that the application cannot create a duplicate record. None of these fields are Indexed! If I delete the Required attribute Required = Yes your copy routine creates a new record but all the fields are blank. If I delete the Composite key it creates the copy record as it should. Obviously I need to create a copied record with a change in one of those fields in the composite key to make it unique which my code did but it still doesn't work. Is there a way so I can use your awesome copy routine and keep the composite key?
Regards Ron
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Developer 48.
