I'm trying to find out if there is a way to write a script to download files from an FTP site. I need it to be able to download several files that have an unknown time stamp so it will have a wildcard at the end. Also, on occasion, there will be multiple files for the same day with different time stamps, and I need to get them all. I tried a batch file, but it is too limiting as I cannot get it to download the multiple files.
I'm running...

Here is a way you can have a browser window pop up and they can select the file, regardless of the name or filepath.

Function GetFile()
'Declare a variable to contain FileDialog
Dim sMyPath As FileDialog
'Declare a variable to contain the path
Dim sPath As Variant


DoCmd.SetWarnin gs False
DoCmd.Hourglass True
' Set up the File Dialog.
...

I'm not familiar with how to use Nz. Where would I put that?...

I'm trying to create a form that has several text boxes for input by the user. I want to use the input as criteria for a query that will then display in a listbox on that same form.
I can get it to work, but i need to have the query use the criteria entered, and if some is left out, ignore it instead of seeing it as a Null value.

For example, I have inputs for First Name, Last Name, City, State

User inputs Last...