<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2722.900" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=911100519-11032003><FONT face=Arial color=#0000ff size=2><A
href="http://www.mvps.org/Access">http://www.mvps.org/Access</A> has a nice
module that uses API calls to ask the user for a file name.</FONT></SPAN></DIV>
<DIV><SPAN class=911100519-11032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=911100519-11032003><FONT face=Arial color=#0000ff
size=2>Drew</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Hollis,Virginia
[mailto:HollisVJ@pgdp.usec.com]<BR><B>Sent:</B> Tuesday, March 11, 2003 9:56
AM<BR><B>To:</B> 'accessd@databaseadvisors.com'<BR><B>Subject:</B> RE:
[AccessD] Adding Attachments<BR><BR></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=550054615-11032003>Can
you direct me to where I can find information on how to use the Common Dialog
control? I searched help & MS knowledge base, but I could not find
anything that tells how to make it work. I have never used any of the ActiveX
items under More Controls, for that reason - never know what to do with
them.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=550054615-11032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=550054615-11032003>Virginia</SPAN></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Mike and Doris Manning
[mailto:mikedorism@ntelos.net]<BR><B>Sent:</B> Tuesday, March 11, 2003 9:25
AM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> RE:
[AccessD] Adding Attachments<BR><BR></DIV></FONT>
<DIV><SPAN class=123012215-11032003><FONT face=Arial color=#0000ff
size=2>Virginia,</FONT></SPAN></DIV>
<DIV><SPAN class=123012215-11032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=123012215-11032003><FONT face=Arial color=#0000ff
size=2>What I did was use the Common Dialog control (you can also use File
Dialog but it won't work in a runtime app) to allow the user to pick the
current location of the file. Then I move a copy of it into a
designated folder path and store the full pathname (path and file name) in a
database string field.</FONT></SPAN></DIV>
<DIV><SPAN class=123012215-11032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=123012215-11032003>
<DIV align=left><FONT face=Arial size=2>Doris Manning</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Database Administrator</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Hargrove Inc.</FONT></DIV>
<DIV align=left><FONT face=Arial color=#0000ff
size=2><U>www.hargroveinc.com</U></FONT></DIV></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-admin@databaseadvisors.com
[mailto:accessd-admin@databaseadvisors.com] <B>On Behalf Of
</B>Hollis,Virginia<BR><B>Sent:</B> Tuesday, March 11, 2003 10:12
AM<BR><B>To:</B> 'accessd@databaseadvisors.com'<BR><B>Subject:</B> RE:
[AccessD] Adding Attachments<BR><BR></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=850360015-11032003>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=850360015-11032003>Do you know if there is a way to default the
hyperlink to use "relative path to hyperlink"? </SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=850360015-11032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=850360015-11032003>It always wants to use http:\\ for the hyperlink
instead of the path. I set the Base to the directory and folder. I set a
field to Hyperlink, I was hoping that all the customer would have to do is
type the name of the document into the field (Test Attach.doc) and it
would open the hyperlink to the document. Is this correct? What am I
missing?</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=850360015-11032003></SPAN></FONT> </DIV></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=850360015-11032003>************</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=850360015-11032003>The archives only show the past 3 months, how do
you get to the previous messages?</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=850360015-11032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=850360015-11032003>Virginia</SPAN></FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Wortz, Charles
[mailto:CWortz@tea.state.tx.us]<BR><B>Sent:</B> Tuesday, March 11, 2003
8:23 AM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B>
RE: [AccessD] Adding Attachments<BR><BR></DIV></FONT>
<DIV><SPAN class=823161714-11032003><FONT color=#0000ff
size=2>Virginia,</FONT></SPAN></DIV>
<DIV><SPAN class=823161714-11032003><FONT color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=823161714-11032003><FONT color=#0000ff size=2>Since you
are storing the files externally to Access and only storing a link (path
name) to the files in Access, it makes no difference to Access what
types of files they are. Linking to external files is a frequent
subject on this list so you should be able to find a lot of hints in the
archives. Some non-obvious search terms that may help are "Image
files" and "bloat."</FONT></SPAN></DIV>
<DIV> </DIV><!-- Converted from text/rtf format -->
<P><SPAN lang=en-us><B><FONT color=#0000ff>Charles
Wortz</FONT></B></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>Software Development Division</FONT></SPAN> <BR><SPAN
lang=en-us><FONT color=#0000ff>Texas Education Agency</FONT></SPAN>
<BR><SPAN lang=en-us><FONT color=#0000ff>1701 N. Congress
Ave</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>Austin, TX
78701-1494</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>512-463-9493</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>CWortz@tea.state.tx.us</FONT></SPAN> </P>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
Hollis,Virginia [mailto:HollisVJ@pgdp.usec.com] <BR><B>Sent:</B> Tuesday
2003 Mar 11 08:13<BR><B>To:</B>
'accessd@databaseadvisors.com'<BR><B>Subject:</B> RE: [AccessD] Adding
Attachments<BR><BR></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=360580714-11032003>I really do not know what I am after :-) I am
open for any ideas because I sure can't think of
any...</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=360580714-11032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=360580714-11032003>Make a folder to store the attachments and they
would place them in the directory? Would it matter if they were .pdf or
.doc or any type of file?</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=360580714-11032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=360580714-11032003>Virginia</SPAN></FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Wortz, Charles
[mailto:CWortz@tea.state.tx.us]<BR><B>Sent:</B> Tuesday, March 11,
2003 7:59 AM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD] Adding
Attachments<BR><BR></DIV></FONT>
<DIV><SPAN class=426315613-11032003><FONT color=#0000ff
size=2>Virginia,</FONT></SPAN></DIV>
<DIV><SPAN class=426315613-11032003><FONT color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=426315613-11032003><FONT color=#0000ff size=2>You can
have a hyperlink field in a table in which the link to the external
document is placed. Is this what you are
after?</FONT></SPAN></DIV><!-- Converted from text/rtf format -->
<P><SPAN lang=en-us><B><FONT color=#0000ff>Charles
Wortz</FONT></B></SPAN> <BR></P>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
Hollis,Virginia [mailto:HollisVJ@pgdp.usec.com] <BR><B>Sent:</B>
Tuesday 2003 Mar 11 07:51<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> [AccessD] Adding
Attachments<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=830524313-11032003>Is there a
way to add a document as an attachment to a database?
</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=830524313-11032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=830524313-11032003>The database is used to request
services. The data is entered by a customer and sometimes the customer
needs to add additional documentation to support their request. The
attachment might be a sketch or Word file.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=830524313-11032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=830524313-11032003>Does
anyone have any idea how this might be done?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=830524313-11032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=830524313-11032003>Virginia</SPAN></FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>