I just had my computer crash on me,

[Arob]

I just had my computer crash on me, I was using WinNT and now they have me on Win2k. This worked fine before, but now it doesn't.

DoCmd.TransferText acExportDelim, "Qrytablchurchsuggappend Export Specification", "qrytablchurchsuggappend", "c:\download\qrytablchurchsuggappend.txt", True, ""

Gives me this error:
Run time error '3075':
function is't available in expressions in query expression '(((tblchurchsuggestions.lastupdate)>Date()-60))

Okay, so we go to our query and we look at it.
Try and running it with this in the criteria box for the lastdate
Criteria: >Date()-60
It worked before, now it gives us this error:
"This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables.

If we take away the criteria, it runs fine. What the heck happened. We tried creating a new module and did this...
Sub Test()
msgbox (date()-60)
End sub
This displayed the same error, so we went a step further and changed Date() to VBA.Date() and then it worked perfectly. However, we can't type VBA.Date() into the query criteria or we get a syntax error.

I know it's confusing. Anyone have a clue?

 

[cheerio]

Take a look at FAQ 6g which indicates a possible cause and cure for this type of problem.

Ken

 

[Arob]

Thanks a million, that took care of the problem.