<!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;
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;
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;
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";}
p.code0, li.code0, div.code0
{margin-top:6.0pt;
margin-right:0cm;
margin-bottom:6.0pt;
margin-left:17.85pt;
punctuation-wrap:simple;
font-size:12.0pt;
font-family:"Courier New";}
span.emailstyle19
{font-family:Arial;
color:navy;}
span.EmailStyle21
{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'>On my forms I have the text field beside a
little button whose text is just 3 dots. The OnClick fires the code I posted.
The user navigates to a file and selects ok, then the code plugs the complete
filename into the text field (in this case BigImagePath).</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>Hollis,Virginia<br>
<b><span style='font-weight:bold'>Sent:</span></b> March 11, 2003 12:34 PM<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>
<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'>Ok, I
found Sub TestGetFileName() in ADH.</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'>You
mentioned posting the results to a control. Do I need to have a button on the
form that opens the GetFileName? Then what transfers this file name to the
field?</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> Arthur Fuller
[mailto:artful@rogers.com]<br>
<b><span style='font-weight:bold'>Sent:</span></b> Tuesday, March 11, 2003
10:20 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>
<p class=MsoNormal style='margin-left:36.0pt'><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 style='margin-left:36.0pt'><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 color=navy
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>
With Me</span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><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 style='margin-left:36.0pt'><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 style='margin-left:36.0pt'><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 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 style='margin-left:36.0pt'><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 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 style='margin-left:36.0pt'><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 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 style='margin-left:36.0pt'><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 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 style='margin-left:36.0pt'><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 color=navy
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>HTH,</span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><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 style='margin-left:36.0pt'><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 color=navy
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal style='margin-left:72.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>Hollis,Virginia<br>
<b><span style='font-weight:bold'>Sent:</span></b> March 11, 2003 10:12 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>
<p class=MsoNormal style='margin-left:72.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:72.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:72.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:72.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:72.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:72.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:72.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:72.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:72.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:72.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:
72.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:72.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:72.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:72.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:72.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:72.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:
72.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:72.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:72.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:72.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:72.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:72.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:
72.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:72.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:72.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:72.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:72.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:
72.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:72.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:72.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:72.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:72.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:72.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:72.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:72.0pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Virginia</span></font></p>
</div>
</blockquote>
</blockquote>
</blockquote>
</div>
</body>
</html>