You know I was sure I had tried that and failed. But no I hadn't and it works perfectly.
Thank you, Thank you. I have been trying to work this out for days as I didn't want to waste anyones time here....
Such a simple fix.
Hello,
I have hit the too many line continuations in a vba select query. I have read you are limited to 24 lines and to get around that you can trick access by various methods that I have not been able to make work. I tried this cstrOldSQL = cstrOldSQL + "SELECT Contract.Accommodation," & _ but...
Hello Everyone,
I live in Melbourne and most of my hobbies have been stopped with the virus. However, I do love computers and enjoy MS Access as I use it at work to automate some of the boring stuff.
With all this spare time I have at the moment with the lockdown I see it's time to advance my...