istext, value etc. functions don't work

[Guest]

I use Access 2000 with Windows 2000. There are a number of functions shown
in the help utility that don't work as described. Example: IsNumber isn't
recognized as valid in a query. I googled it and found that it should be
IsNumeric. Through hacking, I found that Value(text) should be Val(text).
On and on. Is there some listing somewhere that shows corrections to the
help utility? I have all the service packs.

In the same vein, some functions call for a MWSOF.dll to be present (I might
be missing a letteror two here). I have it, but functions still don't work.
Any solution?

 

[Allen Browne]

The help in Access 2000 was particularly bad, but I can find no reference to
functions called IsNumber() or Value(), so I'm not clear where you gained
that expectation from.

Three are some functions that don't work properly in the context of a query
in Access 2000. These include: FormatCurrency(), FormatDateTime(),
FormatNumber(), FormatPercent(), InStrRev(), MonthName(), Replace(),
Round(), StrReverse() and WeekdayName(). Reference:
http://support.microsoft.com/kb/225956

Perhaps you are calling functions in other libraries that are not part of
the basic 3 used by Access. If you are having problems with library
references, see:
http://allenbrowne.com/ser-38.html

 

[RoyVidar]

I use Access 2000 with Windows 2000. There are a number of functions shown
in the help utility that don't work as described. Example: IsNumber isn't
recognized as valid in a query. I googled it and found that it should be
IsNumeric. Through hacking, I found that Value(text) should be Val(text).
On and on. Is there some listing somewhere that shows corrections to the
help utility? I have all the service packs.

In the same vein, some functions call for a MWSOF.dll to be present (I might
be missing a letteror two here). I have it, but functions still don't work.
Any solution?

IsNumber and Value are Excel functions. If you have a reference to Excel
in your app (in VBE - Tools | References), they might show up in the
Access help, but you should see something like the following in the help
page; "WorksheetFunction.<MethodName>" to indicating this.

Some type conversion functions, can be found by searching for the help
topic "Type conversion functions". Also, when you find a topic, like
for instance Val, or IsNumeric, there should be a "See also" choice/
link to investigate similar functions, I think.

 

[Guest]

Thank you. I seldom use excel and didn't realize that some of the described
functiions are for excel, not Access. Interestingly, many that are defined
as "worksheet functions" do work in Access queries. AS Allen browne said
above, the help screens are not good. IsNumeric() and Val() show in the
function list when setting up a query, but not on the help screens.