I have set up a script that enters preview mode and brings up the prints and brings the user back to the original layout. This is exactly what i want to do however everytime the print script is called it prints EVERY record instead of the current record which is what I need it to do. I could potentially have the dialog come up and have the users choose Print page 1 to 1, but my coworkers aren't that computer literate and this could be a fatal mistake seeing as we will have hundreds of records in this database. How can I fix this problem? Thanks.

-Shana

1. Print, and set it to print the current record

2. Create a script: Page Setup (Restore, no dialog)

3. Call this script from within any script that you would like to print the current record.

Experienced developers generally create at least four page setup scripts: Tall One, Wide One, Tall Many, Wide Many. These are just single-line scripts that do a Page Setup and are called from within any script that prints. That way, if you ever need to adjust the page setup, you don't have to go through every script that prints, you just change your page setup scripts.

Page setup doesn't work. The page setup function on our printers here at work just selects which printer you are using not how many pages you wwant to print.

To further add to what Fitch said, pop up the print dialog box once and make sure that you select Current Record, then print. Then go to your script and make sure the Page Setup step is in your script. When you close the script, make sure you select Replace for the page setup selection.

HTH, Mike

That worked!

Thanks!

Or, run these script steps...

Show All Records

Omit

Show Omitted

<print stuff>

Show All Records

The only problem is the current found set and sort is lost.