dmurnane

I have several clients with whom I have annual contracts. I give them a database which they have to login to use. I want to be able to put a time limit on their ability to login. In other words if their contract expired at the end of July and they decided not to renew, then after 1 month their login would be de-activated. I am using FM 8.5 advanced. I tried the following script but it immedietly de-activates them. I have tried changing the date format mm/dd/yyyy but still the same result. Can you advise? Many thanks, Dominic If [(Get CurrentDate) > 01/09/2009 Go to Layout ["Startup" (Assets)] Show/Hide Status Area [Hide] Beep Show Custom Dialog ["Database Maintenance Alert"; "Please contact Compass - 087-xxx if you are seeing this message as your user licence may have expired."] Enable Account [Account Name: "Me"; Deactivate] Re-Login[ ] End If

I have a database that is used to monitor maintenance callouts to various buildings, these records are classified as either 'open', 'pending' or 'closed' from a drop down field menu. When the field is changed to 'closed' how can I prevent all the rest of the data in the record from being modified? Many Thanks, Dominic

I have tried to display my Filemaker modules through Instant Web Publishing from my work PC and home Mac. It works fine on the local network but when I try to access from either home to work (different locations - not networked) or visa versa, I get "Webpage cannot be displayed". I have tried setting the port to 591 and in the manual but no joy. I am doing this with Filemaker Pro 9 which as I understand should allow up to 5 users to connect. I do not have Filemaker Server. Any help would be appreciated. Thanks