Access Report Issue 1

[ccepaulb]

I am having trouble with one of my reports within an Access Db.
For some reason it is putting a blank page in between the pages with data. The footer still has the correct number of pages, but double show up when previewed or printed.
For example, if I have a 4 page report it will show 8 total pages when printed or viewed but my footer says 1 of 4
Any idea what may be causing this?

Thanks, Paul

 

[LNBruno]

Sounds like you've got the page size (in design) set wider than the actual page? Check your margins, too...

< M!ke >

 

[ccepaulb]

Yes it was a margin issue in the design, the weird thing is that it ran fine for a while and then out of the blue that started happening.

Thanks, Paul

 

[GeekGirlau]

Unless you've recently changed printers, you need to be aware that there is a bug in Access 2000 where reports will lose their page settings.

Have a look at Microsoft's soluion:

http://support.microsoft.com/default.aspx?scid=kb;en-us;240826

 

[ccepaulb]

Thanks Geek
I took your advise and came up with this...
Private Sub ViewDataButton_Click()
Dim rptname As String
Dim qryname As String


Select Case Me.Frame1

Case 1 'Open ItemAcctVoids

qryname = &quot;ItemAcctVoids&quot;
DoCmd.OpenQuery qryname, acViewNormal, acReadOnly


Case 2 'Open ItemAcctVoids

qryname = &quot;ItemAcctVoids2&quot;
DoCmd.OpenQuery qryname, acViewNormal, acReadOnly

End Select
End Sub

It works really good.

two more questions if you don't mind,
1) How do I get the window to maximize when the query is open? I've been trying the following command but it is not working

DoCmd.OpenQuery qryname, acViewNormal, acReadOnly
ActiveWindow.WindowState = xlMaximized
2) I used the same code to open a report but I can't get it to preview the report right (I used acPreview but it is way to small to see) I'd like for the report to open (not send to printer) and enlarge and maximize the window?

Thanks, Paul