Hi All,
I am designing a macro which has several append queries. (About 30.)
All appends from Access go to an upload tool before being loaded to a database.
Because of this, each time the append rows is more than 0, a message box will need to display something along the lines of:
"Open transfer tool and upload appended data - do not click 'ok' until this has been done."
This gives you time to open the tool and push the data, then click 'ok' to continue with the macro.
I have tried using IF's:
but this doesn't seem to work (i.e. it does not skip past when the result is 0) within the macro on append queries. (Works with queries.)
Note: I am doing this within the macro, not VBA.
TLDR: How can I make a macro skip an append query if update rows is 0?
Thanks in advance for your help and time!
Alex
I am designing a macro which has several append queries. (About 30.)
All appends from Access go to an upload tool before being loaded to a database.
Because of this, each time the append rows is more than 0, a message box will need to display something along the lines of:
"Open transfer tool and upload appended data - do not click 'ok' until this has been done."
This gives you time to open the tool and push the data, then click 'ok' to continue with the macro.
I have tried using IF's:
Code:
DCount("*","Query1")>0
Note: I am doing this within the macro, not VBA.
TLDR: How can I make a macro skip an append query if update rows is 0?
Thanks in advance for your help and time!
Alex
Last edited: