Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jaco8867

    FM Pro 8.5 import / export MS Sharepoint ?

    Sharepoint generally is backended with MS SQL server, and FM has connections for MS SQL server.
  2. jaco8867

    Name of Current Field Problem.

    Try opening a new window, then go to your layout. Copy then close the window and you will still be in your original field. Hope that helps
  3. jaco8867

    separating 1 field into 2 fields

    You could try Leftwords/RightWords/Middlewords functions to separate.
  4. jaco8867

    Calculation in the define fields

    Have you tried a case statement? Works better than nesting IF statements.
  5. jaco8867

    FM Server 5 opening files question

    Place a shortcut to the database files (or folder they are located in) in the FM Server directory. Then when FM Server starts up, it will automatically open this databases. Hope that Helps John
  6. jaco8867

    Linking 2 different scripts in FM 8

    One way would in your script Set Error Capture [On] Perform Find[] If [Get(LastError)=401] Perform Script [Script 2] exit script end if 401 is the error code when no records match the request. Hope That Helps John
  7. jaco8867

    combining fields-JeanW help me

    Try using a script like this Go to Record/Request/Page [First] Loop Set Field [CombinedField,Field1 &" "& Field2 &" "& Field3] Go to Record/Request/Page [Next, Exit after Last] End Loop After running the script, you can then delete the old fields. Hope That Helps John
  8. jaco8867

    Script making in filemaker.

    You have to drag the Set Field script step from the left hand window into the main (Right Large) window. This will add the Set Field Step, then click on options in the lower right hand corner, and add the field and the result.
  9. jaco8867

    Script making in filemaker.

    Your IF statement needs to be like this If(jobType = "production") Set Field("costOfJob","45.00") End If The Then part is on the line(s) between the If and the End If steps. Hope that helps John
  10. jaco8867

    FMP6 Database Programming Option

    To achieve what you want. Create a value list that uses the values from the field in question. Then on the field in layout mode choose format - field format and change the field from a standard field to a pop-up list and use the value list you created. Note: Filemaker dosen't do a "Type Ahead"...
  11. jaco8867

    How to count days elapsed since ship date?

    Try using DayOfYear instead of Day function John
  12. jaco8867

    Cannot add record to Database

    Control-Click on the file and choose Get Info. Change permissions to read & write.
  13. jaco8867

    FMPS7 Adv - IWP login - what ID/Pass to use?

    Ok, so assuming the issue must be with the server. Check your authentication between FMS7 and Web Server? You might try removing then reconnecting the authentication between the two. Did you install FileMaker Server 7 Advanced 7.0v3, Web Publishing Update? Are you using SSL?
  14. jaco8867

    FMPS7 Adv - IWP login - what ID/Pass to use?

    You might want to try sharing it on just FMP7 client, and verify you can access it this way. You will not be able to check the external accounts, but you could check filemaker accounts. This would tell you if your problem is with the account setup or with your server setup.
  15. jaco8867

    FMPS7 Adv - IWP login - what ID/Pass to use?

    Did you specify which users have access to the database via IWP? you need to give access to the file under "Instant Web Publishing access to file". Which is located in the lower right hand corner of the Instant Web Publishing dialog box. (Sharing \ Instant Web Publishing) Hope that Helps
  16. jaco8867

    Where can I get a CAD Viewer for mobile phone (symbian)

    Try Visiarc Viewers. They have a viewer that works for some symbian phones. http://www.visiarc.com/ Hope that Helps John
  17. jaco8867

    Script to open a file to a specific layout

    Create a script in File B that goes to Layout X. In file A script it to run an external script, the open layout x script in file B. Hope that helps John
  18. jaco8867

    search several fields

    After entering the search criteria for field 1 choose Requests - Add New Request then repeat for field 2 and so on. Hope that helps John
  19. jaco8867

    Sharing a database on a local network?

    You need to choose Pop-Up List from the field format dialog box. select the field in question, then choose format/field format. Change from a standard field to pop-up list. then choose the list you want to use. This allows them to choose from the list or they can single click on the field and...
  20. jaco8867

    filemaker 7 passwords -- desperate for help

    Check your open file script steps you might have to reenter the account name and password. Also check your file references.

Part and Inventory Search

Back
Top