Compile Error on Format$

  • Thread starter Thread starter FireGeek822
  • Start date Start date
F

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,

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-
 
Back
Top