using Access Functions

  • Thread starter Thread starter Rex Huston
  • Start date Start date
R

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