First 7 characters

  • Thread starter Thread starter NotGood@All
  • Start date Start date
N

NotGood@All

I'm using this code to open a file outside of Access. It finds the document
with this inmates number and opens it, Can this code be modified so it only
looks for the first 7 characters and the .tif extention?

strdoc = "w:\AllInmateRecords\" & Me.[Inmate ID#].Value & ".tif"
 
Thank You Very Much!!!
--
NotGood@All


Douglas J. Steele said:
strdoc = "w:\AllInmateRecords\" & Left(Me.[Inmate ID#].Value, 7) & ".tif"

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


NotGood@All said:
I'm using this code to open a file outside of Access. It finds the
document
with this inmates number and opens it, Can this code be modified so it
only
looks for the first 7 characters and the .tif extention?

strdoc = "w:\AllInmateRecords\" & Me.[Inmate ID#].Value & ".tif"
Click to expand...
Click to expand...
 
Back
Top