mraetrudeaujr
Technical User
I am having a problem where every time I try to paste the records from the previous day (about 20) I get the 'paste error' prompt. I end up clicking the OK button until it processes through, but then because of these errors Access will put the 'appended' records in a 'Paste Errors' table. When I check this table several fields are blank (the fields in error, of course). I went back and looked at the properties of the fields for both tables, and they look exactly the same.
I know. Why don't I just delete the old table and 'import' the new table? Well, when I do this my Main form screws up it's Primary Key. It will only go to a specific record -- NOT the Last Record when you click on the 'Last Record' button. However, when I type in a new 'dummy' record, exit Access, open Access back up, and then hit the Last Record...this 'new' last record WILL show up?!! I don't know if I have multiple problems or if somebody has seen this before, but I have been trying to troubleshoot this for three hours. Any help will be greatly appreciated.
Field Name is "PRSLOG"
Data Type is "Number"
Field Size is "Long Integer"
Format is "00 0000"
Decimal Places is "0"
Input Mask is "00\ 0000"
Default Value is "0"
...and this is the same for both tables.
I know. Why don't I just delete the old table and 'import' the new table? Well, when I do this my Main form screws up it's Primary Key. It will only go to a specific record -- NOT the Last Record when you click on the 'Last Record' button. However, when I type in a new 'dummy' record, exit Access, open Access back up, and then hit the Last Record...this 'new' last record WILL show up?!! I don't know if I have multiple problems or if somebody has seen this before, but I have been trying to troubleshoot this for three hours. Any help will be greatly appreciated.
Field Name is "PRSLOG"
Data Type is "Number"
Field Size is "Long Integer"
Format is "00 0000"
Decimal Places is "0"
Input Mask is "00\ 0000"
Default Value is "0"
...and this is the same for both tables.
