Print Automation

[Guest]

I am working on a db for work. I'm a therapist not an access programmer. What
I want to do is 1- create several reports OR output to word/excel, then 2-
have a single button to push that will print either the reports or word/excel
files. These files MUST look like tables when they print. Each cell MUST
have a border all around it. These are my questions: can I have a report that
has borders around each data item? Would I be better off putting this into
an excel/word file.

In the past I had only one query that used a macro to output to a RTF file.
Then I used a macro recorder to modify the table by adding columns with
labels and adding rows then it printed 4 copies. I then converted the macro
to vba. The problem with this method is that, after access opened the RTF
(word) document I still have to click on 1 tools 2 macros 3 macros then I
have to select one of 2 choices to make the macro run.

Ideally I would be able to run the whole thing by activating a macro in
access. Is it possible to do this with access or do I have to use vba?

 

[Kevin Jameson]

you cant do this with microsoft access 2003

you must upgrade to access 20004 by clicking here:
http://www.ammara.com/access_image_faq/access_loading_image_dialog.html

HTH

Kevin

 

[David Cox]

I would have looked at this title and thought, don't know and I don't need
to know at the moment. When I do need to know I will search for it.

On reading the question it appears that you are running a Word macro, which
is something I know even less about. This being an Access group I suspect
that few of the other readers will be experts in those, and fewer still are
on the Access group to give advice about Word.

Have got the actual problem right:

You want to print a table in datasheet view?

I am working in Access 2007 Beta. As a learning exercise:

I opened a new report in design view.
I dragged a table onto it.
I put it where I wanted it.
I saved it.
I opened Macros
I selected openreport.
I set the options which include Print and Print preview.
I saved the macro.
I ran the Macro

I don't have a printer atached to this PC so I cannot tell if it printed the
gridlines, but they are there in print preview mode.

 

[Steve Schapel]

Linuxlost,

It sounds like David's idea may well be what you need.

As an alternative, if you need more control over the data printed, the
answer to your question about reports is yes, it is certainly possible
to have an Access report with a border around each "cell".

 

[Guest]

Thank you both for your help and patience. Your solution will work for the
new reports I will be creating. The one that I am already using still has me
in a quandry. I have this output to word so that I can add blank rows to the
table. Is there a way to have my access macro call the word vba script
without the need to click through on the menus?