<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 10 (filtered)">
<title>Message</title>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
h2
{margin-top:12.0pt;
margin-right:0cm;
margin-bottom:3.0pt;
margin-left:0cm;
page-break-after:avoid;
font-size:14.0pt;
font-family:Arial;
font-weight:bold;
font-style:italic;}
h3
{margin-top:12.0pt;
margin-right:0cm;
margin-bottom:3.0pt;
margin-left:0cm;
page-break-after:avoid;
font-size:13.0pt;
font-family:Arial;
font-weight:bold;}
h4
{margin-top:3.0pt;
margin-right:0cm;
margin-bottom:3.0pt;
margin-left:0cm;
page-break-after:avoid;
font-size:12.0pt;
font-family:Arial;
font-weight:bold;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p
{margin-right:0cm;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
p.Code, li.Code, div.Code
{margin-top:6.0pt;
margin-right:0cm;
margin-bottom:6.0pt;
margin-left:17.85pt;
punctuation-wrap:simple;
text-autospace:none;
font-size:12.0pt;
font-family:"Courier New";}
span.EmailStyle19
{font-family:Arial;
color:navy;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>You don’t need to use URLs if you
don’t want to. I use code from ADH that calls the Windows API to open the
GetFile dialog, then posts the result to a control on my form, like so:</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> With Me</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>
.BigImagePath = ahtCommonFileOpenSave()</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> End With</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>To cohere to the licensing I cannot post
said function or its API declaration. Of course I could change all the variable
names and the function name and claim it as my own work, which is how I learned
to program, but now that I’m an old fart I don’t do that any more.</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>(Fuller’s Law #3: You start out a
Young Turk and before you know it you’re an Old Fart.)</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>The function called above returns an absolute
path, but given same and knowledge of the app directory, it’s a simple
matter to replace the app path with a relative reference. The Replace function
does it in one line:</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> Replace( strExp as String,
strFind as String, strReplace as String )</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>HTH,</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>A.</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>-----Original Message-----<br>
<b><span style='font-weight:bold'>From:</span></b>
accessd-admin@databaseadvisors.com [mailto:accessd-admin@databaseadvisors.com] <b><span
style='font-weight:bold'>On Behalf Of </span></b></span></font><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>Hollis</span></font><font
size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>,</span></font><font
size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>Virginia</span></font><font
size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'><br>
<b><span style='font-weight:bold'>Sent:</span></b> </span></font><font size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>March 11, 2003</span></font><font
size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> </span></font><font size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>10:12 AM</span></font><font
size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'><br>
<b><span style='font-weight:bold'>To:</span></b> 'accessd@databaseadvisors.com'<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [AccessD] Adding
Attachments</span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> </span></font></p>
<div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'>Do you
know if there is a way to default the hyperlink to use "relative path to
hyperlink"? </span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'> </span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'>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></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'> </span></font></p>
</div>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'>************</span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'>The
archives only show the past 3 months, how do you get to the previous messages?</span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> </span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'>Virginia</span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> </span></font></p>
</div>
<blockquote style='margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt'>
<p class=MsoNormal style='margin-right:0cm;margin-bottom:12.0pt;margin-left:
36.0pt'><font size=2 face=Tahoma><span style='font-size:10.0pt;font-family:
Tahoma'>-----Original Message-----<br>
<b><span style='font-weight:bold'>From:</span></b> Wortz, Charles
[mailto:CWortz@tea.state.tx.us]<br>
<b><span style='font-weight:bold'>Sent:</span></b> Tuesday, March 11, 2003 8:23
AM<br>
<b><span style='font-weight:bold'>To:</span></b> accessd@databaseadvisors.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [AccessD] Adding
Attachments</span></font></p>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face="Times New Roman"><span style='font-size:10.0pt;color:blue'>Virginia,</span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> </span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face="Times New Roman"><span style='font-size:10.0pt;color:blue'>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."</span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> </span></font></p>
</div>
<!-- Converted from text/rtf format -->
<p style='margin-left:36.0pt'><b><font size=3 color=blue face="Times New Roman"><span
style='font-size:12.0pt;color:blue;font-weight:bold'>Charles Wortz</span></font></b>
<br>
<font color=blue><span style='color:blue'>Software Development Division</span></font>
<br>
<font color=blue><span style='color:blue'>Texas Education Agency</span></font> <br>
<font color=blue><span style='color:blue'>1701 N. Congress Ave</span></font> <br>
<font color=blue><span style='color:blue'>Austin, TX 78701-1494</span></font> <br>
<font color=blue><span style='color:blue'>512-463-9493</span></font> <br>
<font color=blue><span style='color:blue'>CWortz@tea.state.tx.us</span></font> </p>
<p class=MsoNormal style='margin-right:0cm;margin-bottom:12.0pt;margin-left:
36.0pt'><font size=2 face=Tahoma><span style='font-size:10.0pt;font-family:
Tahoma'>-----Original Message-----<br>
<b><span style='font-weight:bold'>From:</span></b> Hollis,Virginia
[mailto:HollisVJ@pgdp.usec.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Tuesday 2003 Mar 11 08:13<br>
<b><span style='font-weight:bold'>To:</span></b> 'accessd@databaseadvisors.com'<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [AccessD] Adding
Attachments</span></font></p>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'>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></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> </span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'>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></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> </span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'>Virginia</span></font></p>
</div>
<blockquote style='margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt'>
<p class=MsoNormal style='margin-right:0cm;margin-bottom:12.0pt;margin-left:
36.0pt'><font size=2 face=Tahoma><span style='font-size:10.0pt;font-family:
Tahoma'>-----Original Message-----<br>
<b><span style='font-weight:bold'>From:</span></b> Wortz, Charles [mailto:CWortz@tea.state.tx.us]<br>
<b><span style='font-weight:bold'>Sent:</span></b> Tuesday, March 11, 2003 7:59
AM<br>
<b><span style='font-weight:bold'>To:</span></b> accessd@databaseadvisors.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [AccessD] Adding
Attachments</span></font></p>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face="Times New Roman"><span style='font-size:10.0pt;color:blue'>Virginia,</span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> </span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 color=blue
face="Times New Roman"><span style='font-size:10.0pt;color:blue'>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?</span></font></p>
</div>
<!-- Converted from text/rtf format -->
<p style='margin-left:36.0pt'><b><font size=3 color=blue face="Times New Roman"><span
style='font-size:12.0pt;color:blue;font-weight:bold'>Charles Wortz</span></font></b>
</p>
<p class=MsoNormal style='margin-right:0cm;margin-bottom:12.0pt;margin-left:
36.0pt'><font size=2 face=Tahoma><span style='font-size:10.0pt;font-family:
Tahoma'>-----Original Message-----<br>
<b><span style='font-weight:bold'>From:</span></b> Hollis,Virginia
[mailto:HollisVJ@pgdp.usec.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Tuesday 2003 Mar 11 07:51<br>
<b><span style='font-weight:bold'>To:</span></b> accessd@databaseadvisors.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> [AccessD] Adding
Attachments</span></font></p>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Is there a way to add a document as
an attachment to a database? </span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> </span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>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></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> </span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Does anyone have any idea how this
might be done?</span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> </span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Virginia</span></font></p>
</div>
</blockquote>
</blockquote>
</div>
</body>
</html>