How can I create macros to open and print a number of documents?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want a macro that opens and prints a whole bunch of documents in a
specified directory. Could anyone help me with that?
 
Dear Ciro:

Is this MS Word documents or what kind of documents are we talking about
and what application are we dealing with? This is a Forum for MS Access
Macros only. If you can let me know what you're trying to do, I can
direct you in what you need to do.

Joe P.


-----Original Message-----
From: Ciro [mailto:[email protected]]
Posted At: Thursday, June 22, 2006 7:59 PM
Posted To: microsoft.public.access.macros
Conversation: How can I create macros to open and print a number of
documents?
Subject: How can I create macros to open and print a number of
documents?

I want a macro that opens and prints a whole bunch of documents in a
specified directory. Could anyone help me with that?
 
I'm talking about MS Access
Everyday I run a query which generates forms to a folder (and later, I have
to click on each form and print them out individually - dozens of them!).

Then I run Access to get reports. Since these reports contains pretty much
all the information on it (even the file name) I thought I could build a
macro in access to print all forms. Is it possible? I much appreciate your
help! Ciro
 
Forgive me if I misunderstand but if you are running the query from within
access, have you tried just writing forms within access and using a macro to
print the results of that query. In the macro simply open each report, print
it athen close it and move on to the next one. I hope I helped.

Mike

Ciro said:
I'm talking about MS Access
Everyday I run a query which generates forms to a folder (and later, I have
to click on each form and print them out individually - dozens of them!).

Then I run Access to get reports. Since these reports contains pretty much
all the information on it (even the file name) I thought I could build a
macro in access to print all forms. Is it possible? I much appreciate your
help! Ciro



Joseph R. Pottschmidt said:
Dear Ciro:

Is this MS Word documents or what kind of documents are we talking about
and what application are we dealing with? This is a Forum for MS Access
Macros only. If you can let me know what you're trying to do, I can
direct you in what you need to do.

Joe P.


-----Original Message-----
From: Ciro [mailto:[email protected]]
Posted At: Thursday, June 22, 2006 7:59 PM
Posted To: microsoft.public.access.macros
Conversation: How can I create macros to open and print a number of
documents?
Subject: How can I create macros to open and print a number of
documents?

I want a macro that opens and prints a whole bunch of documents in a
specified directory. Could anyone help me with that?
Click to expand...
Click to expand...
 
I apologize to the original poster here. However, for some reason I am
unable to post a new thread and my request is somewhat related. I would
appreciate any help from someone to either set this up as a new post or
answer it here.

I have a data access page used to enter info about a given event. The event
# is the primary key so there is only 1 entry for each event. I have
generated a report that displays the needed data for printout after it is
entered. The problem I have is creating a macro that I can place on the data
access page so that once the info has been entered for that event, I can push
one button to have the report for that one event print out. Is there a way
to do this, and if you need more info I would be happy to supply it.

Thank you and I'm sorry again for jumping into an already open thread.

Mike said:
Forgive me if I misunderstand but if you are running the query from within
access, have you tried just writing forms within access and using a macro to
print the results of that query. In the macro simply open each report, print
it athen close it and move on to the next one. I hope I helped.

Mike

Ciro said:
I'm talking about MS Access
Everyday I run a query which generates forms to a folder (and later, I have
to click on each form and print them out individually - dozens of them!).

Then I run Access to get reports. Since these reports contains pretty much
all the information on it (even the file name) I thought I could build a
macro in access to print all forms. Is it possible? I much appreciate your
help! Ciro



Joseph R. Pottschmidt said:
Dear Ciro:

Is this MS Word documents or what kind of documents are we talking about
and what application are we dealing with? This is a Forum for MS Access
Macros only. If you can let me know what you're trying to do, I can
direct you in what you need to do.

Joe P.


-----Original Message-----
From: Ciro [mailto:[email protected]]
Posted At: Thursday, June 22, 2006 7:59 PM
Posted To: microsoft.public.access.macros
Conversation: How can I create macros to open and print a number of
documents?
Subject: How can I create macros to open and print a number of
documents?

I want a macro that opens and prints a whole bunch of documents in a
specified directory. Could anyone help me with that?
Click to expand...
Click to expand...
Click to expand...
 
Dear Bnichols0330:

That I would suggest is that you put an unbounded control on a form and
call the macro to open the report with that information that you are
accessing.

If you need details about how to do this, I would explain.

Hope that helps,

Joe P.


-----Original Message-----
From: bnichols0330 [mailto:[email protected]]
Posted At: Saturday, July 22, 2006 4:36 PM
Posted To: microsoft.public.access.macros
Conversation: How can I create macros to open and print a number of
documents?
Subject: Re: How can I create macros to open and print a number of
document

I apologize to the original poster here. However, for some reason I am
unable to post a new thread and my request is somewhat related. I would

appreciate any help from someone to either set this up as a new post or
answer it here.

I have a data access page used to enter info about a given event. The
event
# is the primary key so there is only 1 entry for each event. I have
generated a report that displays the needed data for printout after it
is
entered. The problem I have is creating a macro that I can place on the
data
access page so that once the info has been entered for that event, I can
push
one button to have the report for that one event print out. Is there a
way
to do this, and if you need more info I would be happy to supply it.

Thank you and I'm sorry again for jumping into an already open thread.

Mike said:
Forgive me if I misunderstand but if you are running the query from within
access, have you tried just writing forms within access and using a macro to
print the results of that query. In the macro simply open each report, print
it athen close it and move on to the next one. I hope I helped.

Mike

Ciro said:
I'm talking about MS Access
Everyday I run a query which generates forms to a folder (and later, I have
to click on each form and print them out individually - dozens of them!).

Then I run Access to get reports. Since these reports contains pretty much
all the information on it (even the file name) I thought I could build a
macro in access to print all forms. Is it possible? I much appreciate your
help! Ciro



Joseph R. Pottschmidt said:
Dear Ciro:

Is this MS Word documents or what kind of documents are we talking about
and what application are we dealing with? This is a Forum for MS Access
Macros only. If you can let me know what you're trying to do, I can
direct you in what you need to do.

Joe P.


-----Original Message-----
From: Ciro [mailto:[email protected]]
Posted At: Thursday, June 22, 2006 7:59 PM
Posted To: microsoft.public.access.macros
Conversation: How can I create macros to open and print a number of
documents?
Subject: How can I create macros to open and print a number of
documents?

I want a macro that opens and prints a whole bunch of documents in a
specified directory. Could anyone help me with that?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top