gstylianou
Registered User.
- Local time
- Today, 23:56
- Joined
- Dec 16, 2013
- Messages
- 357
Dear friends,
I have the following simple code which working fine in order to read any external files into an access form. But, the problem is the confirmation message after the selection of the file (attached). Is there a way to skip the confirmation after the selection of the file?
The code:
Option Compare Database
Option Explicit
Private Sub btnBrowse_Click()
Dim file As FileDialog
Set file = Application.FileDialog(msoFileDialogFilePicker)
file.AllowMultiSelect = False
If file.Show Then
Me.txtFileLocation = file.SelectedItems.item(1)
End If
End Sub
I have the following simple code which working fine in order to read any external files into an access form. But, the problem is the confirmation message after the selection of the file (attached). Is there a way to skip the confirmation after the selection of the file?
The code:
Option Compare Database
Option Explicit
Private Sub btnBrowse_Click()
Dim file As FileDialog
Set file = Application.FileDialog(msoFileDialogFilePicker)
file.AllowMultiSelect = False
If file.Show Then
Me.txtFileLocation = file.SelectedItems.item(1)
End If
End Sub