MS Access and snp files

P

Pepper

In creating reports, I am outputting in the snp format.

I am trying to figure out a simple way of pointing to the specific
folder and print ALL of the snp files without showing up the "print
box" or asking me 'OK' for each one.


HELP!!!!
 
G

Guest

This Autoprints my Report to the default printer.
DoCmd.OpenReport "reportName", acViewNormal, , , acHidden
 
P

Pepper

In creating reports, I am outputting in the snp format.

I am trying to figure out a simple way of pointing to the specific
folder and print ALL of the snp files without showing up the "print
box" or asking me 'OK' for each one.

HELP!!!!

I think I was not very clear in my request.

I am working with a db that was created by some else.

Time in reporting is very much of an issue and a couple of reports are
very complicated.
I have already "outputted" the snp file to a folder (7+ min). To send
it to a printer would require me to re-run the report and take another
7+ min.

The db resides on a server "somewhere" not local therefore net timing
is also an issue.

What I am looking for is a way to send the snp files already created
in a folder to the printer without any further "reporting".

Am I making any sense?
 
P

Pepper

Check out the VBA help for the OutputTo method.

Steve
I'm not sure how to use this reply feature yet so here goes

I think I was not very clear in my request.

I am working with a db that was created by some else.

Time in reporting is very much of an issue and a couple of reports are
very complicated.
I have already "outputted" the snp file to a folder (7+ min). To send
it to a printer would require me to re-run the report and take another
7+ min.

The db resides on a server "somewhere" not local therefore net timing
is also an issue.

What I am looking for is a way to send the snp files already created
in a folder to the printer without any further "reporting".

Am I making any sense?
 
P

Pepper

This Autoprints my Report to the default printer.
DoCmd.OpenReport "reportName", acViewNormal, , , acHidden
I'm not sure how to use this reply feature yet so here goes

I think I was not very clear in my request.

I am working with a db that was created by some else.

Time in reporting is very much of an issue and a couple of reports are
very complicated.
I have already "outputted" the snp file to a folder (7+ min). To send
it to a printer would require me to re-run the report and take another
7+ min.

The db resides on a server "somewhere" not local therefore net timing
is also an issue.

What I am looking for is a way to send the snp files already created
in a folder to the printer without any further "reporting".

Am I making any sense?
 

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