Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Me.pages on report gives 0

Status
Not open for further replies.
Mar 27, 2002
168
NL

I Think the problem of me.pages = 0 becomes while the pages are not formatted at the moment the procedure below is running. My question: which procedure to use to kill this problem
thnx in advance,
gerard
Private Sub Report_Activate()
'function for confirmation, gives as parameter the pages of the report, standing to 0
If Bevestigen("U staat op het punt om een overzicht van alle stalen uit te draaien." & vbNewLine & _
"Dit overzicht bevat " & Me.Pages & " pagina's. Weet u zeker dat u het document wilt uitdraaien?") Then
DoCmd.PrintOut
DoCmd.Close acReport, Me.Name
Else
'other code for looking a preview or close the report
If Not Bevestigen("Wilt u een afdrukvoorbeeld bekijken?") Then
DoCmd.Close acReport, Me.Name
End If
End If
End Sub
 
did you ever solve this problem? I'm running into it at the moment, and I'm stumped.

thanks,

J
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top