I have a report that is to run based on a query. In this query I have
the following as a field.

Date By Month: Format$([tblIssues].[IssueDate],'mmmm yyyy')

Prior to Splitting and distributing the MDE, I compiled the database
(all was working before compile). Now I receive the following error.


Compile Error. in query expression 'Date By Month:
Format$([tblIssues].[IssueDate],'mmmm yyyy')'.


Any thoughts???

Tammy

You have a problem with References.

Open a code window, and choose References on the Tools menu.

More info:
http://allenbrowne.com/ser-38.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"FireGeek822" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have a report that is to run based on a query. In this query I have
> the following as a field.
>
> Date By Month: Format$([tblIssues].[IssueDate],'mmmm yyyy')
>
> Prior to Splitting and distributing the MDE, I compiled the database
> (all was working before compile). Now I receive the following error.
>
>
> Compile Error. in query expression 'Date By Month:
> Format$([tblIssues].[IssueDate],'mmmm yyyy')'.

Allen,

Looks like MS Access 2003 SP2 automatically activated the following
References:
- FPDTC 1.0 Type Library
- MS Web Components 11.0
- MS Office XP Web Components

My project isn't using anything related to the web! For anyone's
knowledge, FPDTC 1.0 Type Library is Front Page Design Time Controls.
That took me a while to find. Again, my project isn't using anything
related to Front Page either.

I removed these unnecessary references. Recompiled and all is working
ok.

THANKS FOR YOUR HELP ALLEN!!!

T-

THANKS Allen. I have been racking my brain looking at the report and
query and the code between! WoW references! Pick up something new
every day.

So, I just checked them - nothing "MISSING". However, do you know what
"fpdtc 1.0 Library" is? This is foreign to me.

T-

Ignore the above last message - looks like Google logged these out of
order.

T-