Pick File - Access Developer Forum - Computer Learning Zone


	Back to Access Developer Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Pick File

Brent Rinehart

4 years ago

I'm trying to get the pick file routine to work for selecting folders, but I cannot get it to work for the life of me what am I doing wrong? Below is what I am trying. Thank you in advance for any help I have been trying for the last hour with no luck.

Private Sub DispatchBtn1_Click()

If IsNull(ScheduledDate1) Then
    Exit Sub
Else

    If IsNull(DispatchPath1) Then
        DispatchPath1 = PickFile("", True, False)

    Else
        ShellEx (DispatchPath1)

    End If
End If

End Sub

	Kevin Robertson @Reply 4 years ago
What happens when you run the code?

	Kevin Robertson @Reply 4 years ago
Ok, I did some testing using similar code to yours. Try also checking for an empty string. `If IsNull(DispatchPath1) Or DispatchPath1 = "" Then`

	Kevin Robertson @Reply 4 years ago
Is the text box bound to a field in a table?

	Brent Rinehart OP @Reply 4 years ago
You responded before I could delete my comment I found my stupid mistake, I did not name my text boxes and that is why it could not write those values Im little under the weather and made a really bad beginner mistake. It is working beautifully now.

	Brent Rinehart OP @Reply 4 years ago
Thank you Kevin for your help appreciate it.

	Kevin Robertson @Reply 4 years ago
Glad you got it working.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Forum.

Next Unseen

New Feature: Comment Live View