Re: Linked Object property

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: John Nurick (j.mapSoN.nurick_at_dial.pipex.com)
Date: 07/30/04 

Date: Fri, 30 Jul 2004 19:47:33 +0100

Hi Pete,

In general it's best not to store documents in OLE fields (linked or
otherwise). Instead, leave the PDF files in their folders, and just
store their names and locations in the database. When you want to open
one, you can do it with a button on the form and something like this in
its Click event procedure, where txtPath and txtFileName are textboxes
on the form containing the directory and name of the file:

        Dim strFileSpec As String
        
        strFileSpec = Me.txtPath.Value & "\" & Me.txtFileName.Value
        Application.FollowHyperlink strFileSpec

On Fri, 30 Jul 2004 02:53:03 -0700, Pete.C
<Pete.C@discussions.microsoft.com> wrote:

>I am trying to link a .pdf file to a form where the
pdf file name is relative to a filed name on the form. The simplke
solution seems to be to pass the file name into the 'Source Doc'
property of the linked object, but it doesn't seem to want to accept it.
>
>Any suggestions on how to overcome this please? 

--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
Quantcast