Appending Queries

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

b5917bts - 04 Mar 2007 03:07 GMT

I have a program that appends queries to a particular table. The problem I'm
having is that at times the append query doesn't always have all the fields
the table does and sometimes it does. How can I have a query that will apend
data on some of the table's field without causing an error problem.

Reply to this Message

Arvin Meyer [MVP] - 04 Mar 2007 03:29 GMT

Try adding default values to the required fields in the table being appended
to.

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

>I have a program that appends queries to a particular table. The problem
>I'm
[quoted text clipped - 3 lines]
> apend
> data on some of the table's field without causing an error problem.

Reply to this Message

b5917bts - 04 Mar 2007 03:51 GMT

I will try this and see if it works Thank You very much.

> Try adding default values to the required fields in the table being appended
> to.
[quoted text clipped - 5 lines]
> > apend
> > data on some of the table's field without causing an error problem.

Reply to this Message