how to add an attachment path to a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

help please

I have a button that let me choose a file to attach to a form. Once
attached, the attachment file is copied to a list boxt on the form. Now when
I click the submit button, all the information is saved on a table except the
attachment path. I need that saved, so I can keep track of what file was
attached to what record.

Can somebody please help me with this?
 
fifi said:
help please

I have a button that let me choose a file to attach to a form. Once
attached, the attachment file is copied to a list boxt on the form. Now when
I click the submit button, all the information is saved on a table except the
attachment path. I need that saved, so I can keep track of what file was
attached to what record.

Can somebody please help me with this?
Click to expand...

Copy the path into a control that is bound to a field in your table.

How exactly are you copying it to a ListBox?
 
This is the part that adds the attachment path to the list box
Now my problem is how to add it to a table. If I can only add the first one
that will be good

thank you
If .Show = True Then
' Loop through each file that is selected and then add it to the
list box.
For Each varFile In .SelectedItems
Me.FileList.AddItem varFile

Next
'Else
' MsgBox "You clicked Cancel in the file dialog box."
End If
End With
 
Back
Top