The expression you entered has a function name that Microsoft Offi

[Ellen]

Using Access 2003. Macro suddenly stopped working and displays the following
message:

"The expression you entered has a function name that Microsoft Office Access
can't find" appears when the DIR() function is used but does not if it is
removed from the condition statement on the macro.

The macro performs the condition check and then Beeps if true. Here is the
conditional statement.

"CUNAREQ.XLS"=UCase(Dir("\\smpftpp02\AshBrkrgeS\CUNAREQ.xls"))

Any ideas why this would stop working?

Ellen

 

[KARL DEWEY]

'DIR' is not an Access function.

 

[Ellen]

If it's not a function in access, then why is it on Microsoft's site? This
article states that this function is available in access 2003.

http://office.microsoft.com/en-us/access/HP011353121033.aspx?pid=CH011413201033#D