insert into produces error in autonumber field

M

muyBN

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?
 
J

Jason Lepack

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.
 
Top