R
RICHARD ALLISON
I need help getting started.
I have an access report that needs to be printed in booklet format. Publisher does this real nice.
Today I create the report in Access, publish it to Word, format it in Word, copy a paste it into Publisher, modify it in publisher and print it. All manual. I'd like to automate it with a push of a button.
With the advent of VBA in publisher in 2003 I'm thinking I could take the report directly from Access into Publisher.
Where do I look to understand how to do this? Where do I look to find out how to control Word from Access and Publisher from Access.
This might be the wrong group but I started here because I'm working with an Access report. If there is a better group for this question, please direct me there.
Thanks,
I have an access report that needs to be printed in booklet format. Publisher does this real nice.
Today I create the report in Access, publish it to Word, format it in Word, copy a paste it into Publisher, modify it in publisher and print it. All manual. I'd like to automate it with a push of a button.
With the advent of VBA in publisher in 2003 I'm thinking I could take the report directly from Access into Publisher.
Where do I look to understand how to do this? Where do I look to find out how to control Word from Access and Publisher from Access.
This might be the wrong group but I started here because I'm working with an Access report. If there is a better group for this question, please direct me there.
Thanks,