Hi Guys,
I'm looking for a way to build an array of file names where a file exists. (I've been advised this is the way to sort my problem)
The list of potential file names will be from a query.
The array will be used to attach PDFs to an e-mail
The problem is that I'm really novice with recordsets, the reading I've done on arrays confuses me and I struggle with anything but the simplest loops.
I'm aware of the FileExists() function
My thoughts are:
Hope someone can explain.
Thank You
I'm looking for a way to build an array of file names where a file exists. (I've been advised this is the way to sort my problem)
The list of potential file names will be from a query.
The array will be used to attach PDFs to an e-mail
The problem is that I'm really novice with recordsets, the reading I've done on arrays confuses me and I struggle with anything but the simplest loops.
I'm aware of the FileExists() function
My thoughts are:
Code:
Dim db as Database
Dim rs as Recordset
Set mydatabase = CurrentDb
Set rs = mydatabase.OpenRecordset("qryEmailGovernance", dbOpenDynaset)
Dim FileLocation as String
i=0
Do While rs.AbsolutePosition <> -1
If FileExists("FileLocation") Then
?????????????????Stuck?????????????????????????
Else
End If
i=i+1
rs.MoveNext
Loop
set rs = nothing
set db = nothing
Hope someone can explain.
Thank You