Link to feed query

D

Diogo

Hello everyone

Hope to be posting in the correct section.

OK I have a query that returns some records.
One of the fileds that is returned is the path to the image file ex:
"\\VAC\RELEASE\000B8765.TIF"
When I click on it, it opens Windows Picture and Fax Viewer so I can see the
image.
This image contains some lines that OCR software tired to recognize. Those
lines here feed to the master table that I'm quering.

After opening the image I count the number of lines. I them querie the
database to return me the number of lines that have
"\\VAC\RELEASE\000B8765.TIF" in the Image field and then, confirme that all
where correctly recognized.

I'm doing this for some records that for some reason arrose suspicion.

Ok now that I hope to have contextualized you guys where comes my question.

What I need is a quick way to, when I click the link to the Image, that link
is passed to the search parameter of the querie that I use to see the lines
in the database. So that I dont have to copie the path to the file and then
paste it on the next query.

Is this possible in Access?
 
O

orange via AccessMonster.com

Diogo said:
Hello everyone

Hope to be posting in the correct section.

OK I have a query that returns some records.
One of the fileds that is returned is the path to the image file ex:
"\\VAC\RELEASE\000B8765.TIF"
When I click on it, it opens Windows Picture and Fax Viewer so I can see the
image.
This image contains some lines that OCR software tired to recognize. Those
lines here feed to the master table that I'm quering.

After opening the image I count the number of lines. I them querie the
database to return me the number of lines that have
"\\VAC\RELEASE\000B8765.TIF" in the Image field and then, confirme that all
where correctly recognized.

I'm doing this for some records that for some reason arrose suspicion.

Ok now that I hope to have contextualized you guys where comes my question.

What I need is a quick way to, when I click the link to the Image, that link
is passed to the search parameter of the querie that I use to see the lines
in the database. So that I dont have to copie the path to the file and then
paste it on the next query.

Is this possible in Access?
Can you use a form with some vba behind the form? You could save the link and
use the saved link to set up the next record to search for/display.
 

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

Top