Question FileLen - Why do I get an 'Undefined Function' error?

[alexfwalker]

I want to record the size of a file and have tracked down plenty of posts which suggest that 'FileLen' is the function that I need. However, whether I use it a query eg:

file_len_1: FileLen("C:\test.txt")

or in VBA eg:

Msgbox FileLen("C:\test.txt")

I get the undefined function error. How do I go about defining a function if necessary?!

Thanks,

Alex

 

[spikepl]

It's sitting in a library that is not referenced by your db. VBA-window-->tools ->references

I don't know which library, so google the function or wait until someone turns up with the answer.

 

[alexfwalker]

It's sitting in a library that is not referenced by your db. VBA-window-->tools ->references

I don't know which library, so google the function or wait until someone turns up with the answer.

Thanks Spike, I'll get on the Google for a bit!

 

[spikepl]

Hmm the function is in vba, so I wonder... try VBA.FileLen and see if that helps. If it does, then I don't remember why

 

[vbaInet]

Like spikepl suggested, you are having problems with your references. Create a new database shell and import all your objects into it.