Batch Print TIF Images - Build Dynamic Shell Statements

[Bob]

I have a query whose results contain the full path (i.e.
c:\Images\xxx.tif) to MUTI-PAGE (All two page) TIF documents.

I need to figure out how to BATCH print the tiff's using the path from
the query results.

I am trying to use the shell command to loop through the query results
and print using IrfanView's command line option.

I have the following code so far but it still isn't doing what I need.

I can't figure out how to get the MyPath variable. MyPath is also the
name of the query field that contains the path to the image.

Dim dbs As DAO.Database
Dim rst As DAO.Recordset

Dim MyPath As String

Set dbs = CurrentDb
Set rst = dbs.OpenRecordset("qryMyPath")

MyPath = rst("MyPath")

While Not rst.EOF And Not rst.BOF
Shell "C:\Program Files\IrfanView\i_view32.exe" & MyPath & " /print",
vbHide
rst.MoveNext
Wend

Can anyone help me figure this out?

Thanks!

[pietlinden]

so you don't know how to get the value from a *field* in your query?

Nothing to it - works the same as accessing a field in a recordset
based on a table.

SomeVariable=rst.Fields("FieldName")

or

SomeVariable = rst.fields(indexNumber)

for example:

SomeVariable= rst.fields(0)

(columns/fields are zero-based).

Does this answer your question? If not, could you restate it? I'm not
entirely sure of what you're asking. Once you have this field, you can
loop through the recordset and build your shell statement...

do until rst.eof
strPath = "C:\" & rst.fields(0) & "\" & rst.fields(1)
'do your shell execute here
rst.movenext
loop