Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    5

    Question Unanswered: Path question this time!?

    Hello again

    I have got the report to include the images, but is there a way to set a relative path?

    Ie. \pictures\img.gif rather than c:\db\pictures\img.gif

    At the moment I am using:

    Dim imagefile As String

    Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)

    imagefile = "c:\db\pictures\" & Image_URL & ".gif"

    If Dir(imagefile) <> "" Then
    FileExists = True
    Else
    FileExists = False
    End If


    If FileExists Then
    Me![Image].Picture = imagefile
    Else
    Me![Image].Picture = "c:\db\pictures\blank.gif"
    End If

    End Sub

  2. #2
    Join Date
    Jul 2002
    Location
    Australia
    Posts
    147
    Where is it relative to though... How does the database know what drive etc to look at?

    Cheers,
    Andrew
    There have been many posts made throughout the world.
    This was one of them.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •