D
dan.cawthorne
With On My Main Form a I Have a Date Field "RecievedDate" Set to a
Date Type.
The Form is Based on a Query Search,
When I'm Trying to do is Print the Filtered Results on my Current
Reports
So On The Onclick Event of a Button I Used The Following Code
Private Sub PrintAll_Click()
DoCmd.OpenReport "Project_Summary", acViewPreview, , "[Received Date]
= '" & [Received Date] & " ' "
End Sub
And I Got a Mismatch Error So Then I Change a Code To the Following
Private Sub PrintAll_Click()
DoCmd.OpenReport "Project_Summary", acViewPreview, , "[Received Date]
= '" & [Received Date] & "#"
End Sub
And Now I Get an Run Time Error 3075
Syntax Error in String In Query Expression '([Recieved Date] =
'05/07/2007#)'
Am I Missing Something?
Date Type.
The Form is Based on a Query Search,
When I'm Trying to do is Print the Filtered Results on my Current
Reports
So On The Onclick Event of a Button I Used The Following Code
Private Sub PrintAll_Click()
DoCmd.OpenReport "Project_Summary", acViewPreview, , "[Received Date]
= '" & [Received Date] & " ' "
End Sub
And I Got a Mismatch Error So Then I Change a Code To the Following
Private Sub PrintAll_Click()
DoCmd.OpenReport "Project_Summary", acViewPreview, , "[Received Date]
= '" & [Received Date] & "#"
End Sub
And Now I Get an Run Time Error 3075
Syntax Error in String In Query Expression '([Recieved Date] =
'05/07/2007#)'
Am I Missing Something?