Find certain Number of Records / Print only certain number of records 
Author Message
 Find certain Number of Records / Print only certain number of records
Hi,

Does anyone know of a good way to get FileMaker to find only the first 10
(for instance) records that match a Find Criteria ...??

Or ...

Make the printer only print the first 10 records ...??

I have a system that prints Invoices .. but I don't want to print all of
them at the same time ... Coz there will be more than 300 and the printer
could{*filter*}up ...

Any help ....??



Mon, 11 Mar 2002 03:00:00 GMT
 Find certain Number of Records / Print only certain number of records

I would create field that is a tag "to be printed", a second field that
indicates if IR has been printed on not and another that sets the criteria
of records to be printed.

Have a script that finds all the Invoices,
Pauses
Allows you to enter the number of IR's you want to print at a time.  (or
just set the number in the script and do not create a field for this)

Do a loop that sets the tag to "on" for the number of records you have
indicated.

Either omit the rest of the records or do another find criteria by using SET
FIELD for the tagged records.
Print them  Pause
Set Message (Did they Print ok?"
If yes SET field of print status to PRINTED and Clear the Tag button and do
another find for the invoices to be printed.

So script would look like:

Field On tag_to_print  Radio button On / Off
Field Print Status   Radio button  Printed / Not Printed  (should default to
Not Printed upon creating new record
Field Num_IR-to_Print  Number result

Script

Set error capture on
Enter Find Mode
Pause/Resume  (Fill in criteria of IR's to be printed)
Perform Find
Goto Record First
Set field Tog_to_print "on"
    loop
    end loop if status currentrecordnumber = specified number or the number
indicated in the num_ir_to_print field,
    else
    Set field tag_to_print "on"
    goto record next

    end loop
Enter Find Mode
Set Field tag_to_print "on"
perform find
Print setup
Print records being browsed
show message Did these print ok?  Yes, No
    If status current message choice =1
    Set Field Tag_to_print_ "off"
    replace with current contents no dialog
    set field Print Status "Printed"
    replace with current contents no dialog
    Show message Continue Printing, Finished
        If current message choice = 1
        perform script Continue Print
    else
    exit script
elsen
show message "Print Agai"
    If current message choice = 1
    print records being browsed
    else
    Set field Tag_to_print "off"
    replace with current contents no dialog

you should get the picture from here.

----------

Quote:

> Hi,

> Does anyone know of a good way to get FileMaker to find only the first 10
> (for instance) records that match a Find Criteria ...??

> Or ...

> Make the printer only print the first 10 records ...??

> I have a system that prints Invoices .. but I don't want to print all of
> them at the same time ... Coz there will be more than 300 and the printer
> could{*filter*}up ...

> Any help ....??



Mon, 11 Mar 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. SQL Question: Deleting certain number of records???

2. F4M certain layout won't print on certain printer

3. Finding records that are substring of a certain word

4. Trigger To Copy Records To New Table, Delete Current Records When I Have Certain Number of Records?

5. Read from certain page number

6. comparing a date to see if it is greater than a certain number of months

7. checking that a number is a certain length

8. Adding up till certain number

9. Reports 3.0 - Page break if detail does not reach a certain number

10. Reports 3.0 - Page break if detail dow not reach a certain number

11. Number of days since a certain date.

12. Restricting queries to a certain number of rows?


 
Powered by phpBB® Forum Software