
March 8th, 2007, 01:37 PM
|
|
Registered User
|
|
Join Date: Feb 2007
Posts: 2
Time spent in forums: 1 h 4 m 56 sec
Reputation Power: 0
|
|
|
Displaying query by code
Private Sub Command20_Click()
On Error GoTo Err_Command20_Click
Dim stDocName As String
stDocName = "HHC Report"
DoCmd.OpenQuery stDocName, acPreview
Exit_Command20_Click:
Exit Sub
Err_Command20_Click:
MsgBox Err.Description
Resume Exit_Command20_Click
End Sub
So far, so good, but my problem is that this query is one row with a lot of columns - that creates a lot of pages to look through. Is there a command that would loop it around on the same page, or rotate it clockwise so it's going down the page instead of across?
|