Cmd Button/Link Doc Help

[smbarney]

I need to create a cmd button that lets a user attach a file to record.
I would like it to open a msg box that lets the user select the file to be linked to that record. Please help. Thanks.

 

[RuralGuy]

Maybe this is what you are searching for. Call the standard Windows File Open/Save dialog box

 

[Liv Manto]

I need to create a cmd button that lets a user attach a file to record.
I would like it to open a msg box that lets the user select the file to be linked to that record. Please help. Thanks.

What do you mean attach a file to a record?

insert contents of a file to an existing table OR insert the filename to a field in a record.

You need a dialog box?

You have a form where you have a dialog box, you want to drag the filename to a textbox , press button so it would insert data or filename(?)

 

[smbarney]

Sorry that I was not very clear. I have an OLE Object field called AdjWorkDoc. To this field, I want to link pdf, doc, and text files so that the user can recall this docs as needs be. What I would like is a cmd button that does the same thing as the insert object command and just opens a msg box that lets the user select the file that they want to link to the record (not embed). Thanks.

 

[kev34]

Hi - I appreciate this thread is old but am hoping you still get this... This is exactly what I need and was wondering if you managed to crack this?

Kev