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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subform Nightmare.. 6
Subform Dilemma 2
my autofill won't work ??? 2
Converting access report to PDF in 2007 1
Macro to insert picture from specific folder 0
Two multi-select list boxes 3
Using Several workbooks.... 1
editing .txt with VBA - importing format question 1

Back
Top