Saving document in table

  • Thread starter Thread starter Niklas Östergren
  • Start date Start date
N

Niklas Östergren

I´d like to save dokuments (word, excell, pictures) which was atteched to
e-mail that was dispatched to our members. I also save the message which was
put in to the e-mail.

Is there a way to nicely add dokuments from HD in to the table via a form?
Or how shall this be done?

I have saved dokuments in tables before, a couple of times, but not through
a userfriendly way but directly in the tables. But this is not what I want
the users to do!

TIA!
// Niklas
 
It usually works better to save your documents in separate files, and have a
field or fields in your database which contain the path/filename to the
document.

HTH
= Turtle
 
OK!

And then the path/filename saved as a hyperlink, or?
How do I do then when I want to attache the files with a e-mail that´s
created from Access?

I have read about how to create an e-mail and I will implement it a little
later. But I have never done it. So how about the attached files?

And how do I do with photos of our members which I whant to display in a
form together with that persons data? I know that pictures uses a lot of
memory and that I therefore should save these in a seperat db. Is it just to
link the field in the form to the table in the PictureDb using linked
tables, or?


TIA
// Niklas
 
Well, you could save it as a hyperlink, but I tend to just use a string.
If it's a picture you're displaying, you can use the Picture property of an
image control.
For a word doc or pdf, you'd need an unbound object frame to display it.
There are articles in the MS Knowledge Base which describe these techniques.

You can create an e-mail in Access and send it using the SendObject command,
but you cannot attach an external file to it.
Probably the easiest way to do that is to automate Outlook, if you are sure
that will be present on your clients' PCs.

I would save each photo in a separate file (e.g. jpg), rather than using a
separate database.

HTH
- Turtle
 
Thanks a lot MacDermott for your answer!

I was a little bit dissapointed tough that it´s not possible to attache
external files since I´d like to store information about what´s been sent to
who in the member database. Not neccesary the attached files but at least
the path and filename. Anyway that´s the way it is so I have to live with
that... ;-)

About the pictures:
"I would save each photo in a separate file (e.g. jpg), rather than using a
separate database"

- If you save the photos as a seperat jpg (for instance) in a seperat photot
map. How do you refere to them in you form to be displayed in your control?
Is it possible ti link the control to a external file?

TIA
// Niklas
 
Assuming you are only displaying one image at a time (single form view), put
an image control (MyImage) on your form where you want the image displayed.
Let's say you're saving the path/filename in a field named MyPath.
In the Form's Current event, put code like this:
MyImage.Picture=MyPath
That should display the picture.

Please note that I didn't say it's impossible to attach external files using
Access.
It's not possible to do this using SendObject, but there are ways to do it.
It just takes more advanced programming.
A Google search will probably find you lots of entries.

HTH
- Turtle
 
Hi again!

Ok, thats simple enough for me, so fare! I´ll search for attaching external
files later on. I´m not quit there yet!

Thank´s again and have a nice weekend (I will!)

// Niklas
 
Back
Top