I am not very much expert in Ms Access but I know the basics of creating a form in it through wizard. I looked in it there are buttons, and there is an option to open directories(or files). As we move through record to record, the target of that button is same, if I want to open different directories(which are written in record) how is that possible through only one button in a form? Please explain me step-by-step.
Thanks.
Dim varItem As Variant 'THIS IS THE VAR TO HOLD THE FILE NAME(S) SELECTED
With Application.FileDialog(msoFileDialogFilePicker)
With .Filters
.Clear
.Add "All Files", "*.*"
End With
.AllowMultiSelect = False
.InitialFileName = Me.txtfolder
.InitialView = msoFileDialogViewDetails
If .Show Then
For Each varItem In .SelectedItems
'DO SOMETHING WITH EACH FILE HERE
Next varItem
End If
End With
