Quote:
Originally Posted by Ax238
I changed date to Date(), otherwise the parameter issue will still be present...you can't use vbMonday or date in a query.
|
Date works in VBA code without the parens, in v2003.
And you're correct, I believe, about not using the Constant vbMonday in a query, which is why I asked the OP about where he was using this. Since it was in a Report, this doesn't come into paly, and vbMonday should have worked just fine.