Compile error. in query expression
From: M Fuller (fullerm_at_mmri-ny.com)
Date: 02/12/04
- Next message: Ian: "Comparison query year1 to year2 ??"
- Previous message: Pikabu: "Double Joins"
- In reply to: M Fuller: "Compile error. in query expression"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 12 Feb 2004 09:11:12 -0800
Make that Access 2000, not 200 =)
>-----Original Message-----
>I've recently been having a problem with an Access 200
>database and I can't figure out why. In a couple of
>tables, I have date fields, and data is imported from tab-
>delimited files on a daily basis. I have queries built
>that are called by ASP pages, and they work fine. I've
>gone back to some of the queries to slightly modify them,
>and when I try to open them, I get an error: "Compile
>error. in query expression 'Year([PostDate])'". I've
>tried several Date functions on these date/time fields,
>and they all give me a compile error.
>
>I also get a compile error when trying to use
>DoCmd.TransferText in a module - "Compile error: Invalid
>outside procedure".
>
>I can't figure out why these queries and modules used to
>be fine, and in fact still run as stored procedures from
>ASP pages, but won't open correctly in Access itself.
Can
>anyone give me any direction?
>
>Thanks
>.
>
- Next message: Ian: "Comparison query year1 to year2 ??"
- Previous message: Pikabu: "Double Joins"
- In reply to: M Fuller: "Compile error. in query expression"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
