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