KennyJaymes
Technical User
Hi all, I am a relitive newcomer to VB-A so please treat me like a dummy. I am hoping to learn from your kind replies.
I have an append query that is part of a chain of querys used to import data from a outside database.
Each record in both my own and the outside db have a unique Catalogue Number.
I need some way of checking if this catalogue number already exists in my own database and if it does,
I would like the query to be paused while a message box pop's up and warns the user that Catalogue Number <what ever it happens to be to be shown to the user> already exists and wont be appended, the user then clicks on an OK button, and the code then continues until either it happens again or the import is completed.
Is this going to be very hard to do and could someone suggest how I might do it. Code examples would be great if I am not being to cheaky or imposing on everyone (I know you are all busy people).
Thank you in advance,
Kenny
[sig][/sig]
I have an append query that is part of a chain of querys used to import data from a outside database.
Each record in both my own and the outside db have a unique Catalogue Number.
I need some way of checking if this catalogue number already exists in my own database and if it does,
I would like the query to be paused while a message box pop's up and warns the user that Catalogue Number <what ever it happens to be to be shown to the user> already exists and wont be appended, the user then clicks on an OK button, and the code then continues until either it happens again or the import is completed.
Is this going to be very hard to do and could someone suggest how I might do it. Code examples would be great if I am not being to cheaky or imposing on everyone (I know you are all busy people).
Thank you in advance,
Kenny
[sig][/sig]
