Search results

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

Thank you!

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