Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Landscape Reports

Landscape Reports

Landscape Reports

Hey all

I have this program that prints
a report in portait style. How do
I change it to print in a landscape

Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset

Private Sub cmdFill_Click()
     Set rs = cn.Execute("Select * from Titles where [Year Published] >= 1996")
     MsgBox "Recordset populated."
End Sub

Private Sub Form_Load()
     Set cn = New ADODB.Connection
     cn.Open "DSN=BIBLIO"
End Sub

Private Sub Form_Unload(Cancel As Integer)
End Sub

Private Sub cmdReport_Click()
     Dim s As String
     s = "Prepared by Abe Froman"

     Set DataReport1.DataSource = rs
     DataReport1.Sections("rptHeader").Controls("lblPerson").Caption = s
End Sub

Deryck Ramsahai

It takes two to lie. One to lie and one to listen.

RE: Landscape Reports

Go to support.microsoft.com/support/kb/articles/Q198/9/01/asp and download PageSet.exe.

I've done this and my reports will display/print in landscape. However, it only works here on an Admin logon. Does anyone know what can cause this? My regular users get an error "The report width is larger than the page size" which must be bogus because the report prints just fine if I'm logged in as myself or Administrator.

I've got an NT network, users running NT 4.0 sp5. I've already given users full access to change print settings on their network printers. Any other ideas?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close