RE: Auto Numbering

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Andrea,

I owe you and apology. My description was incorrect. I had exporting and
importing to Excel on my mind. Just realized when I read your reply that I
had given you the wrong info so try the foillowing.

Create the new empty table as per my original post.

Select Queries in the database window.

Double click Create query in Design View.

Select and Add the original table in the Show tables dialog and then close
dialog box.

Select all fields and drag into the query matrix.

Click the drop down arrow beside the Query type button on the toolbar.

Select Append query.

In the dialog box, click the drop down arrow in the Table name field and
select the new empty table name and click OK.

Run the query (Red Question mark button on toolbar.)

The new table should now be populated with the data from the original table.

--
Regards,

OssieMac


"Andrea Stimson" wrote:

Thanks for your help with this.
--
Andrea Stimson
Technical Administrator


"OssieMac" wrote:

Rename the table containing the data.

Select the table and then copy. In the dialog box for new table name, enter
the original table name and check Structure only. This creates an empty table
with the same name and structure as the original.

Then import the data from the original table. When satisfied that all data
is imported correctly, you can delete the old table.

--
Regards,

OssieMac


"Andrea Stimson" wrote:

Hello,

I have almost completed my database, but I am having problems with the auto
numbering. It's a project database which is assigned a unique project number
each time a new project is added. On testing the database I added in some
test records which I subsequently deleted, I now want to add real project
using the next number available, but it skips out the numbers used for
records deleted which I want to use again. Is there any way I can re-use
these numbers???

Thanks for your help
Andrea


--
Andrea Stimson
Technical Administrator
.

Relevant Pages

  • RE: Showing data based on other values
    ... Importing and linking have two different purposes. ... data not in the local database and that you do not want in the database. ... To create an append query you start out creating a regular ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Best design for importing montlhly data
    ... Can I link excel files to the database even if the xls is a new file each ... should I run a make table query and overwrite it? ... If the data you are importing ... I have basically the same question for the excel files. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Running Update Macro disables switchboard
    ... What are the reports and query that you are deleing and importing? ... The macro begins with 'setwarnings' to 'no,' and echo turned off. ... As mentioned in my first message, I placed a final line in to close the database, as a work around. ...
    (microsoft.public.access.macros)
  • Re: SQL Delete Function
    ... >an access database, overwriting the information from the previous week. ... >spreadsheet contains duplicate entries for some lines however. ... >importing the data, a macro runs a query that displays all lines that are ...
    (microsoft.public.access.gettingstarted)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)