Results 1 to 3 of 3

Thread: VBA for Access-->GetOpenFileMethod??? (HEEEEEELLLLP!)

  1. #1

    Thread Starter
    Fanatic Member Avatarp's Avatar
    Join Date
    Sep 2002
    Location
    Calgary
    Posts
    826

    Unhappy VBA for Access-->GetOpenFileMethod??? (HEEEEEELLLLP!)

    Access XP:

    I am trying to get the file open dialog box to work in this function.

    Code:
    '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
    ' Opens the Open dialog box.
    '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
    Private Function MSA_GetOpenFileName(msaof As MSA_OPENFILENAME) As Integer
        Dim of As OPENFILENAME
        Dim intRet As Integer
    
        MSAOF_to_OF msaof, of
        intRet = GetOpenFileName(of)
        intRet = 1
    '    intRet = GetFileName(of)
        If intRet Then
            OF_to_MSAOF of, msaof
        End If
        MSA_GetOpenFileName = intRet
    
    End Function
    The MSAOF_to_OF function call sets the variable of. These can be found in the screen shot I attached. Please any help would be appreciated.
    Attached Images Attached Images  
    Last edited by Avatarp; Mar 21st, 2003 at 01:27 PM.

  2. #2

    Thread Starter
    Fanatic Member Avatarp's Avatar
    Join Date
    Sep 2002
    Location
    Calgary
    Posts
    826

    This works on some puters but not others!?!?!?!

    This code works on some computers but not others with the same Office Suite???? I'm testing this code at the same time on my laptop and my desktop. Laptop works...desktop doesn't. I have carefully checked my references and they match up. Is the only other possiblility a system problem?

    What else could be going on?

  3. #3

    Thread Starter
    Fanatic Member Avatarp's Avatar
    Join Date
    Sep 2002
    Location
    Calgary
    Posts
    826

    Argggg!

    Does the lack of response mean that nobody knows? Should I ask the gods?


    Avatarp:
    God, what is going on with this code? Is it software or hardware? Is it bad coding? It can't be bad coding. It must be related to Access.

    God:
    It is Microsofts fault son.
    Last edited by Avatarp; Mar 24th, 2003 at 04:10 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width