Icecold

I want to open a filmaker file but I want to check to see if it is already open if it is don't open it again. tell application "Filemaker Pro" if "Mytest.FP3" doesn't exist then open file "Mytest.FP3" activate else display dialog "Mytest already Opened" end if

I want to find a record in my filemaker database Which has about 5 forms in it. The name of the Database is FMTEST and the form I want to do the Find is NEWFORM. The field is Called NAME in the fm database that I want to enter my param1 into and then find the record. Then after that record is found then Return the values in these two other fields as strings 2nd step is to return the text that is in Field "PHONE" as X and Field "CITY" as Y On run (param1) tell Database "FMTEST" of app "Filemaker Pro" Find Record Set cell "NAME" of Find record to param1 End tell End run

Does Filemaker 5 not support ODBC importing from SQL Server 6. I can import on my windows machine using the ODBC driver. But I can't do the same thing on My Mac. Also I setup a Filemaker 5 database on a PC as a host and then try to use the ODBC connecting on the MAC as client. I got an error Importing Via the Filemaker ODBC driver is not supported. Help am I just missing something.

Need help with an applescript for excel. Using a mac 9.02 and office 2001. I have an excel file with only one Column called User_ID. I Need to take all the strings in that column and add them to a listbox in a Realbasic5 app (Populate a listbox). But when my Excel activates I need a file open dialog box so I can choose which Excel file I want to use at that time. myFile = Application.GetOpenFilename ("All Files, *.*") on run tell application "Excel" activate open file dialog box set A to Select Range "A1" return A end tell end run

I am trying to query my filemaker 5 database. The database is called testdb. The plug-ins for Local data access comp and remote data acces comp are checked. My fields in my database are as so ID_NUM NAME LAST COMPANY DATE MISC dim cursor as databasecursor cursor=testdb.sqlselect ("select * from tempdb where ID_NUM='"+editfield1+"'") If cursor <> nil then editfield2.text=cursor.field("NAME").getstring editfield3.text=cursor.field("LAST").getstring editfield4.text=cursor.field("COMPANY").getstring else msgbox "Record not found" end if What's wrong with the code It is written in Realbasic 5. I want to use rb with a filemaker database. I am entering an Id num into a editfield and hitting a pushbutton. I am just trying to query the database with the info in editfield1 and getting the results in the other editfields. Can someone please check the code and tell me what I am doing wrong. Thank you in advance

Does anybody know how to do a find in a document in applescript or even some Kind of keystroke for cmd F. So that I can set it find when a document is open tell application "" activate try set

Can someone help me with a simple applescript. I have a quark document open which is my front most window I want to do a find in my document for the word "test" Then do a paste of what's on my clipboard Save the file to a desktop folder called working in a sequential order. By a sequence order I mean 1.QXD 2.QXD 3.QXD 4.QXD ETC ETC You get the picture

I know to use ODBC to connect to my SQL Database in Visual basic with this code. My Question is If I have a filemaker database how would I connect to it using a ODBC. Some code example would be nice. Because I want to try to use Filemaker database with an Application I create in RealBasic. And If someone can show me how to connect to filemaker In Realbasic that would really help me alot. To finish my project. As I am having a hard time in RealBasic Dim adoPrimaryRS As Recordset Dim db As Connection Dim dbOpenStr As String dbOpenStr = "PROVIDER=SQL;dsn="";uid=" & "" & ";pwd=" & "" & ";database=Stock;" Set db = New Connection db.CursorLocation = adUseClient db.Open dbOpenStr Set adoPrimaryRS = New Recordset adoPrimaryRS.Open "select * from NEW INV where ITEM = '" & Newstring & "'", db, adOpenStatic, adLockReadOnly

I just got into RealBasic to do programming on my Mac. Can you Guys/Gals suggest a forum for RealBasic. I've been looking and haven't had any luck. It would be greatly appreciated

I am trying to retrieve the files that are in my subfolder and I always want it to go to this folder to find these files example Desktop:Test:Test1:text.txt Then I would want it to open the file in the subfolder tell application "Finder" activate Set sourceFolder ("Desktop:Test:Test1")

Hi I am trying to send an apple event I can select the application I want to use. My next step is to open a file in my application (QuarkXPress) using a field I have specified in my database. I can open the same document by specify the file but I don't want to do that I want to specify my file from my field.