Les machines ne font pas d'erreurs
Heureusement nous sommes humains
Option Compare Database Private 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 Private Declare Function GetOpenFileName Lib "comdlg32.dll" Alias "GetOpenFileNameA" (pOpenfilename As OPENFILENAME) As Long Private Declare Function GetSaveFileName Lib "comdlg32.dll" Alias "GetSaveFileNameA" (pOpenfilename As OPENFILENAME) As Long Private Function ShowOpen() As String Dim OFName As OPENFILENAME OFName.lStructSize = Len(OFName) OFName.hwndOwner = Me.hwnd OFName.hInstance = Application.hWndAccessApp OFName.lpstrFilter = "Tous les fichiers (*.*)" + Chr$(0) + "*.*" + Chr$(0) OFName.lpstrFile = Space$(254) OFName.nMaxFile = 255 OFName.lpstrFileTitle = Space$(254) OFName.nMaxFileTitle = 255 OFName.lpstrInitialDir = "C:" OFName.lpstrTitle = "Ouvrir..." OFName.flags = 0 If GetOpenFileName(OFName) Then ShowOpen = Trim$(OFName.lpstrFile) Else ShowOpen = "" End If End Function Private Sub cmd_import_Click() Me.Txt_import = ShowOpen End Sub
mais ça ne fait que de s'afficher, ça n'importe ou n'exécute pas.
Les machines ne font pas d'erreurs
Heureusement nous sommes humains