Click the Find Icon in the Status Bar at the top of the screen.
Select Yes in your Print Card field.
Click Perform Find
Now select the layout you will use to print labels. This is almost always a custom layout that you design specifically for printing labels of a specific kind and (often) on a specific printer. (You may or maynot be able to use the same layout for different printers).
Select Print from the File Menu and use the "Records being browsed" option to print the labels.
Thanks for the quick reply PhilModJunk, that method would be fine to use if the ladies in the office were more computer literate but unfortunately they are not. Most of them are retired ladies that volunteer at the base in the office. Is there any way of doing it automatically, and if so how and where would it be done.
Do you know how to create a script?
All of these steps can be automated with script steps and you can put a button on your layout that performs the script you create.
On what kind of label page do you want to print your labels?
If the desired page has an Avery number, it's easier to set up by far.
By the way, doing the "manual" steps aren't all that complicated even for non-computer literate users to follow after they've done it once or twice.
G'day PhilModJunk, no I don't know how to write scripts properly, am very new to this and need all the help I can get, as for the label it is an Avery address label but it is not listed on filemmaker, I had to enter the measurement in, they print out very good all in the write spot, so I could do with your help in making a script. I know how to put a button on a layout and link it to a script just don't know as yet how to create a script
Here's an example to work from, you'll need to refer to your own tables, fields and layouts in place of the names I use here:
//Text after double slashes are not part of the script, they give you additional direction on how to create the script.
Select Manage Scripts... from the scripts menu
Click the new button to start a new script
Add the following script steps in this script editor dialog:
Go To Layout [Your label layout]//select it by name from the drop down in bottom right corner
Enter Find Mode //clear the pause check box
Set Field [YourTable:: Print Card; "Yes"]
Set Error capture [on]
If [get (Foundcount) = 0 /* no records were found */]//Double click step to open dialog where you can enter expression between the brackets
Show Custom Dialog ["No records were found"]
Enter Preview Mode [pause]
Go To Layout [original layout]
This script previews the label report showing all records found. At this point you can print the labels by selecting print from the file menu with the records being browsed option selected in print dialog. This pause gives the user the chance to confirm that they are getting the labels they want to load label pages into the printer before printing. The user continues the script by either pressing the enter key (on the number key pad) or by clicking the continue button in the status area at the top of the screen.
Many new users get confused the first time they try to add Set Field to a script. See the following link for step by step instructions:
Selecting an "All" option with checkboxes