using Access Functions

[Rex Huston]

Hi,
I just installed Access 2000 and for some reason it will
not let me use some of the basic functions such as Format()
When I run the code it pops up with the unknown function
error message. Format() is spelled correctly and Access
does not have problems with the paramaters. Here is the
line of code that gets the error.
report_date_string = Format(report_date, "m/d/yyyy")
report_date is a date entered by the user.
Thanks for the help,
Rex

 

[Van T. Dinh]

It sounds like the References of your database is messed up.

See Douglas J. Steele's article:

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

 

[chas]

Hi Rex,

you probably have a missing VBA reference. Press ALT+F11
in the database, choose Tools|References in the VBA editor
and take a look at the selected references, you will
probably see one listed as (missing). You can usually de-
select this reference and you should then be able to use
the functions as expected.

hth

chas

 

[Doug Chinnock]

When in the VB editor, click on Tools|References...
A list of available reference libraries will appear.

See if the same ones are checked in both installs.

--Doug