Would like to copy a record and make a new record, getting an erro

[Guest]

I have created a database with employee information, (address, D.O.B., Date
of Hire, salary rate, and other stuff like that), and I would like to have
duplicate files for one person because the employees are seasonal, and come
and go. When, I have entered a record and want to copy and paste to make a
new record to update like the Date of Hire, and the salary rate, I am getting
a "The value entered isn't appropriate for the input mask '00\'00\-00;0;
specified for this field". I need help!!

Thanks,

 

[Guest]

Tina,
It seems that you are probably copying the whole record that you want but
trying to paste that whole record into one field. That field that you are
trying to paste the record into has an input format that the paste is
violating. Make sure you select or highlight the whole new record before you
paste.

 

[Guest]

I tried that and it didn't work, it copied it over but just gave me that
error about 10 times and then went away.

Thanks,

Tina Gray

 

[Guest]

It sound like you're trying to edit directly into the table. It's best not
to do that. Create a form, you can put a command button on the form to
"Clone Record" in the code behind that button's click event you can put an
insert sql statement and insert only the fields that you will not be
changing. Leave the others blank to be filled in by the user. Then change
records to the one just inserted.