Windows Automation

We have a solution consisting of a FileMaker DB and a predefined Word template which has a mail merge data source pointing to a file called data.mer. We have successfully create a automation script which exports a file to the users desktop (data.mer) and then using AppleScript launches the Word template and executes the merge to new document command. Our solution is cross platform and we would like to do this with Windows. I presume that this would be best achieved using Visual Basic however I have no experience with VB. Any help or examples on this matter would be most helpful.

In Windows Explorer, when I double click on a dbf file (of form <filename>.dbf), instead of opening the file in VFP, I get a message "<filename>.fxp is not an object file". e.g. clicking on T_DCLNT.DBF, gives message "t_dclnt.fxp is not an object file". Anyone else having this issue?

Hi all Has anyone successfully registered the FMP protocol so that users can click hyperlinks in outlook. If you type http://somewhere.comor mailto:[email protected] or ftp://here.com and send the email they will appear as hyperlinks in outlook when the recipeint gets them. This is not the case with FMP:// ... I would like my internal users to be able to click the links. THe only way I have found to do it is to actually create the links as hyperlinks. Any assistance would be greatly appreciated. Thanks ZP

Hi All, I have experience with VBA for MS Excel. I would like to write some VBScript and connect it to FM. My question is how do you do this? I would imagine that you create a vbs file in notepad but then how do you connect this with FM? And do you need FM Advance? Any help will be very much appreciated!

I find myself resizing objects in Layout mode like every time, i can use left clicking to resize objects but i want to do it through the keyboard pixel by pixel, is there a shortcut already defined in filemaker special for that purpose OR any other possible solution to my Problem.

I am trying to use Send Event to create a BAT file on my Desktop. I have used the Send Event before and believe this should be possible using this script step. I have this: Set Variable [$file ; get (desktoppath ) & "test.bat"] Send Event ["aevt" ; "odoc" ; "cmd /c echo test> " & $file Which I would expect to create the file test.bat on my Desktop with the word 'test', as when I run this from cmd in any directory it creates the file as expected. However this isn't working using Send Event. I used Substitute to change the \ in the filepath to / but it also didn't work. Any help would be great thanks!

How can I change the path so the script will insert the pdf regardless of the user in windows and regardless of the pdf name? This is the original path is: imagewin: /C/Users/Home/Documents/pdf/anyname.pdf Thanks in advance

Hi, Just trying to run some vbscripts from FM... with no luck. I can run the script directly by doubleclicking it, I can run it using (Start-->Run) and specifying the filepath in quotes. But no matter what i do, i can't get it to run properly using SendEvent and Quote($FilePath) where filepath is the correct path of the vbscript. Yes i'm sure i've got the file reference right because i copied it out of FM to try and execute through the cmd just to check -- no difference. I've tried almost everything i can think of and it just will not execute properly... I was under the impression that SendEvent was the equivilent of run... was i wrong? I'…

We currently run FileMaker Server Advanced 11 on Mac OS X server. We will be making the move to FMS 13 in the next 6 months and are exploring the option of moving our FMS to our Windows virtual server farm. We use the AppleScript script step in a few of our solutions to run shell scripts and modify text files in the OS on the server. I am struggling to find an equivalent method for the Windows side. Below are a couple of examples of what we currently do. My hope is someone here can post an explanation with examples to get us off and running. #Add header to export file and convert to Windows CRLF Perform AppleScript [ Native AppleScript: --Add header ro…

I have a vbscript which is executed by an export script that opens a word document in read only format then populates several bookmarks and finally saves it with a different name and different folder. This works as I would like but the document does not open in the foreground, just in the taskbar. My operating system is Windows 8.1 The following is my VBScript: "Set objWord = CreateObject('Word.Application')¶ objWord.Visible = True¶ Set objDoc = objWord.Documents.Open( 'C:Dernier & Hamlyn Sales DatabaseTemplatesStandard Order Acknowledgement.doc',,False)¶ Set objRange = objDoc.Bookmarks('ContactName2').Range¶ objRange.Text = '" & Entries::QuoteContact & "…

Hi Forum, Im writing a script (in autohotkey) that can close my filemaker file that I have open in Filemaker Pro 11 on my computer. Trouble is, sometimes the file doesnt close as others are still logged on to it and hence the file doesnt close. I just get the "ask others to disconnect" dialog box. That does not seem to have a button to disconnect the others rudely. Is there a way to disconnect remote users from the file without using the ask button? Im doing this at night so i doubt someone will respond... Thanks Spongebob.

is it possible to launch filemaker and open a database from a hyperlink with chrome? I can get the FMP:// protocol to work with internet explorer just fine, but that really doesn't help since the office uses chrome.

I 'd like to automate a bit the way my windows user access the db. First of all I d like to get rid of the annoying "feature" of windows using by default the Windows's user name in the user field in filemaker. It creates confusion to no avail because my users have to delete and re-enter. In addition I 'd love to hear what others have done, and I am in particular looking for some sort of keychain type password manager for windows. Anything on the horizon? I ve searched hi and lo to no avail, so far.

HI, Ik want to delete a file from FileMaker in Windows. I want to send a event from FileMaker to do that. From the commandprompt I type: cmd/c del C:\Users\Tol\Desktop\File.csv and that works, when I put this in the textbox for the event I get errors and it does'nt work. How do I put this in the event textbox to get it working? can I use a Filemaker field or variable??

I want to delete a file from FileMaker in Windows. I want to send a event from FileMaker to do that. From the commandprompt I type: cmd/c del C:UsersTolDesktopinvoice.pdf  and that works,  but when tried to delete the file in a network drive (P:invoiceinvoices::id.pdf), i put the code  "cmd /c del " & Quote ( "P:Invoice "&Invoices::Invoice ID&".pdf")  in the calculation box for the event I get errors and it doesn't work, i can't figure out what am i doing wrong. Any help would be appreciated. Thanks  Â

Hi, My windows users use the drag & drop capabilities in FM. The problem is that I only now found out that once you do that you cannot export the content of the container via script or even manually (right click -> export field content) is there an OS level script that can extract the content somehow? I have many users across the globe with their own copies of the Database and I need to automate the upgrade process, so I cant just convert the files..

I have a script that opens a folder on a network volume. The intention is to open the folder and attempt to select the file. If the file can't be selected, it's OK—I'm not going to bother the user with an error message. I have this working on the Mac side via AppleScript, but I can't get the file select portion working on Windows. Here are my relevant script steps: #Folder was opened successfully - Now attempt to select the source file as a nicety Set Variable [ $select_file_path; Value:$successful_url & $part_number & $part_revision & $file_extension ] If [ Abs(Get(SystemPlatform)) = "1" ] #Mac Perform AppleScript [ Calculated AppleScript:…

Just begining to explore ActiveX for FM. I have a short console program I'm using to play around with different ideas. However, I can not get the "DoFMScript" method to work. In fact there seems to be a problem with how I'm creating the document object that I can not chase down. Here is the code So far no problems this all works fine. This part is the showstopper. Any reference to to the document object "FMProDoc" causes a failure. The error message for this version says "Exception from HRESULT: 0x80010105 <RPC_E_SERVERFAULT>> at FMPRO70Lib.IFMIdocument.get.Parent<>" What is wrong with my code?

We use Windows internet shortcuts placed on the users desktop to launch our solution from client machines. i.e. fmp://server.local/Solution.fmp12 Currently we do this by hand on each client machine. I was wondering if there is a way to create this using the Send Event script step in Filemaker Pro 12? Clients are using both Windows XP and Windows 7. Thanks again in advanced.

Dear community Can anybody provide me with some sample project (or even a manual) of how to automate Filemaker from MS Visual C++ or preferably Borland C++-Builder 6.0? I've spent quite a few hours on this now and have been partly successful, i.e. I'm able to launch a specific FM-DB or quit/set visibility of FM application. However, I still couldn't manage to run a script from a DB or do other actions on document level. Any help is very much appreciated! Thanks in advance! My data: Win XP Pro SP3 FM Pro Advanced 11 v3 Borland C++-Builder v6

Hi, FMP11 Advanced crashes occasionally on Windows 7 OS. Below is the problem signature. Anyone here encountered the same problem? How did you resolved? Thanks. Problem signature: Problem Event Name: APPCRASH Application Name: FileMaker Pro Advanced.exe Application Version: 11.0.2.220 Application Timestamp: 4c12006f Fault Module Name: ieframe.dll Fault Module Version: 8.0.7601.17723 Fault Module Timestamp: 4ebcb2ca Exception Code: c0000005 Exception Offset: 00033752 OS Version: 6.1.7601.2.1.0.256.1 Locale ID: 1033 Additional Information 1: 0a9e Additional Information 2: 0a9e372d3b4ad19135b953a7888…

Been scratching my head on this one, not sure how to do this, or if it's even possible.. If I have a price list catalog that is made of several word 2007/2010 documents (no scripts, or anything fancy in them yet), is there some way that I can get the document to automatically connect to my FM db to pull the latest price/description for a particular product, and insert that into the catalog? A plugin, VBS, XML, etc. I'm open to anything that may work. I figure I would have to link it either by FM ID of the product, or match it by product's part number, etc. For example, the catalog shows something like this: Part Size Description Price ABC1 1" 1" …

I have created a simple batch file that will allow a user to enter a folder name and then it will export all of the file names into a txt file. the code looks like this: @echo OFf c: set /p name=What is the name of the folder: cd C:\Documents and Settings\user\Desktop\%name% dir /s /b >C:\filenames.txt I am using FMPA 11 and am trying to use Send DDE Execute to run this batch file. Anyone know what I enter into the following fields? Service Name: Topic: Commands: I am happy to move the commands out of the batch file and into file maker but the topic and commands have me stumped. I continually receive an error code of 3. " Comma…

Greetings, This may be answered elsewhere, but I can't find a specific response to my question. I am using a "Robot" client to automate a script I need to run nightly. I would have preferred to use Filemaker Server's Scheduled Run Scripts to do this, but everytime I run it, it gets stuck in an infinite loop or something, and the only way to get rid of it, is to reboot the server. I am performing an ODBC SQL import through the script, it should be supported.. I think the problem is the 3rd party driver that has to be initalized... it just doesn't want to work when the scheduled script runs... From Client side, it works like a charm. So after a little …

Well I put this here as Growl is a key part of my solutions on Mac platforms, but I'm getting continued pressure to implement this cross platform. I checked the Growl for Windows site and saw no sign of Filemaker being integrated or even on their wish list. I found a blog about Snarl, http://www.gaslowitz.net/filemaker/blog/2008/08/windows-users-may-snarl/ I really do not want to go with two different apps for this, does anyone have some insight on Snarl, does it integrate well, is there a Growl for windows in the near future, are there any other Windows apps that can be easily integrated. Any insight would be a real time saver for me on this one. Thank…

I believe Filemaker can do this, but I'm not sure how... In Excel, we have a very complex budget template for our events. Our client database is in Filemaker. Is there a way to get all the variable information when we add a new client to Filemaker (company name, number of children and adults, dates, arrival time, departure time, # of meals, activities, etc...etc...) into the Excel template? Or vice versa, putting it into the template first then it automatically goes to Filemaker. We've always just added to both manually, but we are getting busier and noticing more human error now. It'd be great if we could just put the info into one place to reduce the chance fo…

I'm still looking for the best way for users to change the file extension on a file to be imported from ".xxx" to ".csv". Someone suggested this would be possible using a VB script. I did a google search for one and came up with this: oFS.GetFile( sFSpec ).Name = sName & ".csv" oTS.Close Are there any VB script experts out there who can confirm that this will work in a Filemaker Pro 11 Adv runtime or suggest how it might need to be changed to accomplish the goal. Also, what would be the Appelscript equivalent for my Mac runtime users? Thanks. Dave

I have fallen victim to the QuickTime sound problem with FileMaker crashing when playing sounds in container fields in Windows. There must be a simple way to play sounds outside FileMaker using a VB script. However, my script writing is not very handy - is there a hero out there that might have a quick and dirty script for this ... please! thanks for any hints help or otherwise Anatole

I return to designing a layout after almost 3 years, and despite boning up a bit using several books, I cannot figure out what I have done incorrectly. I am using FM 8.5 Advanced. Here is the goal: I have a large art database with images and I wished to generate a layout that would fit on a single page and contain two records per page. I was successful in sizing etc., but when I tested it, only the top one contained the image. My work-around was to expand the layout to almost a full page, but this generated a very long print-out (and *,pdf). Twice as long as necessary. Because the "top" one worked, and there seems to be no overlay of parts on the bottom, what ha…

A few months ago, a post on this forum confirmed the rather lame, but apparently "standard", method to capture a user-selected file name into a FileMaker field: Does anyone know of a way to point the Insert File (file selection dialog) to a particular directory? I have a standard directory that always contains a set of imported files. All the user needs to do is select one of them. It seems absurd (to them and me) that the computer can't always point them to the proper directory. I've attempted to do this by specifying a non-existent file on the correct directory. But that gets derailed by any previous (unrelated) file selection if that selection was el…

Attached is an FM DB which runs an autoit script which listens on port 33891; any request to http://YOURIP:33891/ or http://YOURCOMPUTERNAME:33891 will trigger the 'Show Message' filemaker script. Autoit must be installed. This is based on the autoit TcpRecv example. The script 'Initialize TCP listener' will start the autoit script which listens. Presently, browser won't display anything when script fires, though a message could be sent back to browser that script had been fired. An autoit GUI window displays when server is listening. Closing GUI window stops listening. The other scripts demonstrate controlling a WebViewer with COM, clicking o…

Hi I want to select a file through a windows diolog and set the path to a field in Filemaker. Being a Mac guy I have no idea how would I script it and implement in scriptmaker? thanks This is my applescript equivalent. tell application "Finder" to set filename to (choose file) as text tell application "FileMaker Pro Advanced" to set cell "setup::file choose" of current record to filename

I have a file maker application for windows and having fields of emails like message From,message TO,CC,Subject,message Body and out look is configured in my windows machine. I want as i select a mail in outlook in-box all related data store in respected fields of the same message using vb script.Can I do this and how? Please reply me with example in attach file.

Is there a way to launch an application from within FileMaker? Can you pass parameters to the application (field values, variables, etc.)?

How do I rename a downloaded jpg using wget. For example: wget "http://website/library/abc.jpg" downioads the file abc.jpg to the users downloads folder. I want to use a field in the record to rename the downloaded file.

I have just built up a database including customers table with a phone field. I have a search function when phone calls come in you can manually type in the phone number, and from that you get an existing customer. If they do not exist, it creates a new one. But I was thinking that maybe there is a way of the phone calls coming in through windows, it could capture their number and do this automatically, putting the phone number straight into filemaker? Maybe even a button that says "Get Number" and once clicked, it gets their number and does its search?

I must have hit some weird combination of keys! Now when I go into layout mode, the horizontal scroll bar always snaps to the right. Whenever I try to move it, it always returns to the extreme right of the form (inch 111). What is going on?! Happens on all layouts - even when restarting mode and application. Have been using FMP for more than 15 years - have NEVER seen this before.

Hi Guys, I've been tasked with creating templates within word and exporting data out of FileMaker to merge with the word document. I thought ODBC was the way to go, and the driver seems a little hit and miss in Word. On some occasions it works great and in others it fails to connect 3-4 times. I know I can export out of FM a merge file and do a mail merge that way, but I dont want subsets of my exported data vulnerable on the harddrive in what is essentially a text file. I was wondering whether it is possible to create a script in FM that will export my found set of records and create a merge automatically, and Delete the exported merge file? I'm basic…

Hi All, I’m creating an Task/List, to do items in my FileMaker based solution. The client wants me to output this also to Outlook. I have managed to get a calculauted field put in the contents of my vbscript and export and execute it. "Const olTaskItem = 3 ¶ Set objOutlook = CreateObject("Outlook.Application") ¶ Set objTask = objOutlook.CreateItem(olTaskItem) ¶ objTask.Subject = "" & Subject & "" ¶ objTask.Body = " & Details & " ¶ objTask.ReminderSet = True ¶ objTask.ReminderTime = #27/01/2010 12:00 PM# ¶ objTask.DueDate = #27/01/2010 12:00 PM# ¶ objTask.ReminderPlaySound = True VBCR objTask.ReminderSoundFile = "C:WindowsMediaDi…

Hi, just create a FM 10 Runtime to schedule a Mail-Script. The App should "work" without Login on the Server. I prefer to setup the Runtime as a Windows Service. After trying Powershell, CScript and VB-Script, never received any Mail... Does anyone have a solution for my Problem? P.S: the Mails are send via the Mail.it-Plugin from Dacons

Hi All, I am completely new to filemaker, so my question might seem silly to some. Am working on a stores database which accounts for everything that comes into the store and whatever is issued out of the store daily,for a restaurant. I have done most of it and its working well, but am having one problem. i have an inventory table which keeps track of the stock movement for every item, everyday(that is what comes in and what goes out) it then calculates the closing stock for the day.It has a total of 768 records for now. What i want is to set a script in such a way that the days closing stock for each item/record will be dispalyed as the opening stock on th…

hi all, I don't know if my question has been answered before already, the truth is I just learned about the software and am creating a project now where I can integrate MS Office applications via FMP. that's the first case and a lot more coming in, i'll just have to solve this first. thanks and best regards, Mark

I use Mac making my database. For auto dialing a telephone number I use a AppleScript going through the program Dialectic which dials X-Lite for me. Working fast and good. But now I have to make it work for Windows too. So I hope I am in the right thread and can get some good advice Thanks!

Hi all, I'm a beginner to VBScript. I know nothing. I did buy a book this weekend, "Micorsoft VBScript Step by Step". So far very frustrating. I can do this via command line with two commands. 1. cd c:Program FilesFilemakerFileMaker ServerDatabase Server 2. fmsadmin close -y -u username -p password FileName.fp7 I need to use FM Server scheduling process to run this. FM server only used VBS or JScirpt on a windows computer. Can someone help me with this? Thanks in advance. Todd Dignan

Is there an API that can be used from within FM to generate Excel or Word reports. I don't mean export. I need something like VB that can have full control over Excel or Word. I've searched but all I can fing is info on Exporting.

Hello, I am using some script debugger tools to help write vbscript code to talk to FileMaker. I want to use the intellisense like features to help with coding the FileMaker methods and properties. The 3 script programs I have tried so far are: 1. Microsoft Script Debugger 2. PrimalScript 3. Admin Script Editor These programs need help finding the type library for FileMaker Pro. They need the path to the FileMaker Pro type library and I am not sure what it is? Would someone be so kind and friendly as to let me know the exact path to the FMPro70Lib? VBA in office seems to find it just fine and seems to work with the intellisense to dis…

Hi, I've been googling this for a while and can't seem to find the answer so I'm hoping someone here might be able to help. Basically I am looking for pointers on how to reference FileMaker fields in VBS, of which I have no experience. For example I have the following AS code which gives me an array from a portal row: set Items to cellValue of cell "ItemIDNum::ItemName" of current record How would I do this with VBS? I've tried variations of the following with no success: Dim Items Items = <> TIA

Hi, I've never use VBS before. Can a VBS script return values to FM? Thanks

I'm interested in integrating a 'realtime' barcode scanner [intermec] into my FMP 8.5 inventory control system. Has this been done, or where should I look to find out more about how to accomplish this? I think I can use a 'wedge' reader without problem, but also want to have interactive data transfer from the warehouse locations that are over 100 ft from the computer system. Any advice is more than welcome.

I'm trying to talk to FM10 via the activeX. The problem is when I try to set the value of a FMPRO70Lib.Documents the ActiveX throws an error. Here's a sample FMPRO70Lib.Application fmApp; FMPRO70Lib.Documents fmDocs; fmApp = new FMPRO70Lib.Application(); fmApp.Visible = 1; fmDocs = (FMPRO70Lib.Documents) fmApp.Documents; // Error here! ... Does anyone know why?

I have a problem that possibly has more than one solultion, and would be most grateful for any comments or ideas on what would be the best way to solve it. I have a database where every record has a unique number (year + serial 000-999) e.g. 2008186. The records correspond to folders in a known location on a HDD. The foldernames all start with the number + keywords that are entered on creation by users. For instance "2008186 shipwreck dredging North Sea". The folders contain all documents pertaining the respective records in the DB (FMP9). I have made a button "go to folder", with a send event script that finds the directories of the folders and should open the…

I've been asked to set up a FM process that will [color:red]take a referenced Word document and convert it to a .pdf file. The pdf file will be attached to an outgoing email. Does FM have a way to do this? I was thinking about setting up an outside scripted process to open Adobe acrobat and convert the file that way. I don't like this idea though as many things could go wrong. Any ideas are appreciated. Thank you.

Hi, Is there a way to open a file that is hosted on a server with the FM activeX? There is a method called "open" in the "Documents" class. The usage is the following : fmDocs.Open("myFile.fp7", "accountName", "myPassword") Here's is what I would like : Dim fmDocs As FMPRO70Lib.Documents fmDocs.Open("serverIP:myFile.fp7", "accountName", "myPassword") Thank you for any help

Can anyone recommend a good book for learning VBscript? I am pretty familiar with VBA in Microsoft Excel if that will make any difference. Thanks! James www.james-mc.com

As FM only has limited wordprocessing possibilities (causing problems in case of lengthy documents), I would like to find a solution for automating the creation of template-based documents in Word. For example, based on the data in FMP I would like to create a letter in Word based on a pre-existing letter template. All the contents of the letter would be merge fields. Additional problem: it should work cross-platform (Mac & Windows). I suppose I need to use one of the Get-functions to establish each user's OS (which function is that, exactly?). And how do I proceed from there? Do I use applescript for Mac and VB for Windows? I'm pretty new to both o…

I am using a FM database as an data enrichment system within a MS eCommerce environment. One of the things I need to do is export updates on a nightly basis. On top of this whole thing, we will have a "general manager" controlling the imports, via ODBC and export updates. From what I can tell there may be two options: 1) write a VBScript to actually export the data itself, 2) write a VBScript to trigger a FM export script. Any ideas on what is the best solution? I am not very familiar with VBScripting. Thanks,

I have a web application that used an Export Records step in FMP 6 (exporting a tab file), but that isn't compatible with FMP 8 Server Advanced. I need to export data based on the records found on the web. What is the easiest way to do that using XSLT?

Hi all. I'm pretty new to Filemaker and am stuck on what may be a pretty easy problem. I'd posted this in another topic area a few days ago, but thought this section’s more appropriate. I'm trying to get Filemaker (9 Advanced) to print documents in Microsoft Word for which I have a reference to the file stored in my Filemaker database (though I could change this set up to import the file, if needed). I'm trying to find a way to open multiple documents and print them with Word 2007 (OS, Vista). Ideally, I’d be able to do a find in the documents, insert page numbers in the footer, and print to Word 2003 (XP) & Word 2004 on a Mac (OS X Tiger), but… Other than the…

Hey Guys, I'm working on this database in which i create the XML for FMP to enter data... right now i have the XML data being saved from my vb.net application to the file system... if i were to make a button in vb so that the xml would be automatically imported into FMP, How would that look? Love Hearing from you guys, Euka

I'm testing out using VB to add records to a FileMaker database served from FMS via ODBC. As part of this test I first decided to see if I could just query the records in a certain table and get back some results which works fine here's my code..... Dim ws As Workspace Dim db As database Dim strConnection As String Dim rs As Recordset Set ws = DBEngine.Workspaces(0) Let strConnection = "ODBC;DSN=TSHC" & DatabaseName & ";UID=Admin" & UserName & ";PWD=" & UserPassword Set db = ws.OpenDatabase("", False, False, strConnection) Set rs = db.openrecordset("ENGLISH_NATURE") Do While Not rs.EOF 'Put the code here for wh…

Hi everyone, new to FM and new to here. We run a mixed installation of Mac and Windows computers in a Tiger server OD with a SAMBA domain. My Mac engineer colleague has got ARD to put data about the Macs into a FM asset database, such as serial number, mac address etc... I use a tool called BGINFO to do the same to an access database on a share on the server. I have a vbscript logon script which maps drives and executes bginfo and does other things. My question is.... how easy is it to add a bit of vbscript to take some WMI data and write it to fields in the FM asset table? I would obviously have to query the database first to check if the wo…

I have tried searching for a solution but can't find anything hence my post. I am trying to get a script in FM to either paste the clipboard contents or a fields contents to an external application. I have a Send event command which opens up the application . I have set the event to bring the other application to the foreground and I have the cursor flashing in the very place I need the FM data. Is there a Send Event command to either paste the clipboard or get a fields contents to this application? Any help would be appreciated Thanks

Hello, Is there a way to close a program using send event? For example, I have a running program called "cmd.exe" on my memory. Could I have a plugins or send event to close it? I used "Moo plugins" to read the running process. Thank you.

Hi, Is it possible to execute filemaker script via VB on the FMS machine? will it still let me run none-compatible script steps? I would like to do an automated import (and its not web compatible : ), So I was thinking to bypass the FMserver somehow...is it possible? I do not wish to use a FMclient for this task. VB or any other suggestions?

I'm trying to replicate an outdated MS Access database solution with FileMaker and I'm currently struggling with the following issue: The Access DB can be called by a Windows start up link that logged into the DB and presents deadlines of tasks in a corresponding and consecutive number of windows (basically: "Task A is due in 3 days!", then you press OK and if applicable a new window opens, saying "Task B is due in 5 days!" or MS Access closes if no further tasks with due deadlines are present). The start up link for the MS Access DB looks similar to this: "C:ProgrammeMicrosoft OfficeOfficeMSACCESS.EXE" "C:FolderAdministration.mde" /x makDeadline /USER J…

Hello all, Is there a simple good email client that can support SMTP and IP address directly without having to deal with "security warning" pop up? I prefer not to use MS Outlook as my default email client. Thank you.

Hi everybody, I just discovered the following behaviour of outlook express (?) or filemaker. I have an email account which has a different reply-to address (it is the only account in outlook so it is also the default mail address). When I manually send an email from OL the reply address is correct, but when I create the email from filemaker (no dialog option checked), the reply-to address is the same of the sender (so it is wrong for me). Have evere experienced this "problem"? Do you know an easy solution? (I would rather avoid VBS and similar tricks). Thanks.

I would like to open and close an application using a filemaker script (I am using windows XP). I'm assuming you have to use a VB script. So I am wondering if someone can give me an example code of how to open and close an application, or point me to some online literature so I can get myself up to speed. Thanks Jeff England

I bumped into an odd problem while upgrading. I have an app that talks to FM via activeX. in version 8.5 all was good, but not working in version 9. On investigation I noticed that I had grouped the script it calls using the new script group feature ( folder) . When grouped, the script is not called and filemaker does not return an error via the activeX. I moved the script up before the groups I had created and it works! This seems like a bug to me. I also noticed the WRONG script gets called depending where I place the script on the sript editor window ( near top of list or down past the groups. The script that gets called is usually the tenth one down from the one…

using filemakerpro i use this sintax to create the Vbs object: Set FMApp = CreateObject("FMPRO.Application") Wich sintax for a runtime created with filemaker pro 8.5? please help me

Is it possible to send key strokes to other programs via a script in FM

Anyone know if a filemaker script can be triggered by a web page using activeX and "DoFMScript"?

I have a VB app that runs a script in FMP 8.5 via activeX. For the most part it runs, but about 1 in ten times it causes FMP to terminate in a crash. I can't seen to figure out why it is doing this. I am using very standard VB code for the call and releasing the variables etc when done. Windows reports this error: AppName: filemaker pro advanced.exe AppVer: 8.5.1.378 ModName: dbengine.dll ModVer: 8.5.1.378 Offset: 0007fde5 If you have experienced this or have sugestions I would really appriciate your help. Thanks Charles Delfs

Hi, Currently we're using web application hosted by Filemaker Server through ODBC. Im having trouble with this error. ERROR [HY000] [DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Query Failed;10/4/2007 10:44:12 AM The error occurs whenever one of our users in the web tried to create new records. Can you please advise what went wrong with this. Im still trying to figure out the cause of that error. Thanks. Your help will be highly appreciated.

I am trying to create a Visual Basic Mail Merge script that opens a predefined word document located in: (C:Documents and SettingsAll UsersTemplatesmailMergeTemp.doc), which has a mail merge data file already attached and is located in: (C:Documents and SettingsAll UsersTemplatesmMailMailMergeData.mer). The script below opens the word document but fails to exicute the mail merge command and i have to exicute it manualy by clicking on the Merge to New Document button. Any Ideas? Set objWord = GetObject("C:Documents and SettingsAll UsersTemplatesmailMergeTemp.doc", "Word.Document") ' 'Make Word visible. objWord.Application.Visible = True ' 'Make …

Microsoft Word [2007] is ubiquitous but instruction how Word and FileMaker can collaborate are scarce or nonexistent. #1 Example file from Jay Welshofer to generate a word document with XML/XSLT. Nice to see it can be done but not easy enough "for the rest of us". Download Link Example File How to build a template with header and other bells and wistles without spending hours? #2 Solution from chapsoft.com: Chapsoft It works. But every time you change a template you have to go through the tedious process to generate the appropriate XSLT. #3 Example file from Jay Welshofer to generate a RTF document: An XSLT stylesheet and supporti…

Attached is a File done in FM9. It creates a vbs script allows the running of some action, and returns a result to the file. I have used script variables so that values within the vbs script are more easily accessable and the scripts can be copied and pasted between files. (only the variables should need updated) This example does not include any automation of any other apps, rather it is intented to be a starting point. (If I get the time I may do an example with an excel) I have used the Temp folder to hold the VBS script as well as a text file. (So this file will only work in FM9 and on a windows OS) Using this technique, I have been able to (among other…

I have a file with a startup script that I am trying to call from a vbasic script. Basically I am trying to open the file and perform a simple Show All Records script. However, the startup script for the file performs a find, and when called via vBasic it performs the Show All Records script first, then the startup script. Is there a way to open a FMP file externally and then somehow test to see whether it is fully loaded or not? The file has at least a dozen related files that load as well, so initial startup takes quite a while and will vary depending on the speed of the computer. This means having the vbscript wait for a set amount of time will be frustr…

Is there any way of checking to see whether a script exists or not using a vbasic script (or similar)? At the moment I'm thinking of running the script and immediately checking the status (ScriptStatus) for a return value of 2, but I feel there ought to be a better way of doing this. Is there? I'm using FM6 for this at the moment, but I don't think the automation has changed much since then, has it? Many thanks.

Hi I've created the following applescript to create folders and open the resulting folder based on field info from two tables "tell application " & QMK & "Finder" & QMK & "¶"& "set clientsfolder to folder "& QMK & Our Company Data::Company Client Folder & QMK & " of folder "& QMK &Our Company Data::Company Folder&QMK& " of disk " & QMK & Our Company Data::Company Drive & QMK & " as string" & "¶"& "if not (exists folder " & QMK & Contacts::Company & QMK & " of folder " &QMK&Our Company Data::Company Client Folder&QMK&" of folder " & QMK&Our…

I'm not sure if I am in the right forum however I am trying to open an image file in its own program through a filemaker script. Is this possible

Hello everybody hope i'm in the right place to post this. I'm a new member, and these forums are quite big... Well, i'have made a FM DB with a large AppleScript program incorporated to add some editing image and FTP transfert funcionnalities. It works fine. But because AppleScript, it would not on windows OS. Then, is there someone who can indicate which ways should i take to "translate" my Applescripts in ... ? What is the equivalent on Windows ? I'm not familiar with windows but i'm using a lots of programming language, so, one two more seems not a problem ! Thanks A+R.

: How do you think it would be possible to notify a user in the LAN of an incoming "message" in FileMaker? (The message is generated by another user in the LAN also in FileMaker). In other words, how to display a dialog informing the user of an event in FileMaker? In Mac you can make FileMaker to trigger an AppleScript, also there may be a way to use Growl.

OK... So i was developing a DB is FP5 and have converted it to FP7 (using Dev). Pretty much all aspects of the DB in development are working well... But I need to call scripts from MSWord. This was working in FP5. So, I made the (what I thought were) the proper changes and it still didn't work. So, I created this simple VBA script and it doesn't work either. It assumes that there is an open DB, which there is, and that there is a Script named "_DDE_OK", which there is (it just sets a text field to "OK" and execs a SendMessage.) The msgbox in work fine and there are no VBA errors. Sub CallFM() '------------------------------------------------- …

Hi I want to be able to access GREP functions via the cmd line. I have downloaded a zip file (grep251b.zip) that I got from Matts website at ISO filemaker magazine. You can also download the file from this other website here. http://short.stop.home.att.net/freesoft/txtutil1.htm#grep Anyway Matts instructions were to install in C:/Windows/System32. I have placed the contents of the zip file in this location but I still get an error in the cmd line that says grep could not be found. Am I missing something....any suggestions would be great

Here is a file that will create an E-Mail allowing for Multiple Attachments. It uses VBS created in filemaker (Saves the VBS in your My Documents folder). It Creates the E-Mail in Outlook and sends it. Anyone know how to add a CC recipect for a mail message created in a vbs script? Or avoid the Security Warnings? (this was tested on FM_8.0, XP,and outlook 2003. It should work for 8.5 and Vista but have not EmailCreator.zip

Has anyone figured out how to fix this problem of Windows XP changing print specs when scripted? No matter if I manually specify the print settings then remove dialog; nothing I do seems to matter ... Windows XP will print whatever it wishes whenever it wishes. I've even added a Print Setup script-step first, specifying all of my settings. I ended up running the print process and backing it up by printing to pdf in case the batch needs to be reprinted. But since 90% of the time it is printing wrong, I'm going to have to SKIP PRINTING entirely and just save to pdf. When print dialog was available to Users, it STILL wouldn't do what they specified PLUS they would incorr…

Right, I have a need to link to a folder on a server from a filemaker 6 database. Basically I have a CRM database in Filemaker 6 and each customer has their own folder that contains word / excel docs etc. What I want to do is to be able to link to these folders by customer name. eg: servercustomerfredbloggs The first part would stay constant. (servercustomer) the customer name needs to be generated from the customer name field in the database! Stuck as to how to get it to work!

Is there a VB script that can execute a Filemaker script?

Hi Guys, I managed to run the vbscript. It does changes the printer in the registry and changes the windows default printer, but it still doesnt change the printer in the FM. Any help? The VBscript is as follows: Set WshNetwork = CreateObject("WScript.Network") set WshShell = CreateObject("WScript.Shell") Serv = "DBS-EMAC" Printhere = "MFC-9160" AddSettings = ",winspool,DBS-EMACMFC -9160" FullPrinterName = ("" + Serv + "" + printhere) WshNetwork.SetDefaultPrinter FullPrinterName 'This sets the default printer for the computer NOT JUST FILEMAKER WshShell.RegWrite ("HKEY_CURRENT_USERSoftw areFileMakerFileMaker Pro8.0preferencesprinter"),F ul…

Hi - I've seen several topics related to this, but none quite answered my questions - hoping someone won't mind taking the time. I have a runtime that will be distributed protected by Software Passport (armadillo). However, I'd like a way to make sure someone didn't just re-create the runtime from the database file. The way to do this seems to be to check for environment strings set by Software passport. These can be retrieved by some simple basic code. The question then is now to a) run this simple code from a FM Runtime, and trigger a script in the runtime depending on whether the correct environment strings are found. It sounds like I can use the Sen…

Hi Ive searched 2 hours to no avail and am sure this is a dumb question but so I need to ask it anyways. Im trying on Windows XP to use the DDE Execute Script step to: 1. Create a folder if it doesnt exist and 2. Rename a file in that folder I like the DDE method as it means no plugins or similar haveto be distributed with my FM Solution, which is designed only for WINXP at this time. QUESTION. What do I use as "Service Name" and "Topic" to get it to work? My command is (for testing and its not working) "cmd /c rename C:FM_Backupcurrent_clone.fp7 C:FM_Backupcurrent_clone2222.fp7" For service name I tried, cmd, system, and everything else u…

Is there a way to make a script that starts an Outlook Task function in Outlook. I would like to use outlook to assign items for my team to complete. If there is something that anyone knows of that would let FM do this please tell me. Thank you, Joseph

I'm working on a project where I need to drop a text file into a folder, have it automatically save the filename, open our FileMaker 6 database on our server, find the corresponding record that matches the filename and run scripts to import that file... then move the text file to a different folder. I'm having to accomplish this using a pc w/Windows Server 2003 SE (yuck). I'm not having trouble with the scripts in FileMaker, but I don't know where to begin to automate the folders on a pc. Can someone send me in the right direction of the how's and what to use? Thanks!

I have a question on how to access the properties and methods of an ActiveX control that is in a container field. I have put a control called Dolphin Image Control that looks up images in a 3rd party program based on an ID property. The image shows just fine in the container field but the only way to change the ID property to a new ID number is to right click the container field that has the control in it and select the "Properties...Dolphin Image Control" option which then brings up a window that I can edit the properties of the control in. I need a way to automate editing the properties from scripts in FileMaker, is this possible?

How to create empty Folder with VB Script in: Disk/Applications/ FileMakerPro8.5Advanced/ ? Thanks in advance Zagino

Hi Guys, I need to activate the default screen saver using FM 8.5 on WIN XP. Is there someone that can point me in the right direction to achieve this in the simplist way possible? Many Thanks as always Jalz

Hi, Is anyone have/know/like to sell VB or Java script which will automatically send file (jpg. or mp3) from FM database to mobile phone in bluetooth range? Thnx in advance Vjeran

Hi, Has anyone an example of invoking of Oracle stored procedures from FM8.5 advanced? If possible with input and output parameters and how you bind the returning values from Oracle database. Thank you. Gavril

Hi there, I need your help in this since I couldn't find a clear answer... I have developed a database application in FM8 Advanced and I need to create another application with PowerBasic DLL that will need to draw last_name and first_name data from the records in the Filemaker database. Is this possible? Please my whole project depends on this, reply and let me know! Best Regards Ted