Character recognition and hyperlinking

[JTQ911]

I was wondering if its possible to.... In my business, we test electronic components. When one fails, it gets documented as a test error, and the document is named TE-XXXX YYY where XXXX is a four digit number and YYY is a code of some sort. is it possible that in a table, When TE-XXXX YYY is entered, it only recognizes "TE-XXXX" which hyperlinks to microsoft word document in a folder that gives more information about the test error. Thanks in advance!

 

[CraigDolphin]

Are you wanting to truncate the code (delete the yyy part in the table) or just be able to query based on the TE-XXXX part?

If the latter, simply query your table and instead of using [CodeFieldName] put
ShortCodeField: Left([CodeFieldName],7)

Then use your query as the source for whatever form control you use to link to the document. Search on how to perform the mechanics of opening a word document from within Access if you do not know how.

 

[JTQ911]

Simple query the table and put in ShortCodeField: Left([CodeFieldName],7) where do i put that in???

 

[CraigDolphin]

Make a new query in design view.
Add your table to the query.
Drag all the fields in your table to the query grid.
For the field that contains your code (aka CodeFieldName) replace the field heading 'CodeFieldName' with ShortCodeField: Left([CodeFieldName],7) making sure to substitute the actual name of your field for 'CodeFieldName'.

Save and run the query.