Add a photo link if the photo exists

• smac

  SSC Eights!

  Points: 855

  More actions

  May 4, 2011 at 5:56 am

  #239547

  Currently I am builiding a photo link based on some static information and field information,

  i.e. photoLink = "\\server\gearimages\" & partNo & "\" & machineNo & "\" & serialNo & ".jpg"

  Problem is if the photo does not exist for one reason or another then the link is useless.

  How do I confirm the photo exists and then add the link to the table?

  I was thinking some how in a script task or a for each loop?

  Thanks.

• Phil Parkin

  SSC Guru

  Points: 246993

  More actions

  May 4, 2011 at 6:28 am

  #1319689

  That's going to be slow if there are a lot of records, but a loop will work well enough.

  Have you thought about modifying the software which is displaying the link to perform the check at run time instead?

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel