Dir() Function

[A. J.]

Could someone help me for the meaning for the code below:

Dir(Foldername + "*.*", 31)

What is the "*.*", 31 mean? Thanks.

 

[vanderghast]

From the help (from VBE):

In Microsoft Windows, Dir supports the use of multiple character (*) and
single character (?) wildcards to specify multiple files. On the Macintosh,
these characters are treated as valid file name characters and can't be used
as wildcards to specify multiple files.


and

31 is the sum of the flags values you want to get, here 16 (you will get
directories), 8 (volume, but ignored here), 4 (system files), 2 (hidden
files) and 1 (read only). So, you could get standard files, but also, read
only ones, hidden ones, those part of the system as well as directories.

Note that (still from the help):

Dir returns the first file name that matches pathname. To get any additional
file names that match pathname, call Dir again with no arguments. When no
more file names match, Dir returns a zero-length string ("").



Vanderghast, Access MVP

 

[A. J.]

Thanks.

From the help (from VBE):

In Microsoft Windows, Dir supports the use of multiple character (*) and
single character (?) wildcards to specify multiple files. On the Macintosh,
these characters are treated as valid file name characters and can't be used
as wildcards to specify multiple files.


and

31 is the sum of the flags values you want to get, here 16 (you will get
directories), 8 (volume, but ignored here), 4 (system files), 2 (hidden
files) and 1 (read only). So, you could get standard files, but also, read
only ones, hidden ones, those part of the system as well as directories.

Note that (still from the help):

Dir returns the first file name that matches pathname. To get any additional
file names that match pathname, call Dir again with no arguments. When no
more file names match, Dir returns a zero-length string ("").



Vanderghast, Access MVP