insert into produces error in autonumber field

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top