Recent content by TEE45SEE

Thanks to each of you for responding and pointing me in the right direction. Have found and corrected with everything working as it should. Thank you to The_Doc_Man for the welcome Till the next time.

I have a relatively simple SELECT query which when run it gives me "Runtime error 91" strSQL = "SELECT * FROM tblMonthlyHomeExpenses" _ & " WHERE DatePart('m',[dteTransDate]) =" & intMonthNumber & ";" When I take the same query and run it as SQL it does exactly what I would expect...