Hey folks, this one is causing me some grief. All i'm trying to do is open a recordset, but my code keeps falling over at the sql statement.
This is the relevant part of the code:
Maybe i'm just stupid and i'm missing an obvious flaw here...but i can't see why this results in an "Invalid SQL statement" error.
Any help??
-Jezza
This is the relevant part of the code:
Code:
Dim strSQL As String
strSQL = "SELECT * FROM Reminder WHERE Reminder.RemDate = Date()"
Maybe i'm just stupid and i'm missing an obvious flaw here...but i can't see why this results in an "Invalid SQL statement" error.
Any help??
-Jezza