print documents

hi
i have posted here because the other group not moved since this
morning

i have a table that contains file paths to documents
table
fldrecordindex
fldpath

i have a query that returns the records relating to the open report.
what i would like to do is print the documents that are returned


ie report number 205
the query returns 3 results
doc 1
doc 2
doc 3


i would like to print these documents


any ideas how i can do this please


thanks


kevin

Kevin

If you already posted in another newsgroup and haven't seen any response
yet, be awa

* folks here are volunteers
* nobody may have had time
* nobody may know how

If your need is urgent, you might need to seek paid help in a different
venue...

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"kevcar40" wrote in message
...
hi
i have posted here because the other group not moved since this
morning

i have a table that contains file paths to documents
table
fldrecordindex
fldpath

i have a query that returns the records relating to the open report.
what i would like to do is print the documents that are returned


ie report number 205
the query returns 3 results
doc 1
doc 2
doc 3


i would like to print these documents


any ideas how i can do this please


thanks


kevin

On 29 Mar, 20:05, "Jeff Boyce" wrote:
Kevin

If you already posted in another newsgroup and haven't seen any response
yet, be awa

* * folks here are volunteers
* * nobody may have had time
* * nobody may know how

If your need is urgent, you might need to seek paid help in a different
venue...

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"kevcar40" wrote in message

...



hi
i have posted here because the other group not moved since this
morning

i have a table that contains file paths to documents
table
* fldrecordindex
* fldpath

i have a query that returns the records relating to the open report.
what i would like to do is print the documents that are returned

ie report number 205
the query returns 3 results
* * * * *doc 1
* * * * *doc 2
* * * * *doc 3

i would like to print these documents

any ideas how i can do this please

thanks

kevin- Hide quoted text -

- Show quoted text -

i understand that
i thought maybe there was a problem
sorry if i offended

Kevin,

Open Word, turn on the Macro recorder and get the basic code it takes to
print a document.

In Access, you need to create Word automation code to print the documents.
In the automation code you need to create a recordset from the query results
to get the names of the documents you want to print. Your code should
iterate through the names of the document and at each document use the code
you got from the Macro recorder to print the document.

Try www.mvps.org/access. You probably will get something useful there. If
you are truly stuck, contact me - I can help you. I provide help with
Access, Excel and Word applications for a reasonable fee.

Steve



"kevcar40" wrote in message
...
hi
i have posted here because the other group not moved since this
morning

i have a table that contains file paths to documents
table
fldrecordindex
fldpath

i have a query that returns the records relating to the open report.
what i would like to do is print the documents that are returned


ie report number 205
the query returns 3 results
doc 1
doc 2
doc 3


i would like to print these documents


any ideas how i can do this please


thanks


kevin

"Steve" wrote in message
...

If you are truly stuck, contact me - I can help you. I provide help with
Access, Excel and Word applications for a reasonable fee.

Steve




Stevie is our own personal pet troll who is the only one who does not
understand the concept of FREE peer to peer support!
He offers questionable results at unreasonable prices.

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

Please do not feed the trolls.

John... Visio MVP

"Steve" schreef in bericht ...

Try www.mvps.org/access. You probably will get something useful there. If you are truly stuck, contact me - I can help you. I
provide help with Access, Excel and Word applications for a reasonable fee.

Steve



You pretend to be so very helpful... Argghhhh

--
Get lost $teve. Go away... far away....

Again... Get lost $teve. Go away... far away....
No-one wants you here... no-one needs you here...

This newsgroup is meant for FREE help..
No-one wants you here... no-one needs you here...
OP look at http://home.tiscali.nl/arracom/whoissteve.html
(Website has been updated and has a new 'look'... we have passed 11.500 pageloads... it's a shame !!)

Arno R

Kevin,

Printing documents outside of Access requires accessing their print
capabilities. For Office documents, that's possible by using the object
model of the program that you want to print from. For instance my code at:

http://www.datastrat.com/Code/WordMerge.txt

shows how to open a Word template, fill it with data from the current form,
then print it. Similar code can open an existing document and print it.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access

"kevcar40" wrote in message
...
On 29 Mar, 20:05, "Jeff Boyce" wrote:
Kevin

If you already posted in another newsgroup and haven't seen any response
yet, be awa

* folks here are volunteers
* nobody may have had time
* nobody may know how

If your need is urgent, you might need to seek paid help in a different
venue...

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"kevcar40" wrote in message

...



hi
i have posted here because the other group not moved since this
morning

i have a table that contains file paths to documents
table
fldrecordindex
fldpath

i have a query that returns the records relating to the open report.
what i would like to do is print the documents that are returned

ie report number 205
the query returns 3 results
doc 1
doc 2
doc 3

i would like to print these documents

any ideas how i can do this please

thanks

kevin- Hide quoted text -

- Show quoted text -

i understand that
i thought maybe there was a problem
sorry if i offended

On 29 Mrz., 21:10, kevcar40 wrote:

i understand that
i thought maybe there was a problem
sorry if i offended- Zitierten Text ausblenden -
You're welcome.
You might want to try this:

sub PrintDocAndQuit(DocPath as string)
aX = """"
Shell aX & "D:\programme\office97\Office\WINWORD.EXE" & aX & " " & aX
& DocPath & aX + " /q /n /mFilePrintDefault /mFileExit"
end sub

You have to loop through the results of your query and to load DocPath
with the paths of "doc1", "doc2" and so on. The path of Winword you
have to adapt to the real situation and aX is Quote, only needed if in
the paths there are blanks but which is mostly the case.
If printing takes too long you get a message "Word is printing, if you
quit now printing will be aborted" or so. Just wait (except when the
printer is not ready).

"Marco Pagliero" kirjoitti
...
On 29 Mrz., 21:10, kevcar40 wrote:

i understand that
i thought maybe there was a problem
sorry if i offended- Zitierten Text ausblenden -
You're welcome.
You might want to try this:

sub PrintDocAndQuit(DocPath as string)
aX = """"
Shell aX & "D:\programme\office97\Office\WINWORD.EXE" & aX & " " & aX
& DocPath & aX + " /q /n /mFilePrintDefault /mFileExit"
end sub

You have to loop through the results of your query and to load DocPath
with the paths of "doc1", "doc2" and so on. The path of Winword you
have to adapt to the real situation and aX is Quote, only needed if in
the paths there are blanks but which is mostly the case.
If printing takes too long you get a message "Word is printing, if you
quit now printing will be aborted" or so. Just wait (except when the
printer is not ready).