Boa tarde
Como acrescentar as extensões, accde e accdr, na linha -- .Filters.Add ".accdb", "*.accdb", 1
Private Sub CMD_CAMINHO_SISTEMA_Click()
On Error Resume Next
Dim strFilePath As String
With Application.FileDialog(msoFileDialogFilePicker)
.Title = "Selecionar arquivo" & DataBaseName
.ButtonName = "Confirmar"
.InitialFileName = DataBaseName
.AllowMultiSelect = False
.Filters.Add ".accdb", "*.accdb", 1 'acrescentar aqui as extensões accde, e accdr
.Show
If .SelectedItems.Count > 0 Then
strFilePath = .SelectedItems(1)
Me.REC_SIS = strFilePath
End If
End With
End Sub
Obrigado
Como acrescentar as extensões, accde e accdr, na linha -- .Filters.Add ".accdb", "*.accdb", 1
Private Sub CMD_CAMINHO_SISTEMA_Click()
On Error Resume Next
Dim strFilePath As String
With Application.FileDialog(msoFileDialogFilePicker)
.Title = "Selecionar arquivo" & DataBaseName
.ButtonName = "Confirmar"
.InitialFileName = DataBaseName
.AllowMultiSelect = False
.Filters.Add ".accdb", "*.accdb", 1 'acrescentar aqui as extensões accde, e accdr
.Show
If .SelectedItems.Count > 0 Then
strFilePath = .SelectedItems(1)
Me.REC_SIS = strFilePath
End If
End With
End Sub
Obrigado