DNA

Hi there fabrice Thanks for the link. I tried the custom function but when I paste it into filmaker as a new custom functions I'm getting a few errors. It doesn't recognise and number of the arguments and also says there are too many parameters. Unfortunatley it's beyond my skill level. thanks anyhow it looks like a great function. Regards Mark

Hi there I have a field with this date format in it: 4/16/07 - 4/22/07 That I want to extract the week number from for the second date set I am familiar with the week(field) format but that's based on a particular date. This field is just a number field at the moment and as you can guess the field length changes as the dates do eg. 1/3/07 - 12/19/07 so the standard left(field) command won't work either. Anyone come across this before or have a solution? Regards Mark

Hi, I need to submit a html form from within FP7. It will be used to send customers data eg name, email address automatically to a web based autoresponder system. I have the HTML form code I use on the web page, but I can't figure out how to use that code and integrate it into FP7 so when I hit a 'Submit' button in FP7 it will submit the form data. Any help would be greatly appreciated. Regards Mark

Hi, I need to submit a html form code from within FP7. It will be used to send customers data eg name, email address automatically to a web based autoresponder system. I have the HTML form code I use on the web page, but I can't figure out how to use that code and integrate it into FP7 so when I hit a 'Submit' button in FP7 it will submit the form data. Any help would be greatly appreciated. Regards Mark

Thanks for your advice captKurt. My DB consists of about 8 layouts on which particular some fields occur repeatedley and only fields need to be 'locked'. I have opted for the following solution. Set the Field format option to 'do not allow entry to field' I have a ModifyAllow field flagged with either 0 or 1 A seperate script for each field if(ModifyAllow=1) GotoField(Fieldname) Else Beep EndIf I set each field through Specify button - perform script (script name) I also have a small padlock Icon that sets the ModifyAllow field to 0 or 1. Hope this helps

I am having the same problem. I am running a script that sets the field 'ModifyAllow" to either 1 or 0 valeu then using the limited Edit function simply using the field "ModifyAllow" for the 1 = true or 0= false. It would seem though that once the record is locked for editing that I can no longer set the field to 1 eg allow editing. I am going to try to create a related database and set the field ModifyAllow in the related DB. I'll let you know how I go.

Thank you for your help

Hi, Office setup OS :XP FMP6 FMS Home Setup FMP6 A question about programming with FMP6 and then putting the database in a server enviornment. When I program at home without server running I Define relationships, use open script steps etc by using the folder name in open file window. If I then take this database to the office (WIth Filemaker server) do I need to re-define these links using the Host button in the open file window or does server 'magically' take care of this ? Thanking you in advance.

Hi Guys, We've been doing it wrong the whole time!!! We have been opening the files on a network drive. Now I ubderstand about opening the files through open remote etc. But can this be automated eg script. "to be foolproof"

Hi OS winXP FM 6 I am using PDF writer to create files that are then emailed through a script but it is still up to the user to save the PDF with the correct name. Any suggestions how I can make this fool proof. (We had an employee email out our cost price instead of an invoice )