Attaching Files

  • Thread starter Thread starter jen23
  • Start date Start date
J

jen23

Guest
Does anyone know how to create a command button which allows the user to attach a file to a form, somewhat like attaching a file to an e-mail.

The purpose is to allow the user to attach an xray or lab report to a clients consultation form

Any help would be super as I am very stuck

:confused:
 
Check attachment. Hope it helps

Dave.
 

Attachments

Doesnt work for me

oldsoftboss,

Thanks for the attached file, its exatly what i`m looking after too.
However, i have run into a slight problem.
I have pinched the VB code and put into my database, and replaced the .xls part to .doc as i`m after attaching a word document.

however, when I run the code via my command button on the form I get the following message box error.
looks like I have todefine something somewhere, but being a total clueless VBA programmer, eg, not at all, I`m not sure how to fix.

ERROR MESSAGE:
user define type not defines

Any help would be much appreciated.

Thanks in advance

Max
 
Thanks

Oldsoftboss,

Thats exactly what i`m looking for.
Thanks very much for that.

I`ll report back, once I have it implemented in the next day or 2


Max
 
G'day guys,

I'm trying to do a similar thing with insurance details... however these files are usually in a PDF or JPG file.

I've had a play around with the above files myself with little success.
To get the files, I went to a FilePicker and when I try and paste the path (to reference to when moving the file to a local folder) into a text box, I get 'the value you entered isn't valid for this field'.

Am I doing something wrong? Is access unable to refer to external file types which aren't opened within the Office environment?

Thanks!

Scottie.
 
Last edited:
Edit: nevermind, just needed to replace the destination type... it's all so obvious!!!

Now to try and move external files around from a command within access!
 
Last edited:

Users who are viewing this thread

Back
Top Bottom