Developer Tools

I have a two container fields. Both are having a a small images. Then plan to add this two images at calculation fields. The calculation field will not display the combination of pictures. But it will show the single image. Is anyone know about to join the two container fields images. ple let me know.. Many thanks

Hello, I need a handy way to prevent my users to close Filemaker from the Windows red X. Is this possible from filemaker or I need to find a way to do this in Windows I appreciate any help Thanks

Hi, I'm breaking my brains over something that should be as easy as 123. I have a global text field where a user inputs a 'period-' or 'comma-' separated text in a custom dialog box. I then want to run a script that separates those values, eg. "456123.785412.255879.225788" and creates a new record for each of them. I used PatternCount(text, ".")+1 to have a variable for the loop, but how do I extract the actual values? As php explode and a while loop would do... Help appreciated.

I'm stuck with a bad layout that probably will take hours to finish rendering. It's not abort-able, and the only thing I can do is force-quit Filemaker. Unfortunately, this layout happens to be the one automatically chosen when I first open the database. Are there any steps I can take to deactivate this? (In case it matters - the layout is a list view, and I think I've got funky conditional formatting on each row. A "find in progress" dialog pops up for several seconds, then disappears, and the next row of my layout appears, then "find in progress" appears again, then another line is rendered, etc. Around 5 seconds per line.) Thanks for any help - Chap

I haven't seen anything or read about anything myself but I just wanna make sure I'm not missing anything. I'd LOVE a way to push updates to end-users of a runtime. Right now they have to export, remove, re-install, import. Kind of a pain.

I have developed a runtime solution for an inventory database. The database and the runtime solution runs/functions just fine on my computer (OSX 10.5, FMPAdvanced), but will not run another computer (OSX 10.4) that does not have FM installed. The user gets the message "This action cannot be performed because this field is not modifiable." when they try to enter and/or delate a new/old record (new inventory item). The "new record" and other actions are greyed out on the menu bar. I am following the manual/book directions to create the runtime solution (I think!). Does anyone know what I might be wrong? Thanks in advance.

Hi everyone... I am working on something for a customer when my colleague suggested this and I was intrigued by whether or not it has been done before / is possible. I am providing a customer with a .exe standalone application for a rather basic database. However, I was wondering if it is possible to either embed or trigger a windows script that installs a font required for particular layouts on the hosts computer? If this is possible it would definitely make my day!! If anyone knows of a way or any ideas please let me know. Best regards, Jason V.

I have a client running a FMPro 8 runtime solution on a Vista box. (FYI: The runtime was originally bound on XP but when she upgraded her OS, it still continued to work.) She recently experienced a Vista crash while the runtime was closed. However, when she went launched the runtime after the crash, all of her records entered the previous day were now missing. She did not get any errors regarding file corruption. Is there a way that Vista would have somehow rolled back her files after the crash? And, if so, does that mean that her data is, indeed, lost? Thanks in advance, Yvonne

Here's an odd one maybe one of you seasoned developers can figure out: I burned a runtime for a client that's been working well for them for over a year. Recently, they copied the whole runtime file to a new machine and when they launched the runtime they got the attached error message. After the user clicked OK, FM asked them to find the USR file. The user selected it from the list, then double-clicked the USR file icon--the runtime launched. What would cause that? Is there a fix/patch I can make short of re-burning the runtime from scratch? TIA for your help! Rich

This problem started on version 9 but has continued under 10. Creating a runtime solution works fine and so does saving the settings, but when I try to load settings, the app crashes. I click the Load Settings button, but as soon as I select the file and before I click the Load button the beachball of death appears and the app crashes. This is not a problem on my PC - only on the Mac. Any Mac users come across this?

I am an experienced developer but not particularly with FileMaker ... I've been asked to make some changes to a client's database. They are not very complex things - mostly layout-related, a couple of simple scripts - and they've sent me a file which contains the structure and the data (four tables). What I am trying to determine is: how do I update their structure with the changes I make? Do I have to actually go over there with my modified copy of the database and copy my modifications over to the live database? (they are not able to open up their network to allow me to log in remotely). They are on version 8.5; I currently have Developer V7. I understand that I c…

I just discovered that during the creation of a stand alone FM application using the Developer Utilities all links to external data sources (other FM files) get stripped of their extensions. Thus, if the path used to be: file:old_data/Address.fp7 it becomes: file:old_data/Address Naturally, any script that requires the file Address.fp7 fails. To me this is a major, extremely serious bug that destroys the functionality of my stand alone solutions. Does anybody know a workaround?

EDIT: the .exe opens everytime but not the .usr for some reason. File name has _ in it.. make a diff? It worked before. This is my first attempt at a runtime but I'm a long time FM user. Hopefully not to vague but I went through the developer untilies....da da da da da... runtime created in folder. I copied the folder onto another PC to test and I double click on the .exe but nothing opens. In reading the help files I see: "After a user has run the installation program for your runtime application, the files are installed on the user's hard drive. The solution's three-character filename extension is registered with the operating system (Windows) or …

Hi, How can we use runtime application across network. I am new to filemaker. Want to make use runtime application like normal client-server applications. Thanks in advance. Padma

?? Does it make a difference? I know you have to bind for either Mac or Windows but I'm curious if there is a version difference also.....

There is very little documentation on the Design Functions for Calculation fields, it seems to me that there are some limitations but I am open to other explainations if someone has one. I am trying to use FieldNames(fileName;layoutName) to grab all of the field names for each table in each file listed on my layout. What seems to be happening is that there is a limit of 4,562 characters. It imported 442 of the 562 feilds in the file I am accessing. Any thoughts, besides using/parsing the DDR file.

I see that esign offers a solution for this but I was wondering if anyone has done this with another solution. I am needing a basic signature box for the client to sign. Then I need to save it in the DB. I was pondering writing a VB.net application to capture the signature and somehow call it from Filemaker and then have the VB app save the signature to a file and then use a filemaker script to import the file to the DB. Seems a little cheesy to me. Any Ideas? Thanks Thom

FileMaker no longer displays any graphic elements on my main development PC -- but with the strange exception of runtimes that were built a few months ago. This problem first reared its head a couple of months ago when I had installed a test version (a built runtime) of AppA on drive C: of my development PC. It worked fine the first couple of times I ran it -- but then it lost its graphics. At that time, I thought I might have overwritten one of the files in the runtime's directory and was busy on other things, so I moved on without giving it much thought. My application development environment continued to work just fine -- and all subsequent builds of AppA wor…

I can make a Database Design Report in HTML and this format is accessible without a problem but when I try to make it in XML format, I get a message that it cannot be opened. Where am I going wrong? I'm trying to use it with BaseElements but am stuck here. Thanks.

I am using FM 9 advanced on windows. I have a solution/database I distribute with runtime. It currently only makes windows apps. Is there a way to make it run on Mac as well?

Can FilemakePro 9 perform as a file server on a local network without each computer on the network having it's own copy of FilemakerPro installed? If so, how many computers can share a file at the same time? If not, is there any version of FilemakerPro that can share files without every computer having FilemakerPro installed?

Hi all, Hopefully someone has had the same idea and can tell me how to do this... I'm developing a runtime app that so that several people can access the data that is in a server, so that they can access/add/modify that data, but without having to purchase several copies of FM Pro. Any ideas/links on how to do this? Thanks!

I assume that the hardware and system requirements for runtimes would be the same as for the regular Filemaker application. I'm not too conversant with Windows machines, and don't have much hardware to test things out with. However, it looks like there are still a lot of people using Windows 2000. The Filemaker Developer manual only says that the runtimes have been tested out on XP and Vista. Does anyone have any experience using runtimes created in FMA 9 on older systems? Likewise, on the Mac I believe the earliest compatible OS is 10.4.8.

Does anyone know of a good explanation of the steps necessary to update a runtime solution (FM9 Advanced)? I can't find anything specific in Help or elsewhere.

Hi I think this is a simple problem that im just overlooking something. I have been happily making runtime databased in filemaker pro advance 9 for a while now. How ever all the ones I have made so far have only been needed to run on mac but I am now required to produce something to run on a windows machine. how would i go about this ?

I have not used BaseElements before. What are the pros and cons of it verses Inspector? Also, on their website it states the following regarding the site license: It allows you to use this copy of BaseElements either in a FileMaker server amongst multiple developers, or as single user versions on an individual's machine, or both at the same time Does this mean that Base Elements is served as well? Can multiple developers see it at the same time? I am not quite sure I understand how this would work since you would have to pull the DDR. Can anybody comment on this?

Hello - long time reader, first time poster. : I've almost completed a custom Filemaker Runtime application, but have noticed when it's compiled the Splash Screen has gone. Is there any way to make a custom splash screen or just re-enable the standard one? Without it there's just a long pause before anything happens which obviously isn't good. Any info appreciated. Thanks.

I make a report of client charges, there are several kinds of charges, one of which is a flat $75.00. The report is a simple alpha list by client name of the charges and a summary total. How would one make a report of client charges in a particular month BUT ignore the $75.00 ones?

Hi everyone, Is it possible to eliminate the username request when you open a runtime for the first time on a computer ? Another question... does someone know a way or a free (cheap) plugin that can hide the menubar completely ? I know fmsecure does that, but i'm wondering if there are other(less expensive) ways. Thanks in advance,

Hello Folks, I work in the film business and have used an electronic purchase order database (to stop using so much paper)as a runtime since runtime was available. Recently on the upgrade to FMP Advanced 9.03 I've had two problems. The runtime uses 5 different relational databases with the "POLog" being the main one. I wrote a script that asks the user to save the POLog under a another name so I can preserve the original file. (It automatically generates new PO numbers in increments of 01). For some reason after that new file is made and the program is quit, as I reopen the new file it sometimes tells me it doesn't belong to the solution as well as opens the original …

I'm curious if anyone here has ever created a freeware runtime. If so, what did you do about the requirements to provide customer support? Obviously, when putting a runtime into the public domain, one shouldn't necessarily be expected to provide telephone support to anyone who wants to use the program the same way one would if it was a commercial application, but you are required by the Filemaker license agreement to do exactly that.

Hi, I am a complete newbie here (been a member for about 3 minutes) but have spent some time lurking as a non-member reading all your posts, and you all seem very knowledgeable, so I am hopeful of some help. (I apologise for the lengthy email, but I wanted to include as much detail as poss.) Although it seems that this problem has been alluded to before (http://fmforums.com/forum/showtopic.php?tid/196394/ ), I cannot find a solution (Forgive me if I have missed it - please direct me to the page if so). I am developing a FM solution that I originally wanted to distribute as a runtime. The reasons for runtime were: 1) Ease of use 2) I am charging a sub…

In the Relationships section of the DDR, some of the table occurrences are highlighted in red. They are also highlighted in red in the Relationships: details section. What does this mean?

I'm just wondering how experienced FM developers are handling the issue of automatically updating a runtime solution after it has been distributed? That is, is it easy/possible to fully automate the import of the user's data from their old copy of the runtime solution into the new version? I have been playing around with this using the 'Import Records' script step, but I don't seem to be able to fully automate the import such that the Import dialog is never displayed to the user. I don't want the user to ever see the import dialog because I don't want them to be able to change the settings and thus trash their data. Thanks. John

I tested a solution with the security setups and menu controls as I wanted them and everything worked fine. So I created the runtime solution and proceeded to start testing. The solution is set up to import a file of background information into the solution. Then it imports (asking you to locate the file) some names. I thought it worked okay, except when I went to print the list of names with background info, it didn't print the names, just the background. Yet, this all worked in the solution before I bound it into a runtime. I'm stumped!. Any ideas? Thanks for your assistance.

Hi I have had this problem for a while. I produce a DDR for my solution and everything is fine. However there is one specific script that is used. When I look at the DDR I choose the script section and then look at the specific script. It tells me that no layouts use this script and no scripts use this script. However the script is assigned to a piece of text on a layout. This layout is basically a tab panel and this script is called from the second tab. Its a basic script that changes the colour or the text from red to black or vice versa. The problem is that if I were to go on the DDR I would assume that the script is no longer used and feel free to delete it. I know …

Ok, so I just saw that runtimes don't allow for the use of plugins. Not happy...... if what I read here was correct. : In my database currently I have an option to send out emails using SMTPit. Several others would like to use my database but since they don't want to invest in FMP I thought I'd go as a runtime. What options are there? I know I can go with the 'Send Mail' script step but a couple of them use AOL... not sure that'd work. Ideas are always appreciated!!

Hi, What would be the best practice to make offline use of a database? In my company, we have an online FM DB that we work with. We also have some UMPC that we use on the field. I would like to allow the user to work on there DB records while they are outside and then resync the records on the main DB. Any advice would be great. Nick

My understanding is that because I have the developer edition, I can generate a distributable runtime version of my database solution. But can I generate both Mac and WinDoze versions of that distributable runtime solution from my Mac?

I was going through the DDR to find unused value lists to remove and I found a couple that said they were used on a particular layout, when in fact they no longer were. If you look under the fields for that layout in the report, none of them shows the value list being used. The value lists had been used on the designated layouts at some point in the past, but they were removed long enough ago (weeks, maybe months) that it couldn't be an issue with cached server data from the current session. Could it be a situation like with global fields, where the information can't be permanently updated unless it's in single-user mode? Or is it a possible sign of file corrupt…

I have a user who has twice now had their indices clobbered in the last month (no other user has ever experienced this problem in 7 years of deployment. I have no idea what could be causing it to happen). I am able to fix their database by simply importing the data into a clone of the database. But that requires them sending me the database, doing the import, and redistributing it. And if I'm not sitting by the phone, they can experience significant downtime. Is there some strategy/function/script I can implement so that they can cause the indices to be rebuilt from their user interface, or am I stuck with getting involved should it happen again? I don't wa…

Hi, I want to make a solution with multiple language option. (I am currently using Central Europe version of FileMaker, supports Turkish interface) Let me summary the stuation. I have 3 Runtime Folders. (with same binding keys) a- For adding and editting records b- For Turkish distribution c- For English distribution User use folder a for data entry. Then run the "prepare files" script to place lastest file into folder b and c. (only .usr file, other files are already placed) I want to runtime exe in folder b runs as Turkish, runtime exe in folder c runs English. Runtimes are open in Turkish as default. I have open Runtime in folder …

I want a confirmation dialog before the file closes.. Under File->File options I can Filemaker to run a script before the file is closed. I put a confirmation dialog there.. but I can't find a way to do an "abort exit" in case the user hits cancel. What should I do so it cancels the exit?

I have a very small single file that I wanted to distribute as an executable so I used the runtime solution. It created a directory full of files along with the executable. Do all these files have to be moved to the users machine for it to work? If I create another application will it also create a number of files? As an aside, if I have an application that uses 7 independant files in one solution can I create one executable for the whole thing? Mike

How to host Run time solutions on Server? I am using FileMaker 9 Server Advanced. Are Runtime solutions created only for single users? Can they be shared? My solution involves complex Menus and Dialog plugins. Can I host/share my runtime solutions that needs plugins to be used as well? Please suggest. This is what I know about Runtime solutions Runtime solutions for Single User Runtime solutions can be created and deployed easily for single user very effectively. There is no need of FileMaker Pro to be present on the machine for running the runtime solution for single user. The Runtime solution needs to be tested thoroughly before it is deployed…

What installer builders or other packages work for distributing runtime solutions to remote sites? I need the installer to replace the current versions of the runtime and other support files when doing an update.

Hi, I have created "Test Menu Set" in FileMaker 8.5 and FM 9. I need to get rid off the "Tools" menu. Can we remove this "Tools" menu from our menu set, or is there any mechanism by which we can disable the Menu items in Tools Menu set.

On my BlackJack NAMED computer run FM ver 9 and our application NOT COMPILED On my laptop... runs FM 8.5 with different license key... I bring up FM,, open remote... and my Blackjack computer display with IP address 198.196.1.10 It WORKS BUT instead, If I run a runtime version of our application on my Blackjack named computer The checkbox for filemaker network in checked in previliges I do not see Blackjack computer on 2nd computer? Need help? Thanks

Does anyone know of a way (plugin or FM native) to join two images together into a sinlge image in FM9? What I would like is something similar to what 4D has where you can just add pictures almost like concatenating text fields. Now..I know I can use AppleScript/AppleEvents on the mac side to access OSX's image manipulation libraries, and I can probably find something similar to control through VBA on the win side. But I really don't want to go to that trouble and complexity. All of the image plugins that I have seen for FM allow image manipulation (rotate, resize, resample, etc), but don't seem to allow for expanding an image's 'canvas' or for manipulating spec…

I have a report with a Time Column, with information collected from users through a Start & Stop Time Tracking process on another layout. It shows the elapsed times for their projects from that user. Is is possible to show a Total (at bottom) of all the times in this column on a report layout? I have only a basic knowledge of FM. Thanks in advance of any help on this issue! Fabian

While executing FileMaker 8.5 Runtime on customer's machine, it crashes and does not open. Error is returned by windows xp (Send Error Report dialog appears). Error dialog details is here: AppName: fiyat listesi.exe AppVer: 8.5.1.89 ModName: lmabb2dd.dll ModVer: 0.3.0.0 Offset: 00014170 Anyone has the same problem before? How do I beat this problem?? Thanks in advance.

Is it possible to get the height of a layout part? I don't see a 'Get()' function for this. thanks. John

This has been a huge limitation of FM from the beginning.. has anyone come up with a convenient/simple way to get the contents of a subsummary to repeat at the top of each column or page? This seems so essential when printing summary reports where an individual section may span across multiple pages or columns. Thanks. John

I have a runtime solution that I distribute annually to 100 users (entry/registration for an event). It has worked well when created in Fm8. Since it wouldn't work on Vista, I upgraded to Fm9 and re-distributed. It works on XP and Vista, but won't work on Win2K (I didn't know we still had them.) So I went to my old computer, re-compiled the files using Fm8, and sent that out. It still won't work on Win2k. Is it because I've opened the original files in Fm9? Is there a work-around to get a version like the previous one? I can't go back to last year's file because it's an annual update with changes, so this year's solution isn't the same as last year's.

Hello all, I have a FM Dbase runtime developped with FM Adv but for Win32. Can I use that runtime on a mac ? If not directly, is there a way around ? Kind Regards

Can a run time solution be related to a networked multi table solution? I have a networked solution of multiple tables with patient data, patient interactions, patient services and products all related by the various ID numbers. I would like to give the patient a copy of his/her interactions on record (on CD or Flash memory stick) in the form of a run time solution. My plan is to make a run time solution that is a mirror of my solution but only containing that single patient's data. Before going to the trouble of making a run time solution, I want to find out if my plan is doable: make a relationship between the run time solution tables and the tables in the n…

Please pardon my ignorance but I have just been posed with the following question and I'm not entirely sure where to post it: can filemaker/ Filemaker server be used over Citrix on dumb terminals? basically we have developed a database for a client who are currently in the process of moving there IT systems onto Citrix, now the question we have been asked is can a multiuser database built in Filemaker still be used by everyone in question on a Citrix system. If so is there anything we need to do to make sure our database will work on our clients new system. TIA for all your help :

Hi all, Is there a way to set up to Open a remote file directly when you click "Filemaker" icon? For example, a user will click Filemaker to open Filemaker application. Instead of he or she is choosing the right database, I would like to automate it. When a user double-click the Filemaker icon, I would like to take directly him or her to appropriate remotely database (without having to choose it manually). Is it possible? Thank you for ideas and comments B)

I am having a few problems with the setup of Bar Coding. I downloaded and created a calculation field(barcode) with code139 font. Thus, the bar code has been converted and I can print them out fine. : [color:red]My problems comes on how to setup the database to read them. I purchased a IDAutomation USB Barcode Scanner to do the reading. [color:green]I need to make two scans--One with the item and one with the quanity. I can set a script to call a form with item, quanity on it. When I scan-- [color:red]Will the item number be put into the field? [color:red]How do I move to the next field(need a tab somehow)? [color:green]Doing a scan of the qua…

Hmm. Apparently using the Mac version of FM9 Pro Adv. you can't make a Windows runtime, am I right? Unfortunately the sales literature is not clear on this... and I told several Mac haters I could develop a solution for them with my brand new Mac Pro Advanced Upgrade. Is my only answer to buy an entirely separate copy of FMP9 Adv? Is there a Windows version of the program on the CD-ROM?

Hi all, Do you know how to bypass the starting initial input? For example, if you create a new "Window user ID", login with that ID, and open the FileMaker. It would show a small textbox that shows to input your Initial, let's say: JD (JohnDoe). My question is if there is any possibility to skip this small initial textbox dialog and process directly to the main layout / scripts? Recommendations or suggestions or ideas are appreciated! Thank you in advance.

Hi All, I have a reasonably complex application built over many years made up of 20 separate files/db's all with many relationships to several of the other files/db's. I am thinking of combining all the files/db's into one, and I understand Filemaker Advanced (I just have FM Pro) lets you import tables, and copy/paste layouts & scripts. However in the FM Advanced doco I see no mention of importing realtionships. Does this mean you have to manually recreate every single relationship, and find and debug every instance where you've used that relationship? This looks like a daunting task when I have so many files/db's and so many relationships. Have …

IS there any way to copy a table to put into another database. I tried Import it just brings in the format and the data but not the calculations in the calculated fields. I just need the Table Format and Calculations. Thanks The Tramp

hi is there any possibility to run a filemaker file on that computer where filemaker is not install.whether i have to create any EXE for that file Plz help me Thanks

OK, I really feel stupid now. Never looked at Kiosk Solution before, but think it might be exactly what I need for a new solution. Only problem is that I can't open the Kiosk Example in FMP 9 Advanced in developer mode. I would like to look at the solution and see how it was done but it will only open in Kiosk Mode. Any ideas?

I am creating an inventory database and maintenance is one of the things I am tracking. This means I need to know when it begins and ends. I am not sure that this is a "must-have' or that it gains anything but is there a way that rather then typing in a date I can cursor over this field and have a calendar pop up so I can select from it?

Hi - I'm aware that this issue has been discussed before, but none of my searches have turned up any real thorough discussion of many of the specifics. So I'm hoping I can get some input from folks here. I have a runtime solution I wish to distribute commercially to a consumer market. I would hope to have too many users for any kind of custom coded approach. I am aware of the many 3rd party tools for protecting the exe part of the runtime, but the actual database file can of course still be opened in FM software. Removing admin access prevents someone from learning the structure, but does not prevent them from simply distributing it themselves. I intend to …

Hi. Just created my first runtime solution on Mac and on Windows. On Mac the process generates: The runtime app A USR copy of the original solution A .pdf file An Extensions folder total: 85Mb On Windows, the process generates: The runtime app A USR copy of the original solution 30+ .dll files 3 Microsoft Folders An Extensions folder with 11 subfolders Total 135Mb It's hard to even find the runtime app in the mess of .dll files... What gives? Why the big leap in size? Is there any way to trim the fat? Many thanks for any help...

Can anyone help on how to avoid the "SAVE CHANGES TO THIS RECORD?" message. This is happening on my app when a user inadvertently click the mouse on outside the form's margin. I tried to get the error number on that without success. I appreciate any idea.

Hi, Does anyone know where I can get a copy of the source code for the included Kiosk demo called "Menu.fp7". It's the "World Class Burger" demo that comes with Filemaker. I sent the company an email and they don't seem to be very cooperative. Thanks!

I see that the runtime makes windows without close buttons (the X button that closes the window). Is there a work around for this? My solution opens the output (the reports) in preview mode in new windows. I could have them opening in the same window as the data input screens but then I'd have to figure out how to have the navigation buttons (custom navigation on my layouts rather than using the top menu and status area)displayed and active in preview mode. Thanks Pete

Hi, I supply a runtime database in the latest version 9 to a couple of users who have recently switched to using Vista. Before this, when upgrading my database, I would rebuild the runtime and send them a new copy. They would delete the old version or replace it with the new files sent. Yet on Vista, even if the old database and files have been deleted and the recycle bin emptied, opening the new database directs you to a copy of the old database. Anybody know how to stop this? Currently to get round it the new set of files must be saved into a new renamed folder.

I've been developing 2 solutions for over a year now and I'm enjoying every minute of it! But there's one thing that's really been bugging me for some time. I'm really tired of people calling MY solution FileMaker. I've spent THOUSANDS OF HOURS developing these solutions and I really think I should be able to have MY solution name showing at the top of the window. I've thought maybe this was possible if I compiled the solutions into runtimes but from what I understand if you compile you can't share or serve a database. Any Ideas? Thanks, Mel

I have a FileMaker solution being hosted on a Mac Server. I'd like to be able to run a script on that file that calls a script on a runtime master file that was created in Windows. I've been able to do this with a runtime created on a Mac. Here's the part I can't get around. A master file of a runtime that was created on Windows can be opened perfectly well by FMP on a Mac if you drop it on the FMP application or if you choose open file (the one extra step you have to do this way is select "All File Types", as the Windows master file isn't recognized as a FM file). Any help is appreciated. Thanks in advance! -Kent

I have a solution that has 5 open windows stacked one on another so that only 1 is visible at a time. If run when the monitor display is larger than the window, I use move/resize to position the windows in the center of the screen. The move/resize statements are identical for each window. In the case where the display is larger than the window, everything works fine until I build the runtime. Then the first opened window does not position to the center of the screen. The other 4 do position properly. And when I 'grab' the mis-placed window to drag it into position, it vanishes (not visible in task bar). Similarly when I grab any of the other windows, they vanish. T…

Just got a new XP Pro machine, and reinstalled FM Developer 6 and 7. I'm working on a project that requires that I create runtime solutions using FM 6. I tried to create a new runtime solution and all is well until I get to the specify file name extension screen. I leave the default .usr extension as usual. But now I get a caution dialogue box that reads: "The extension you selected is used by Windows or another application." There's an OK button (even though it's not OK!) and I have to cancel the whole process. Here are the troubleshooting things I've tried: 1) uninstalled and reinstalled FM6; 2)uninstalled a MS SQL server printer activex control I recently add…

One of my files has been damaged after the server being restarted.It always "Closed" in the Server Admin. I have copied it to my desktop and try to open it, but always failed.Even when I try to recover it by itself and by the tool FileMakerRecovery, it still failed with the warning dialog " The access privileges of this file have been damaged and possibly tampered with." How can I fix the file without losing my records? Would you be so kind to help me? Thanks a lot!

I have a runtime version of a solution that I would like to create an desktop alias to on a PC. How does one do that? I'm a Mac user, so that is the platform I'm most comfortable with and only look at the PC to see what tweaking a solution needs. The PC help files weren't much help. Thanks for your assistance.

I've built a runtime, that works fine, except on OS X (I haven't tested windows), it instantly crashes the second time it's run. The only workaround I've found is to delete the preferences file before running it. Rebuilding it from the FP7 file etc has no effect on this behaviour. Also, I've noticed that the preferences file ends with "Pr#0" rather than "Prefs" like the standard FM preferences file. Is this normal, or could it be part of the problem?

I have a very complicated report that I must design for our company "Satisfaction Survey" system and not sure the best way, programmatically and design type. For you report guru's this should be a reasonable challenge as for me, it is rather difficult. I'm looking for a way to get this done and quickly. I have a database that contains 26 questions. 23 of them use 6 radio buttons (1 thru 5 being from excellent to poor and 6th button is NA) and 3 questions are Yes/No responses. Database is setup into 5 various tables linked together by a survey number. 4 of the areas (which point to 4 seperate tables): Scheduling, Education, Accommodations and Customer Service. (s…

Is there any function in FileMaker 8.5 to show who is currently accessing a record in a multi-user network environment? I would like to make a field that would show who is currently modifying a record or at the very least to show that it is currently in user by someone else.

Hello, I upgraded from Filemaker Developer 7.0 to Filemaker 9.0 Advanced. I designed a runtime solution and use MindVision Installer to run the setup on my end users systems. Some of my clients cannot open up the runtime, they get the following message, "Required DLL File MSVCR80.DLL was not found." I have no idea what the problem is. If anyone can help me out on this problem, it would be greatly appreciated! Steve

Hello!!! Here I attach my table with a "custom function" (Superlog, by Nightwing) that logs all the changes I make in my table. I have 2 questions: 1) How can I limit the log data? I mean, I only want to save the last 5 changes... I don't really know about this custom stuff... I'm too newbie 2) How can I set a calculation with the logged data... Here in my table I have a button that tells me the last modified record, and what was that change... but what I want to do is to find the changes I -the user I use is called Lucas- made, but not the changes done by the other user 'María' (I have this system in 2 computers)... Well, I hope you can understand my bad English…

I work for a large manufacturing company. They do EVERYTHING (analytically speaking) in Excel. I have been using FMPro for a number of years. I have created a database for managing all of the utilities accounts I have to pay as the payables analysts for the company. I using the project to develop my skills with FMPro. Since I don't have Filemaker on my work XP computer, I develop on my MacOSX (Leopard)using Adv8.0. I create the runtime. It all works great. I am trying to put a BACKUP script in. I want to back up the database file (Utilities.tk1) to a folder on the network. When I am on my Mac, I am not connected to the network. I am usually at home…

Hi all, I have a data database in filemaker 9 that I can save current record as pdf and then email by script ,however when I convert to runtime this feature does not work ...any help would be appreciated ...I dont really want to go back to a 3rd party pdf driver

I have found 4D development tool. Has anyone tried it? It seems much more advanced and easier to use than FM! Does anyone have any opinion? Here is link to their site: Link

Hi all, After making the initial release of my filemaker solution, people will hopefully download it and install and use... When, I upgrade the solution's version by adding fields, tables, scripts etc; Is there a secure/accurate way of upgrading the solution on people's computer without altering their already recorded data ?? Regards and Thanks

Hello, I hope that some of the gurus of this forum can give me a clue for the following matter. I have developed a small filemaker solution for invoicing purposes and I am still developing it,adding new features when required,but costantly. the question is:how to have a multi-company database ? For example: I have companies A,B,C. How can I handle the invoicing of company A company B or company C, using only the main invoicing solution that I have developed? If I should use 3 copies of the solution that I have created, anytime that I make some changes to my invoicing solution, I should update all the 3 files. I want to avoid it. …

Can a runtime solution be shared by multiple users on a local network?

Is there a way to configure the create runtime process so it doesn't copy runtime solution files and dictionaries each time? It would be nice to speed the process.

Is there a way for a server based FM file to connect (run a script) in a file stored locally on a computer? I have a filemaker database on a FileMaker 9 Advanced Server, and created a "launch file" for users to put on their local machines. My idea was the following: upon first login the user personalizes his copy of the launch file: username and password are stored in a field. He can then connect without having to type his information every time. The information is transmitted to the server-based file, which contains and manages user accounts, redirects, etc. This would allow me have one and the same launch file for all users/clients using the system. …

Hi all! Im not sure if I posted this in right department but here we go: I have made a solution for an auctioneer. At computers monitor (19") I show all items as a List with one kind of layout. On another monitor (4") connected to same computer I would like show as a Form with a different layout. Is it possible? Best regards -Per

Is it necessary to have the runtime file in the same folder as the data file(s). This is an issue with Vista. As I understand it, the runtime should be placed in the programs folder. If the data files are in another folder (documents etc) will clicking on them launch the runtime. And then again, will launching the runtime automatically open the data files from their folders. Bob M

The application component of a runtime solution apparently has some high-level protection that prevents it from being overwritten during a copy or install operation. When deploying new releases of my software, I want to be able to replace the current application file on the users computer to assure they have the latest update of FM as well as the latest database structure/scripts/layouts etc. When copying the new application folder over the old one in a MAC environment, an error occurs preventing the copy from completing. The message "The operation cannot be completed because the item 'FMStrs.dls islocked'" is displayed. (This also occurs when trying to empty trash …

What can make a DDR to freeze FileMaker ? I have it with one file. Even a clone, no records, DDR freezes, somewhere half way. Should I make a recover on a empty file and try ? The application is not so heavy: 48 tables, 3500 records average, grows with 860 records avg/month, 168 scripts with 76 sub script, 78 relationships/TO's. It's running without problems since the start, only no way to generate a DDR.

Greetings and thanks in advance for your time. I'm planning a FM runtime solution to provide desktop functionality to replace a a web-based app I had developed a while ago. I'd like to be able to update the application without overwriting the user's data. Is this a built in feature that will happen without me having to think about it? If not, what is the recommended method of doing so? Thanks Pete Bowen Ex Access Fan

Greetings gurus, It's my intention to develop an app that is paid for on a subscription model. I was thinking of having a database with the paid status and having the app check paid status at startup. Runtimes can't access external databases - any suggestions as to how this could be done would be appreciated

first of all, happy new year! i have a runtime database that i would like to share on our network. the thing is i would like to grant database access (ADD, DELETE, EDIT) to users based on field content. for example: i have a field called: COUNTRY, with a value list of countries. - i want to grant USER1 (with his own password, of course) VIEW ALL but ADD, EDIT, DELETE only if country is U.S. - i want to grant USER2 (with his own password, of course) VIEW ALL but ADD, EDIT, DELETE only if country is U.K. - i want to grant USER1 (with his own password, of course) VIEW ALL but ADD, EDIT, DELETE only if country is ITALY and so on. is this possible? thanks.

<> Is it possible to assign a custom-made icon to a runtime? There's no obvious file extension (other than .fp7) that I could use to associate the file with it; there wasn't an .scr association listed anywhere, either, so...? Cheers, Rich

ok i have this Button on this Layout (LayoutA)what i want is a script that can create a new record on a different layout(LayoutB).. (im good up to there) but i want to insert the MemberID number from LayoutA into MemberID field on LayoutB.. how can i do this?