Balder

Hallo Jbarnum, Thanks for your reply. Very interesting. Unfortunately my Java knowledge is very poor...

Another possibility : Create a calculated field in which all data of the other fields is stored Then just search in this new field... (I know, it will need some more storage but works OK)

Thanks anyway!

Maybe calculate in hours in stead of days? add it to a timestamp, not to a date...

Hallo genx, I tried but probably got the syntax wrong... Do you have an example? as a test i entered file://c:/beep.exe From FM ok but not via IWP Best regards, Erik

Hallo Vaughan, Sorry for not being clear enough. I don't want to start an .exe on a local machine from remote, but the user should be able to start an exe on his machine via IE using a FM solution shared via IWP. (by just clicking on a button in IE / IWP) I need to control 4 relais connected to an USB-port... (I know, it's not a problem using FM...) Just saving licences... : (dutch habit...) Thanks for any comments... Best regards, Erik

Does someone happen to know how to create a workaround to start an .exe from IWP on the local client (if existing ofcourse). Thanks!

Hallo All, I hope this is this correct forum for this topic... I have a table with Company, Quantity, date, YearMonth (and a lot of other fields...) Yearmonth is a calculated field. Example: Company|Quantity|Date......|YearMonth ------------------------------------------------- A......|.....150|17.01.2006|2006-01 B......|..... 50|18.01.2006|2006-01 B......|..... 10|25.02.2006|2006-02 A......|.....350|30.01.2006|2006-01 A......|.....220|20.02.2006|2006-02 C......|......80|12.03.2006|2006-03 Now i need to create a report showing the cummulative data of timeframe 2006-01...2006-02 (so a subset of the records) Of course that is a simple selection and then run a report showing the data. But how to proceed using Internet Web Publishing? (As IWP is not supporting reports...) The report should look like: ...........A|.B ---------------------------------------- 2006-01 |500|50 2006-02 |220|10 ---------------------------------------- .........720|60 I tried to figure this out but without success. Remark Number of records appr. 50.000 So loops via IWP etc are no real option. Number of unique companies appr. 50 and growing... Your help is appreciated! All the best for 2007 from The Netherlands

Hallo, Another possibility might be the configuration of your adsl modem... (i assume you use a modem, if not, forget this post....) check NAT or NATP, specify in NATP the outside address and port(probably 80) and inside port and ip-address of the

Hallo stranger, I don't think you can solve this totally with FM.... (but i maybe wrong) 2 years ago i solved it the following way: Download AutoIt and install. Create a script which shows the data in preview mode and starts an autoit-script. This AutoIt-script does the following: Control C Copies the preview in FM to clipboard Start a graphical editor (e.g. Paint Shop Pro...) Control V : copies the clipboard-picture into PSP Save the JPG to where you want. Close PSP That's it..., end of script... For details about scriptsteps of AutoIT: It's well documented in the download. regards from the Netherlands....

Hallo there, I have the following problem: I created a database and want to publish it using IWP. This runs fine, until I open the database in the main frame of a static HTML page. The database open OK, but scripts don't work. When i click a button which starts a script, IE6.0 tells me 'ERROR on Page'. When i open the database in a new IE-window everything runs fine. Does anyone have a clue ?? Erik

I hope this may help.... Put the dcouments you want to open in the WEB subfolder (or in another folder underneath the WEB Folder. I use a global textfield called URLFIELD, fill it with the relative path (so to open john.jpg in the WEB folder : fill the textfield with /john.jpg) and create a script to open a url using field URLFIELD. Works fine for me in IWP... ByeBye

Kfok, I see only one possibility (but i maybe wrong...): find modus : search for New York, (dont'press enter) goto >request > add new request search for Stamford. Press enter. Now create a script with 'Perform find', restore, replace found set. Loop through the records all delete all records where affiliations not equal A or C.

Riky, Why don't you create a relationship (internally in the file) from datefield to the datefield (in the footer, as you call it) Then you can show all records with the same date in a portal...

does this help? Go to the table of which the fields are displayed in the portal. Do a search on the checkbox (ticked?) export the found recordset to a new FM-table.... This can be scripted easily...

Just a suggestion: Use a related table: ITEMS Fields : Student_id, barcode, flag ('In' or 'Out'), barcode_in, check_out_date, check_in_date. Create a relation from student_id in the main table to the student_id in items Write the items that students check out to the ITEMS table. Fill the fields student_id, barcode, flag (='Out') and check_out_date. Present a portal , showing the items he / she checked out, . Show in this portal the item and the field barcode_in. Let them scan into field barcode_in and let them start a script by means of a button in this portal-row. if barcode = barcode_in then set field Flag to IN. Now you can trace all movements and see the history per student as wel... does this help?

Maybe you should use a sharename in the path...

why don't you just loop through those 5 related record... You could use a layout in your masterfile and place a portal with the relevant data in it. Just loop through the records in this portal and check the fields...

Maybe this helps: Create a huge layout, Put a textfield in it, spread over multiple pages... In layout mode, go to the part-definition of the body and set 'page break before each occurence'.

Maybe this helps.... goto regional settings in >start>settings Set time limiter to . (point) format the timefield in filemaker to displayed as hh:mm:ss. If you now enter 1.5 it will be displayed in filemaker as 01:05:00 I am not aware of the time-format on Mac, you probably now ....

RSpisketts, When i understand you correctly, you created a relation from clients to contacts, via ID. Why don't you create a relation backwards (from contact to clients using the same ID field) so you have the name and adress details available (from clients) in contacts. If you want you can allow your users to change the data in clients from a layout in contacts... This may be a better solution compared to copying data, no redundancy, always the correct and uptodate data... and easily to implement... Your other question: check whether in the related file the field 'ID' is empty.... I assume there is a relation from table A to table B using fields ID (or whatever...) Do the following: Create in table A a calculated field called 'FLAG'. calculation: Case(IsEmpty(B::ID) ; "NO"; "YES") If FLAG contains 'NO', there are no related records in table B I hope that helps...

Sorry, do ... loop should be loop ... endloop

maybe this helps: Create a script like this if you want 5 copies (Counter = global field, number) set field (counter, 0) do set field ( counter ; counter + 1) exit loop if counter = 6 duplicate record set field ( ID ; ID + 1) loop This may not be the correct syntax but probably you understand...

Maybe a workaround : Use a text-field instead of a container... Format this textfield (font etc.) in such a way that it resembles your original solution. Just put in the the correct character. Is this an option for you?

Since yesterday all scripts cantaining the scriptstep Send Mail do not work properly anymore. (WIN98 SE) All scriptsteps are executed except Send Mail, just nothing happens, it doesn't bring up a window with a new mail. I checked the scripts, all fields in the send mail scriptstep are filled, so that's not the problem. I had the same problem one year ago. I performed a complete new installation of Windows, problem solved. Before i do that again, maybe somebody knows whether this is a registry problem (or filemaker problem) which can be solved in another way. I checked the settings in the Internet Explorer, Outlook express is my default mail-program, so that is OK. Using 'Open URL' scriptstep works fine, but the syntax doesn't allow to add an attachment (as far as i am aware...) Your help is greatly appreciated!