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 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?

You should be able to use http://www.pacificdb.com.au/MVP/Code/ExeFile.htm to
print each file.

You can use the code found at http://allenbrowne.com/ser-59.html to create a
list of files within a directory.

By combining the two together you should have no problem accomplishing your
task.
--
Hope this helps,

Daniel P






"Pepper" wrote:

> 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 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?
>
>

On Jul 3, 5:12 pm, Daniel <Dan...@discussions.microsoft.com> wrote:
> You should be able to usehttp://www.pacificdb.com.au/MVP/Code/ExeFile.htmto
> print each file.
>
> You can use the code found athttp://allenbrowne.com/ser-59.htmlto create a
> list of files within a directory.
>
> By combining the two together you should have no problem accomplishing your
> task.
> --
> Hope this helps,
>
> Daniel P
>
>
>
> "Pepper" wrote:
> > 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 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?- Hide quoted text -
>
> - Show quoted text -

Daniel, I think that will do the trick. I really appreciate your help.

On Jul 3, 5:12 pm, Daniel <Dan...@discussions.microsoft.com> wrote:
> You should be able to usehttp://www.pacificdb.com.au/MVP/Code/ExeFile.htmto
> print each file.
>
> You can use the code found athttp://allenbrowne.com/ser-59.htmlto create a
> list of files within a directory.
>
> By combining the two together you should have no problem accomplishing your
> task.
> --
> Hope this helps,
>
> Daniel P
>
>
>
> "Pepper" wrote:
> > 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 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?- Hide quoted text -
>
> - Show quoted text -

I am at a loss, I cannot get eith to work. Is there any help?????