Append Query & required fields

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

Guest

I want to append records to a table with "required" fields. But it sez
validation error. If i make the fiels not required all is ok. is there any
way round this ?
Any suggestions very welcome
pete
 
I want to append records to a table with "required" fields. But it sez
validation error. If i make the fiels not required all is ok. is there any
way round this ?
Any suggestions very welcome
pete
Click to expand...

Well, if the fields are required, then you must put something into the
field in your Append query. It's either required - or you can leave it
out; not both!

Does your Append query in fact populate the required fields? If not...
why not?

John W. Vinson[MVP]
 

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

Append Queries in 2007 5
Append only Null records in table 2
Append Query Fails, MS Access 2000 bug? 5
Can't create append query 2
append query not appending 2
Append Query 1
Appending records to new table using field names as values 2
Append Query 11

Back
Top