Handle error in append query

[Bokazoit]

I have tried searching this forum but with no luck. But I think I have read something somewere about my problem.

Anyway. I have and append query and before it appends the data into a table it asks for a period (a number). I have used parameter and choosen value. So far so good. But I would really like it to react on errors so that it gives the user a choice between:

1. try again or

2. exit

I have all the queries in an access macro so when asked for a period I would like that to happen.

How to do that?

In advance tx

 

[PHV]

I'm afraid you have to deal with VBA code for transaction and recordset stuff.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Bokazoit]

/me hides

Can do VB :.(