Click Add and then click Close. To select the fields, double-click the required fields. Do this for all the fields except for the AutoNumber field in the Table view of the main table. From the Table Name list, select the new table that you created in step 2. Click OK. When you are prompted by the "You are about to paste row s into a new table" message, click Yes to insert the rows.
On the File menu, click Close. Click No to close the AppendQuery window. Click Tables on the left pane. Right-click the new table and then click Design View. In the Design view for the table, add an AutoNumber field with the same field name that you deleted in step 1. Add this AutoNumber field to the new table, and then save the table. Click the Create tab, and then click Query Design in the Other group. Click Add , and then click Close. On the Design tab, click Append in the Query Type group.
I the Table Name list, select the new table that you created in step 2, and then click OK. A very poor repeat of Solution 4 from 6 years ago. Please ensure you are bringing something new to the thread if you are going to post solutions to such old questions. Easy way is to..
Posted 5-May pm Member Add your solution here. OK Paste as. Treat my content as plain text, not as HTML. Existing Members Sign in to your account. This email is in use. Do you need your password? Submit your solution! When answering a question please: Read the question carefully. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar. If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem.
Insults are not welcome. Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question. Let's work to help developers, not make them feel stupid. And gave me a bottle of wine. Post a Comment. Assume that you are having some set of rows in a table, and you are deleting those rows and willing to add new rows.
In this scenario, the autonumber column of the new rows will not be restarted. They will continue from previous set of rows. If you want to reset or restart the autonumber column you can follow any one of below approach. Or alternatively, after deleting the old rows in a table we can copy and paste the table as a new table with "structure only" option. More Articles
0コメント