Compile Error on Format$

[FireGeek822]

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

 

[Allen Browne]

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

 

[FireGeek822]

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-

 

[FireGeek822]

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-

 

[FireGeek822]

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

T-