Append Query

  • Thread starter Thread starter David Whitaker
  • Start date Start date
D

David Whitaker

never done one, and having problems.
Can you append the same table
what I am wanting to do is to add a record with exisiting data to the same
table.
I created the query and ran it, but it says that it is adding 0 records.
I am using criteria from an open form and that part works, but it will not
append any records
what am I doing wrong?
 
David Whitaker said:
never done one, and having problems.
Can you append the same table
what I am wanting to do is to add a record with exisiting data to the same
table.
I created the query and ran it, but it says that it is adding 0 records.
I am using criteria from an open form and that part works, but it will not
append any records
what am I doing wrong?
Click to expand...

Well if the fields you are appending include the Primary Key it will reject the
append due to violation of the key index. Do the fields you are appending
include all required fields?

Basically as long as the new record to be created doesn't violate any rules of
the table it should work.
 
There is no primary key defined in the table, I have added all fields except
for the wildcard*.

If I dont supply a criteria it appends a record for each record, another
words if there are 10 records, it add 10 more.
There are only 5 fields that I am trying to pre-populate.
any ideals?
 
David Whitaker said:
There is no primary key defined in the table, I have added all fields except
for the wildcard*.

If I dont supply a criteria it appends a record for each record, another words
if there are 10 records, it add 10 more.
There are only 5 fields that I am trying to pre-populate.
any ideals?
Click to expand...

It would appear then that your form reference is not producing any matching
results. If you go to datasheet view in the append query with a criteria
applied do you see any rows?
 
David,
I'm going to agree with Rick here, that your form reference may well not be
pulling any data. Can you post your SQL statement?

Also, can you explain why you are trying to append rows that already exist
into the same table. One of the primary reasons for having a relational
database is to eliminate redundant data. Having duplicate rows is a
violation of the purpose for using a relational database.
 
Back
Top