DUPLICATE RECORDS ON APPEND QUERY

[Patty]

I am having problems with a portion of an application.
This portion involves entering data in which one field is
Autonumber into a temporary work table. On Update, a
macro runs which appends the work table to a second
table. This step is included only because it mirrors
another type of process and the second step is needed. It
does nothing in this instance. The next step is the
second table's contents are appended to a permanent table
which tracks all transactions and assigns an autonumbered
trans no. The form then closes, the work file is then
cleared, the form repopens and data entry resumes. The
issue is that data from the initial table occasionally is
appended to the permanent table twice, of course with
separate autonumbered trans no's. Any idea why?

 

[John Vinson]

The
issue is that data from the initial table occasionally is
appended to the permanent table twice, of course with
separate autonumbered trans no's. Any idea why?

Not a clue. Care to post the code? Could someone be hitting a button
twice?

 

[Guest]

The Table you are appending to also has a AutoNumber Field,I presume.Therefor everytime you append data,a unique autonumber is generated within that table.Change the Field Type of the Table from AutoNumber to Text or Number Field


----- Patty wrote: ----

I am having problems with a portion of an application.
This portion involves entering data in which one field is
Autonumber into a temporary work table. On Update, a
macro runs which appends the work table to a second
table. This step is included only because it mirrors
another type of process and the second step is needed. It
does nothing in this instance. The next step is the
second table's contents are appended to a permanent table
which tracks all transactions and assigns an autonumbered
trans no. The form then closes, the work file is then
cleared, the form repopens and data entry resumes. The
issue is that data from the initial table occasionally is
appended to the permanent table twice, of course with
separate autonumbered trans no's. Any idea why?

 

[Patty]

If you have time, take a look at this thread. I posted
this in both forums yesterday. I would be interested to
know what you think as well. Thanks.

http://www.utteraccess.com/forums/showflat.php?
Cat=&Board=access_any_version&Number=410859&page=0&view=col
lapsed&sb=5&o=&fpart=1

 

[Patty]

I had to create a multi-field index on the final table.
Thanks, for your interest.