How can I determine the number of pages are going to printed before the printing starts? In other words, I want to insert into a document:

Page 1 of "total number of pages printing" , but I don't know ahead of time the total number of pages to be printed.

Thanks!

You can speed up the script by putting a Freeze Window step at the beginning.

Boy, I don't know how many times I wish that there was a "Status(LastPageNumber)" calculation in FileMaker!

Anyway, here's a real kludge that will get you what you want:

create a Global field [number] to capture the last page. Then create a script something like this:

Go to Layout [YourPrintLayout]

Enter Preview Mode

Go to Record/Request/Page [Last]

Set Field[ gLastPage, Status(CurrentPageNumber)]

Enter Browse Mode

You can then use the data from the [gLastPage] field for your last page number.

The down side of this is = if there are a lot of records, and/or if the layout has a lot of elements on it, this script can take a while to run, but it will get you the last page number.

[ April 12, 2001: Message edited by: dykstrl ]

Just to keep things in perspective, Filemaker can't possibly know how many pages there are going to be until it generates the pages for the found set which is exactly what you do when you go to preview mode and then to the last page. So, you can't really expect any other method or built-in function to be significantly faster.