Virtually Inert Person
Windows 10 
Access 2016
Maybe I'm being thick again? Your test was whether or not Dir("") = "", or in English, is Dir("") equal to a zls which is a valid question. However, the proposed was (in English) what is Dir("")?
For me, the answer to the latter is "Access.mdb" (without quotes of course). Now that is a bit surprising
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
VIP
Windows 10 Office 365
If you use Dir("") to test for a file's existence you will get unreliable results, that was the point of my statement.
Hence using
Dir(NZ([FIleName],"") is not a reliable way of testing for a result.
You need to actually check for a file name being present first, then use Dir() to check if it exists.
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
VIP
Windows 10 Access 2010 32bit
think
Dir("")
will return something random - I get
?dir("")
A97AutoColumnWidthVer21.accdb
like you, no idea where that came from - the file is in a temporary folder and I haven't looked at it for over 3 years
Think at the very least you need to provide a path
And dir never returns null - best you will get is a zls
dblClick textbox to follow hyperlink
No Runtime Error-forms or VBA Compile Error when running Function via Button_Click in Form
Add button to follow hyperlink in table
Posting Permissions
Reply With Quote