Link to home
Start Free TrialLog in
Avatar of lpawlowski
lpawlowski

asked on

GetOpenFileName function call

Using the "GetOpenFileName in my Access 2.0 application seems to work fine.  After converting over to Access 97, I made what I belive to be the appropriate changes and now I don't get any compile errors or run-time errors, but the function is not working correctly.  When I step through the code and execute the function call, it returns a 0 and DOES NOT display a dialog box for the user to pick a file, but it doesn't error out.  Here is exactly what I've got in code...

In a module....

Type OPENFILENAME
        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

Declare Function GetOpenFileName Lib "comdlg32.dll" Alias "GetOpenFileNameA" (pOpenfilename As OPENFILENAME) As Long

In obj_click sub....

Dim file As OPENFILENAME
Dim response As Variant

response = GetOpenFileName(file)


I'm having trouble debugging this since I don't see what the error is.

ASKER CERTIFIED SOLUTION
Avatar of Trygve
Trygve

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Trygve
Trygve

Have you tested the solution? Do you need more assistance?
This question was awarded, but never cleared due to the JSP-500 errors of that time.  It was "stuck" against userID -1 versus the intended expert whom you awarded.  This corrects the problem and the expert will now receive these points; points verified.

Please click on your Member Profile and select "View Question History" to navigate through any open or locked questions you may have to update and finalize them.  If you are an EE Pro user, you can also choose Power Search to find all your open questions.

This is the Community Support link, if help is needed, along with the link to All Topics which reflects many TAs recently added.

https://www.experts-exchange.com/jsp/qList.jsp?ta=commspt
https://www.experts-exchange.com/jsp/zonesAll.jsp
 
Thank you,
Moondancer
Moderator @ Experts Exchange