Appending one row at a time

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BK - 06 Jul 2006 15:59 GMT

Is there any way in an append query to specify that you just want to append
one row at a time?

Reply to this Message

Duane Hookom - 06 Jul 2006 16:50 GMT

You can't interrupt a SQL statement with a prompt to confirm individual
record appends or updates. A SQL statement/query is a batch process.

Signature

Duane Hookom
MS Access MVP

> Is there any way in an append query to specify that you just want to
> append
> one row at a time?

Reply to this Message

NathanJ - 06 Jul 2006 18:46 GMT

This may be accomplished by using a for loop and a counter inside VBA.
Although, you would have to run the query from a Form. This would
allow you to also create a prompt or execute code between each record
that you are appending.

> Is there any way in an append query to specify that you just want to append
> one row at a time?

Reply to this Message