Recent content by dxz

Hi CJ_London - this is a viable workaround for me long term. Although the initial set up of tables would be a bit of a pain, this would allow me to run the macros as expected. Thanks!

Hi theDBguy, The code is very long, but simplified it is as follows: INSERT INTO dbo_TRANSFER_ALLC (Tableone) SELECT dbo_TRANforALLC (Tableone.object) FROM [QueryinAccess] CJ_London has found a viable work around below: But if you have any other ideas I would be more than happy to hear them!

Hi theDBguy, Thank you for your reply. The code is quite simple, basically several instances of the below code: If DCount("*","Query1")>0 OpenQuery Query Name Test View Datasheet Data Mode Edit MessageBox Message Open transfer tool and upload appended data - do not click 'ok' until this has...

Hi Paul, Thank you for your reply. Sorry if I was not clear. I am testing within a macro but the DCount seems to only work with select queries - not append queries. *original post edited*.

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...