|
 |
access thread: Big Mystery Format
Message #1 by pmcmillin@m... on Thu, 10 May 2001 17:42:18 -0700
|
|
I have a mystery that I am needing solved. I have created a Xtab query
that formated the date like the following:
Month: Format([DateEntered],"mmm")
And it appeared to work just fine. Until today... Now I am getting the
following message:
"Function isn't available in the expressions in the query expression
'Format([DateEntered],"mmm")"
And of course help took me no where. Not quite sure why this worked before
and now it doesn't want to work anywhere. I tried the Wizard and it built
the same function and it still wont' work. I went to someone else's
computer and tried to run it from there and still no action.
Has any one seen this before?
Thanks
Pam McMillin
Systems Technician
Schlumberger - IPM Asset Management
500 W. Texas, Suite 500
P.O. Box 2726
Midland, TX 79702-2726
Office 915/571-4600
Cell 915/556-0749
Fax 915/571-4788
pmcmillin@m...
Message #2 by "John Ruff" <papparuff@c...> on Thu, 10 May 2001 18:01:57 -0700
|
|
It sounds as if you may have lost one of your references. Open any module
and go to Tools > References. See if any that are checked off are listed as
Missing. If one of them is remove the check to the missing reference.
Compile the entire database after this to insure everything compiles
properly.
John Ruff - The Eternal Optimist :)
-----Original Message-----
From: Pam McMillin [mailto:pmcmillin@m...]
Sent: Thursday, May 10, 2001 3:06 PM
To: Access
Subject: [access] Big Mystery Format
I have a mystery that I am needing solved. I have created a Xtab query
that formated the date like the following:
Month: Format([DateEntered],"mmm")
And it appeared to work just fine. Until today... Now I am getting the
following message:
"Function isn't available in the expressions in the query expression
'Format([DateEntered],"mmm")"
And of course help took me no where. Not quite sure why this worked before
and now it doesn't want to work anywhere. I tried the Wizard and it built
the same function and it still wont' work. I went to someone else's
computer and tried to run it from there and still no action.
Has any one seen this before?
Thanks
Pam McMillin
Systems Technician
Schlumberger - IPM Asset Management
500 W. Texas, Suite 500
P.O. Box 2726
Midland, TX 79702-2726
Office 915/571-4600
Cell 915/556-0749
Fax 915/571-4788
pmcmillin@m...
|
|
|
View Cart
