how to add an attachment path to a table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

fifi - 14 Dec 2005 20:34 GMT

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?

Reply to this Message

Rick Brandt - 14 Dec 2005 20:41 GMT

> help please
>
[quoted text clipped - 5 lines]
>
> Can somebody please help me with this?

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

How exactly are you copying it to a ListBox?

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

fifi - 15 Dec 2005 20:30 GMT

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

> > help please
> >
[quoted text clipped - 9 lines]
>
> How exactly are you copying it to a ListBox?

Reply to this Message