G Guest Jul 6, 2006 #1 Is there any way in an append query to specify that you just want to append one row at a time?
D Duane Hookom Jul 6, 2006 #2 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.
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.
N NathanJ Jul 6, 2006 #3 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.
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.
