Help with Dir function

  • Thread starter Thread starter TerryC
  • Start date Start date
T

TerryC

Dear All,

This is a continuation from an earlier question in the
forms group. This is probably a better forum (please let
me know if this is not right).

Access XP SP2
Win2K SP4

We have a DB that uses some macros to load text files into
tables. One of the conditions in the Macro uses the Dir
function to test if the file exists. This works fine on
all except one PC. This gets a "function Dir does not
exist" type message and fails. If we do a Dir from a code
module all is fine, however Dir from within a Macro or as
a function in a form control is no good (name? is returned
within a control). From this PC only.

Have tried:
Re-install of Office
Uncheck and re-check references (all that we could) no
references displayed the "missing" that several articles
refer to.
Have read Douglas Steele's Access Reference Errors page.
And generally pulled a lot of hair out.
We are hoping not to have to FDisk.

Does anyone know what library(s) are used that might cause
this problem? (Works from VBA and not from anywhere else?)

Any suggestions, thoughts, fixes .... gratefully accepted.

Thanks in advance

Terry
 
You should do this in code instead of a macro...you'd have an easier time
debugging that way.
 
Hi
What Operating system is the computer using? Some of the
commands such as attrib etc have changed in Win 2000 and
Win XP and cause this sort of error. Check MS Knowledge
base for list of commands. Hope this helps
 
Back
Top