socks

I am using version 4.1 of FileMaker for Windows and have created a script that needs to print to two different printers. I would like to write scripts so that the printer setup is restored so that the program automatically prints one layout to a dotmatrix printer, then the script continues and goes into another database and prints another layout to a laser printer. However, I cannot seem to get the script(s) to change the printer it is outputting too. It seems that all the script are automatically changed to the last printer used, even though I have checked the "restore" box in the script printer setup function. Can anyone help me determine how I can have a script change printers back-and-forth? FileMaker Version: 4 Platform: Windows 2000

This error message keeps coming up when opening a database created in FileMaker 3.0 on Windows. The computer may or may not have had a virus. In addition, we cannot print to one of our printers from Filemaker, yet it prints to two of the other printers on our network fine? We have recovered the databases in Filemaker, reloaded the Filemaker program, and reinstalled the drivers for the printer. Yet we still get the error message "this file was not closed properly, Filemaker is now performing a consistency check"? And, when I go to print to one of the printers we get another error message that says "this program has performed an illegal operation",and it gives us the option to shut down or ignore this error message? I do not know what to try next. any help that you can give me would be greatly appreciated. Thanks, Jeff Norensky

Lee Your calculation worked. Thank you very much. I only made one change by removing the brackets from "old tax rate" and "new tax rate" because they are number fields, and I didn't want text but the actual tax rate number. Thanks again. Jeff Norensky

Thanks for your suggestion. I don't have any typo's in my calculation, and I am not using a relationship. And, I would agree to have a county field for each customer, then change the county rate would be better. But, for now, do you see any errors why this calculation field is not working "If(invoice date <6/1//2003, old tax rate, new tax rate". I want this field to tax the old invoices at the previous rate, and the new ones at .25% higher.

I have to change the sales tax rate in two different databases. The sales tax in NY went up .25%. One company only does business in a single county and I changed the tax rate field from a number (I.E .07) to a computation that said: "If(invoice date <6/1//2003, .07, .0725"). This seems to work and nes invoices are taxed at 7.25% and the old ones relain at 7%. But the second company is more complicated and they do business in numerous counties that have different tax rates, so if the tax was 7% it becomes 7.25%, and if the county tax was 8% it has changed to 8.25%. So, for each customer I entered an old and new tax rate, and created a computation field for the "tax rate" charged as "If(invoice date <6/1//2003, old tax rate, new tax rate"). I was hoping this calculation would insert the proper tax rate for each account, and if the invoice was entered prior to June 2003 it would use the old lower sales tax rate, and invoices created on or after 6/1/2003 would use the new higher rate. But, this is not working, no matter what the invoice date it seems to use the higher rate. Can anyone see if I made a mistake.

Thanks for your advise. I will check to see what version I have, and update it with the new patches. Do you know of these patches addressing a printing problem with a long repeating field that spans multiple pages? My son just got back from Sydney and had a great time. He also went to Lightning Ridge to buy Opals. Jeff Norensky Syracuse, NY

We are using FM 4 for Windows. And, we keep a record of work performed for customers in a database. The work performed uses three fields for the date of the work order, description of work performed, and labor hours consumed. Each of these three fields are repeating field that have 100 lines, so we can send our customers a record of the last 100 service calls. Although most reports have less that 30 service calls and fit on one page, some take two or even three pages. I set the printer to print "1 of 1 pages" and "print all records being browsed" (which are about 50 records), and go back and manually print the second or third page for clients that have over 30 service calls. However, the system generates a fatal error and freezes FM up. I put in a few pauses thinking that I was sending to many pages to the printer (a LaserJet 5P) that would not all fit in the buffer, but that has not helped. Basically, I am trying to print the first page of 50 records that have a repeating field that spams three pages. If I print all three pages, I get two blank pages when the client has less than 30 service calls. And, when I print one page per record, FM gives me a fatal error and I have to reboot. Any ideas what I am doing wrong. Thanks, in advance, Jeff Norensky

i have a repeating fields with 50 lines. We put into these fields the dates that we perform service work, the type of work performed and the amount of service hours consumed on each servicecall. We send out a report to each of our major customers once a month showing their activity for the year. At the bottom of this report we put a note about our specials for the month. We want this note to slide up right under the repeating fields, but it does not. In the layout the note is about 1/8 inch under the repeating field, but when it prints out there is a 3 inch space? How can I get rid of this space? I am using the funtion slide up based on all above fields, but all the above felds are on the same line. Also, I don't want the note on our monthly specials to be split between two pages, I would like the full note (that has a border around it) to go to the next page. I believe creating and putting it in a footer will duplicate the note onto every page, which I do not want. Do you have any suggestions.

I have a sub summary that was working well that all of a sudden got funky. It is a report that does a summary of my technicians hours and revenue. It normally would print on one page with a line for each tech showing what they produced for whatever period of time I did a find for. Now the subsummary puts each tech on a seperate page, so instead of getting everying on one sheet and on one screen in preview mode, I get 10 screens and 10 pages each with one line showing an individula tech. And, I don't think I changed anything to cause this.

I developed a db for a cliet that was using MS Works. They wanted a Filemaker or Access database because they needed it to be multi user, and Works can not be used on a network with more than one person at a time. With Works the database fields can be easily inserted right inside the Works wordprocessor, and they would type numerous letters and do mail merges, and put fields into the text. The word processor had word wrap and was a decent word processor (much better than the Filemaker word processing within the layouts). I put together a database that is far superior as far as database capabilities, but does not make it as easy to do word processing and insert field. They need more word processing and less database. They keep changing their form letters based on the individual circumstances of each case. So, they are not pleased with what I did for them. I did tell them they can create a letter in MS Word and cut and paste it into a new layout in Filemaker. But, they lose the formatting and do not like taking these extra steps. Is there anyway I can have Filemaker interface with a word processor so that all records are automatically available within the word processor. They would not want to export the records, so it would have to be an automatic type of interface or relationship? Thanks, Jeff Norensky

I developed a db for a cliet that was using MS Works. They wanted a Filemaker or Access database because they needed it to be multi user, and Works can not be used on a network with more than one person at a time. With Works the database fields can be easily inserted right inside the Works wordprocessor, and they would type numerous letters and do mail merges, and put fields into the text. The word processor had word wrap and was a decent word processor (much better than the Filemaker word processing within the layouts). I put together a database that is far superior as far as database capabilities, but does not make it as easy to do word processing and insert field. They need more word processing and less database. They keep changing their form letters based on the individual circumstances of each case. So, they are not pleased with what I did for them. I did tell them they can create a letter in MS Word and cut and paste it into a new layout in Filemaker. But, they lose the formatting and do not like taking these extra steps. Is there anyway I can have Filemaker interface with a word processor so that all records are automatically available within the word processor. They would not want to export the records, so it would have to be an automatic type of interface or relationship? Thanks, Jeff Norensky

we place orders for customers in an order database. when the products to fill the order arrive at out store, we send the order to a finance database where a shipping slip and an invoice is printed. But, the order database still has the order, but it gets marked closed. I was thinking of having the order exported to finance, and then have the script return to the order database and have the order deleted because it has been filled. I have two problems: 1. i worry if the order does not export properly, and then the order is deleted, I will have no record of it. 2. I presently do not give rights to our sales people to delete orders in the order database, so can I have the script change the rights, delete the filled order, and restrict the right back to the original setting? Or, maybe I should just leave everything the way it is. Has anyone had a similar situation, and if so, what would you recommend?

I want to print multiple mail labels for the same records. For example, I am doing a find that brings back 10 records of ten clients. I want to print two mail labels for each client on one sheet of label paper (not two). doers anyone know if this can be done?

I want to print multiple mail labels for the same records. For example, I am doing a find that brings back 10 records of ten clients. I want to print two mail labels for each client on one sheet of label paper (not two). doers anyone know if this can be done?

I have to do a series of finds, and then print different letters (layouts), to patients. But, if one of the finds in the script does not match (find) any records (and the foundset=0), then the print command interupts the script and says something like the the print command can not be completed. Is there a way to have the script skip the print command when no records are found, and there is nothing to print? So, the script does not stop and another find is performed as per the remaining script steps. And, then if records are found, prints appropriate letters.

I am trying to allow an office staff to enter codes throughout the day, and run a script at the end of the day that prints out letters to be sent. For example, in the field "code" the number "1" would print out a letter confirming an appointment date and time for a patient. The number "2" might print a letter to a patient that missed an appointment. The script I wrote is as follows. find all enter find mode insert text (specify "code" field)>0 Perform find loop if "code = "1"" go to layout "confirm appointment" Print (no dialogue) Else if "code = "2"" go to layout "missed appointment" Print (no dialogue) Go to record Next end loop end if end if The end result is not what I want? I expected to get letters to patients with new appointment, and different letters to different patients who missed appointment. I am getting multiple copies of the same letter to the same patient as if my loop or my "if" statement is not working. Any advice would be appreciated.

I am usinging Filemaker 3.0 with Windows98 operating system. I have a "customer" and a "sales order" database. I have created a script (actually two scripts) that go from the customer database to the sales order database. Basically, it is desigend so the sales clerk can find the customer information, then hit a button which opens a sales slip which has the customer information on the top of the order form. I have two "must enter" fields (that allow the users to overide the must enter) in the sales order database. When the user hits the button to go from the customer database and create a new order form, instead of the order form appearing, it stays in the customer database and a pop up message appears that says the "salesperson" field must be enetered, and them a second pop up appears that says the "method of payment" field must be entered. These are the must enter fields in the sales order database, but the screen still shows the customer database. So, the program did seem to switch databases as I want them too, however the screen does not show the database the program switched too. I tried to refresh the screen in the script, and this does not seem to help. Any ideas why the sales order form is not on the screen, when the program must have switched databases, or else it would not be asking me for the must enter items?