in ms access reports i want to preview 2 pages 1

[IGPCS]

i have a form that has a command button that lets me preview a report but the report is always 2 pages and i want it should be in multipages view is it possible to setit up that way?

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY

 

[IGPCS]

did anyone saw this and really wants to help me

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY

 

[ZmrAbdulla]

Private Sub Command0_Click()
On Error GoTo Err_Command0_Click

    Dim stDocName As String

    stDocName = "Schedule"
    DoCmd.OpenReport stDocName, acPreview

    [b]DoCmd.RunCommand acCmdPreviewTwoPages[/b]


Exit_Command0_Click:
    Exit Sub

Err_Command0_Click:
    MsgBox Err.Description
    Resume Exit_Command0_Click
    
End Sub

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[IGPCS]

thank you totaly forgot about that


thank you

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY

 

[njonsie]

another easy way is to right click on the report and select the number of pages you'd like to view. v.2003 and newer atleast will let you do this.




Nathan

 

[IGPCS]

yes thanks that i know but i dont want my users to do so i want it should appear auto for my users because there are people who are suppose to use this and they dont know anything about using a program just know how to populate the form into a ticket and print them

thanks for your reply

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY