Function SelectFile from filedialog

selectfileFunction SelectFile from filedialog

Put this function in the Modules of your access file

Need textbox names text0

Need listbox names List3

Need button names Command2

 

 

Public Function Selectfile() As String
 Dim Fd As FileDialog
 Set Fd = Application.FileDialog(msoFileDialogOpen)
 With Fd
 .AllowMultiSelect = False
 .Title = " Please select file"
 If .Show = True Then
 Selectfile = .SelectedItems(1)
 Me.Text0 = Selectfile
 Me.List3.AddItem (Selectfile)
 Else
 Exit Function
 End If
 Set Fd = Nothing
 End With
 End Function

Call function on click command to open select from

Private Sub Command2_Click()
 Call Selectfile
 End Sub

For consumption of generic soft viagra this drug a proper prescription and knowledge about the drug before in taking it. sildenafil soft Appropriate dosage of Kamagra improves the flow of blood in the genital area intensifying ones sexual hunger, creating a rock hard erection, fortifying stamina and having a healthy and consuming balanced diet. This drug has also been crafted viagra the pill with the potential factors to stimulate the circulation of blood in penis that results in harder erection. Erectile dysfunction generally happens in men as the age development pfizer viagra australia but these days may because of some aspects men in mid 20s & 30s bear from the same.

Related posts