Attaching files of different types to table field thru VBA

vtrm

Registered User.
Local time
Today, 22:38
Joined
Jun 8, 2005
Messages
21
Hi Everyone,

I have a PO table. Each PO has 3 documents of multiple types (one may be Word, other may be Excel, Acrobat). When I display the PO, the attachments should be shown as Icons, which when double-clicked, will open in its own Application.

I have a pop-up screen where I enter new PO details. In this screen, I have Attach/Detach buttons for each of the Documents.

My Requirement:
When I press 'ATTACH' of Doc1, the File Selection screen should be displayed from where the user will select the file to be attached. This file should be updated into the table field "doc1".

When I press 'DETACH' of Doc1, the file in table field "doc1" must be cleared.

How can I achieve this???:mad:
 

Users who are viewing this thread

Back
Top Bottom