p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: Function is not available...


Message #1 by PStreeter@C... on Mon, 24 Jun 2002 9:57:00 CST
This morning a query that has worked once a week for 3 years 
ends with the message "Function is not available in expressions 
in the query expression 'Right([OBG_GRANT_NUMBER],5)'." 
Clicking the "HELP" button gets the incredibly useful phrase 
"The expression you typed is not valid for the reason indicated... ."

Why would Access's "Right()" function suddenly not be available?

Paul


Message #2 by "Gregory Serrano" <SerranoG@m...> on Mon, 24 Jun 2002 17:58:02
Paul,

<< Why would Access's "Right()" function suddenly not be available? >>

Because your reference library that holds that function has been 
disabled.  Open any module and click Tools | References.  Make sure all 
your needed libraries are chosen.  I don't know which one exactly houses 
the RIGHT() function.

Greg
Message #3 by "Amy Wyatt" <amyw@c...> on Mon, 24 Jun 2002 19:00:35
This is, of course, another Access quark I have seen. It is the referances 
but there are time when it will not show the corrupt reference. I have had 
to add another referance and the close completely out of Access and go 
back in and remove the referance. To get it to go back to working. 

Good Luck,

Amy

> Paul,

> << Why would Access's "Right()" function suddenly not be available? >>

> Because your reference library that holds that function has been 
d> isabled.  Open any module and click Tools | References.  Make sure all 
y> our needed libraries are chosen.  I don't know which one exactly houses 
t> he RIGHT() function.

> Greg
Message #4 by "Leo Scott" <leoscott@c...> on Mon, 24 Jun 2002 11:08:48 -0700
If you look at Tools->References you will find one that has MISSING in the
title.  Any one that has missing disables all the libraries and therefore
the VBA functions are not avaliable in queries either.  You have to replace
the reference that is missing with a correct one.  Either the file was
moved/ run from another system with different libraries or something on the
existing system was changed that made one of the libraries invalid.

|-----Original Message-----
|From: PStreeter@C...
|[mailto:PStreeter@C...]
|Sent: Monday, June 24, 2002 8:57 AM
|To: Access
|Subject: [access] Function is not available...
|
|
|This morning a query that has worked once a week for 3 years
|ends with the message "Function is not available in expressions
|in the query expression 'Right([OBG_GRANT_NUMBER],5)'."
|Clicking the "HELP" button gets the incredibly useful phrase
|"The expression you typed is not valid for the reason indicated... ."
|
|Why would Access's "Right()" function suddenly not be available?
|
|Paul
|
|
|
|

Message #5 by PStreeter@C... on Mon, 24 Jun 2002 13:04:03 CST
On Mon, 24 Jun 2002 11:08:48 -0700 "Leo Scott" wrote:

> If you look at Tools->References you will find one that has MISSING in the
> title.  Any one that has missing disables all the libraries and therefore
> the VBA functions are not avaliable in queries either.  You have to
> replace
> the reference that is missing with a correct one.  Either the file was
> moved/ run from another system with different libraries or something
> on the
> existing system was changed that made one of the libraries invalid.

I had removed RealPlayer from the computer. For a reason unknown 
to me Access had a reference to a RealPlayer library. Thanks to both 
of the people that helped with this one.

Paul


Message #6 by "Leo Scott" <leoscott@c...> on Mon, 24 Jun 2002 13:31:36 -0700
I wouldn't have RealPlayer on my systems, it installs spyware.

|-----Original Message-----
|From: PStreeter@C...
|[mailto:PStreeter@C...]
|Sent: Monday, June 24, 2002 12:04 PM
|To: Access
|Subject: [access] RE: Function is not available...
|
|
|On Mon, 24 Jun 2002 11:08:48 -0700 "Leo Scott" wrote:
|
|> If you look at Tools->References you will find one that has
|MISSING in the
|> title.  Any one that has missing disables all the libraries and therefore
|> the VBA functions are not avaliable in queries either.  You have to
|> replace
|> the reference that is missing with a correct one.  Either the file was
|> moved/ run from another system with different libraries or something
|> on the
|> existing system was changed that made one of the libraries invalid.
|
|I had removed RealPlayer from the computer. For a reason unknown
|to me Access had a reference to a RealPlayer library. Thanks to both
|of the people that helped with this one.
|
|Paul
|
|
|
|


  Return to Index