insert into produces error in autonumber field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've read a lot of articles and posts that say if you have an
auto-incrementing field, just leave that field out when you're inserting a
new record into a table. The strange thing is, this idea works if I go
directly into SQL view and do a query but when I attempt to do the same with
an Insert Into statement from a Word macro, it gives me the error that that
field can't contain a null value. Ideas?
 
I've read a lot of articles and posts that say if you have an
auto-incrementing field, just leave that field out when you're inserting a
new record into a table. The strange thing is, this idea works if I go
directly into SQL view and do a query but when I attempt to do the same with
an Insert Into statement from a Word macro, it gives me the error that that
field can't contain a null value. Ideas?
Click to expand...

Post the sql that access generated for your statement and post it here
along with your table structure and we might be able to help you out.
 
Back
Top