Auto Number Issue - Visitor Forum - Computer Learning Zone


	Back to Visitor Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Auto Number Issue

Rick Carraher

14 months ago

I have a file that has an ID which is auto-numbered.
When I add a record (Using cut and Paste) the record is added but the ID field is not updated.

I've tried to import the records but Access is not recognizing the first record as a header and won't add the record.
I've tried suggestions to correct that - but no success yet.

Solving either one or both of these issues will get me where I need to be.

Thank you

Rick

	Sami Shamma @Reply 14 months ago
How are you doing the cut and paste?

	Rick Carraher OP @Reply 14 months ago
Thank you for asking. I simply copy the cells from an excel file. Since the auto number is the first field in the table, I place the cursor in the 2nd field and drag across and paste the 5 fields. The table is updated correctly except the the auto number field is blank.

	Sami Shamma @Reply 13 months ago
Try to click on the border of the second field, then click past

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Visitor Forum.

Next Unseen

New Feature: Comment Live View