Print Automation linuxlost 19.09.2006 00:36:01 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?

Re: Print Automation "David Cox" <davidfcox[ at ]ntlworld.com> 20.09.2006 15:25:18 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. "linuxlost" <linuxlost[ at ]discussions.microsoft.com> wrote in message news:C2D5BBB3-3788-4022-AB68-9806C28829C3[ at ]microsoft.com... [Quoted Text] >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?

Re: Print Automation Steve Schapel <schapel[ at ]mvps.org.ns> 20.09.2006 19:19:11 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". -- Steve Schapel, Microsoft Access MVP David Cox wrote: [Quoted Text] >... > 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.

RE: Print Automation linuxlost 21.09.2006 04:35:02 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? "linuxlost" wrote: [Quoted Text] > 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?