Re: Print Access report along with an outside checklist

The PrintOut method has page range option and applies to the active object.
So, open the report and run:

DoCmd.Printout acPageRange, 1,2

See Access Help.

Bonnie



Dennis wrote:
Bonnie,

Cool idea, but let me ask this question.

As I understand this solution, the Excel printout will be a sepaate spooler
file that prints independently of the main report. That is, I'm going to
guess that the Excel spread sheets will print first and the then complete
access report will print.

Someone will have to manually colate the excel print out with the access
parts tickes.

Maybe I'm way off base but I'm guessin that Gabby would like to print a part
tickets and then immediately print the excell check list. That way manually
collation of the two different reports would be minimized.

Is there any way to print a page in Access and close that spool file, which
will cause that page to be printed, run the excel shell to print the
spreadsheet, and then open a new spool file for the next page, and repeat the
process again?

I ask this question, because I have a similar issue.

Thanks

Dennis

Hi Gabby,

[quoted text clipped - 32 lines]

Thanks

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/201003/1

.

Relevant Pages

  • Re: why>?
    ... Just because PDF is more popular than SNP; ... Emailing a dynamic report is easier than emailing PDF files.. ... Excel is ALWAYS less efficient than Access. ... e) multi-user functionality - being able to work on the same report / ...
    (microsoft.public.excel)
  • Re: Need Resource Group in Visual Reports
    ... Because the machine I use with Project 2007 doesn't have Excel 2003 ... showing the same information as the Visual Report in Excel. ... When you said:"I've saved the resource usage cube and transferred ...
    (microsoft.public.project)
  • Re: BCWP and BCWS
    ... Were you able to add the Tasks to Row labels in Excel? ... Report Filter, add to ROW Labels and Add to Column Labels. ... editing the report and inserting Actual Costs, Tacks AC, Task ... calculates actual duration and remaining duration. ...
    (microsoft.public.project)
  • RE: Get parameter dates in heading
    ... sheet but it creats a new report and the alignment gets all messed up ... It actuall creates a new Excel spreadsheet. ... Dim varGetFileName As Variant 'File Name with Full Path ... Dim strLeftRange As String 'Used to format range references ...
    (microsoft.public.access.externaldata)
  • RE: Get parameter dates in heading
    ... sheet but it creats a new report and the alignment gets all messed up ... It actuall creates a new Excel spreadsheet. ... Dim varGetFileName As Variant 'File Name with Full Path ... Dim strLeftRange As String 'Used to format range references ...
    (microsoft.public.access.externaldata)