Report Page Count or Something Similar?

[Manged]

Is there any way to count the number of pages in an Access 2007 report in VBA? All i want to do is keep the user from printing the report if it is more than 1 page. Or, something like .GoToPage 2 for a report would work as long as it gives an error if there isnt a second page.

 

[guitarzan]

Repost in the VBA forum here: forum707

 

[dilettante]

VBA is not VB. I have no idea why people do this so often here.

 

[guitarzan]

dilettante,

This forum is called "Visual Basic(Microsoft): Version 5 & 6 Forum"

Now, go to the Visual Basic Editor in MS Word for example, and go to Help > About. In Word 2003 anyway, it says "Microsoft Visual Basic 5.6"

This is a big part of the problem.

 

[strongm]

And at the bottomn of that same dialog, it tells you that it is VBA ...

 

[SkipVought]

Really, this is MS Access VBA forum705.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[guitarzan]

strongm,

It sure does, but Microsoft sticking that in at the bottom doesn't really clear it up much (IMO), especially if you are fairly new to it, and only have familiarity with VBA and not VB.

Of course, those who use both VB and VBA and still don't understand the difference...