Drag and drop and show file name only.

[josros60]

I have this code works fine, but when sending invoices will be easier to drag and drop the files being attached into a textbox because i use two monitors, also if just show the files names instead of folder in the textbox.

is it possible?

here it's the code:

Private Sub btnBrowse_Click()
    Dim fileDiag As FileDialog
    
    Dim strFile As String
    Dim strFolder As String
    Dim file As Variant
    
    Set fileDiag = FileDialog(msoFileDialogFilePicker)
    
    fileDiag.AllowMultiSelect = True
    If fileDiag.Show Then
        For Each file In fileDiag.SelectedItems
            Me.txtAttachment = file
        Next
    End If

End Sub

thanks

 

[josros60]

any help please.

 

[GinaWhipp]

Hmm, not sure what you are asking because you can't drag a file from Explorer and drop it into a Control on your Form but actually you would not have to. If you are sending eMail you can just include that path in the Attachments section.

 

[sneuberg]

You are probably not getting any responses because this is outside what you can normally do in Access. If you goggle "MS Access drag and drop" about the only thing that come up as a possibility is using a ListView Control. This doesn't look easy.

 

[shadow9449]

The description of the question is not quite clear. However, Jack Leach created this awesome demo that I was able to modify for my own needs and incorporate in my projects: http://www.utteraccess.com/forum/index.php?showtopic=1973842

I used version 2.

This should be able to steer you.

SHADOW