Solved

Open File Dialog

Posted on 2008-10-27
1
246 Views
Last Modified: 2013-11-27
I use the following code (per Ken Getz et al) for the user to open files contained in a Participant's folder.
When the user opens one file it closes the dialog box. When the user selects muliple files the dialog box remains open. I want it to do the latter (i.e., not close the dialog box when only one file is selected.) Does any one know how to control this?
Public Function fGetDocFiles(strDirectory As String) As Boolean

 

On Error GoTo Err_DocFiles

 

   Dim strDocDirectory As String

   Dim lngFlags As Long

   Dim gfni As adh_accOfficeGetFileNameInfo

   Dim strReturnFile As String

   

   strDocDirectory = strDirectory

   fGetDocFiles = True

  

    On Error Resume Next

    

    If Dir(strDocDirectory) = "" Or IsNull(Dir(strDocDirectory)) Then

        MkDir (strDocDirectory)

    End If

        

    On Error GoTo 0

      

    lngFlags = lngFlags Or adhcGfniConfirmReplace

    lngFlags = lngFlags Or adhcGfniNoChangeDir

    lngFlags = lngFlags Or adhcGfniAllowReadOnly

    lngFlags = lngFlags Or adhcGfniAllowMultiSelect

   ' lngFlags = lngFlags Or adhcGfniDirectoryOnly

    lngFlags = lngFlags Or adhcGfniInitializeView

   

    With gfni

        .lngView = 0

        .lngFlags = lngFlags

        ' Make sure not to pass in Null values. adhOfficeGetFile

        ' doesn't like that, and often GPFs.

        .strFilter = "All Files (*.*)"

        .lngFilterIndex = 1

        .strfile = ""

        .strDlgTitle = "Find Correspondence for " & fGetCaption() & ""

        .strOpenTitle = "Search Docs " & ""

        .strInitialDir = strDocDirectory & ""

    End With

 

    If adhOfficeGetFileName(gfni, True) = adhcAccErrSuccess Then

        strReturnFile = Trim(gfni.strfile)

        Call ShellEx(strReturnFile)

    End If

       

    

 

Exit_DocFiles:

    Exit Function

 

Err_DocFiles:

    msgbox Err.Description

    Resume Exit_DocFiles

    

 

End Function

Open in new window

0
Comment
Question by:bin2003
1 Comment
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 22819655
bin2003,

This is the code I use, I found it a while ago on the web.

It leaves the dialog box open when you select one file, as you specified.

'Needed for FileToOpen (Dialog Box) Codes
Declare Function GetOpenFileName Lib "comdlg32.dll" Alias "GetOpenFileNameA" (pOpenfilename As gFILE) As Long
Type gFILE
 lStructSize As Long
 hwndOwner As Long
 hInstance As Long
 lpstrFilter As String
 lpstrCustomFilter As String
 nMaxCustFilter As Long
 nFilterIndex As Long
 lpstrFile As String
 nMaxFile As Long
 lpstrFileTitle As String
 nMaxFileTitle As Long
 lpstrInitialDir As String
 lpstrTitle As String
 Flags As Long
 nFileOffset As Integer
 nFileExtension As Integer
 lpstrDefExt As String
 lCustData As Long
 lpfnHook As Long
 lpTemplateName As String
End Type

Function FileToOpen(Optional StartLookIn) As String
'*Needs code from Declaratiomns section, in order to work
 Dim OFN As gFILE
 Dim path As String
 Dim FileName As String
 Dim a As String
 
StartOver:
OFN.lStructSize = Len(OFN)
OFN.lpstrFilter = "My Excel Files (*.xls)" + Chr$(0) + "*.xls" + Chr$(0) + "All Files (*.*)" + Chr$(0) + "*.*" + Chr$(0)
OFN.lpstrFile = Space$(254)
OFN.nMaxFile = 255
OFN.lpstrFileTitle = Space$(254)
OFN.nMaxFileTitle = 255

If Not IsMissing(StartLookIn) Then
 OFN.lpstrInitialDir = StartLookIn
'Else
' OFN.lpstrInitialDir = "C:\CorelDrw Files"
End If

OFN.lpstrTitle = "Please find and select the Excel File"
OFN.Flags = 0

a = GetOpenFileName(OFN)
If (a) Then
 path = Trim(OFN.lpstrFile)
 FileName = Trim(OFN.lpstrFileTitle)
 If Dir(path) <> "" Then FileToOpen = -1
 FileToOpen = Trim(OFN.lpstrFile)
Else
 FileToOpen = ""
 path = ""
 FileName = ""
End If

FileToOpen = path

End Function



(I call the function with code like this:
DoCmd.TransferSpreadsheet acImport, 8, strNewTableName, FileToOpen, True, "")

JeffCoachman
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now