Recent content by jonnyp

Incidentally, is InStr faster than LIKE, and is it case-sensitive? Cheers!

Hi Bob, Thanks for that, this looks great. Ideally I'd like to edit the existing queries as little as possible rather than creating new ones, so I was wondering if I can tweak what I have from to something like and paste in the whole WHERE SQL statement rather than just a parameter? Forgive...

Hello there! I started using Access last week at work and am starting to get to grips with it. I have a lot of experience with PHP/mySQL setups but never really used Access or VBA before. I've built a form to export a set of queries to excel, based upon the date input, while excluding a...