Search results

Thanks Ian I have fixed the 'missing space' in my code. Also, simplified my code as per your suggestion. It works brilliantly!!! This forum is cracking - Cheers mate!! :)

Hi, I get an 'Invalid argument' error message when I run the 'strSQL' part of my vb code (in Access VB). However, the query seems to run ok as a straight sql query in Access. Is there a better way of structuring sql codes executed from within VB? I am hoping that someone would be kind enough...