Hi All,
How can we attach a file in VBA application using access.
I have a form1 with button placed on it.
On click of button I need to call another form2 from where I need to attach 10 files.
Files can be of type (.doc, .xls,.pdf)
I need to check while attaching the file, the size of file shouldnot be more than 1 MB, also I can open the file after attaching it from form2.
After attaching I need to save all the files in a folder (auto generated folder based on some number from the form1) .
All this I have mention in my enclosed attachment (Requirement).
Please suggest/help how can we do this.
Thanks in advance.
Kumar
How can we attach a file in VBA application using access.
I have a form1 with button placed on it.
On click of button I need to call another form2 from where I need to attach 10 files.
Files can be of type (.doc, .xls,.pdf)
I need to check while attaching the file, the size of file shouldnot be more than 1 MB, also I can open the file after attaching it from form2.
After attaching I need to save all the files in a folder (auto generated folder based on some number from the form1) .
All this I have mention in my enclosed attachment (Requirement).
Please suggest/help how can we do this.
Thanks in advance.
Kumar