FileMaker Legacy fp3 and fp5

http://www.thinksecret.com/news/filemaker7.html

I currently run FileMaker 3 under OS 7.5. What is involved in upgrading to FileMaker 6 under OSX 10.2? I remember reading somewhere that the file structure was changed.By the time I do this Panther will probably be available. I have one main file and three related files, with a few calculated fields and a few simple scripts. If complicated, is there a tech info document on this subject?

When you duplicate a record, is there a way to tell Filemaker not to duplicate a few fields? We have credit card information in our database and we do not want that duplicated over to the next record.

Hello, I have a basic db setup, but now I am looking for some really neat bells and whistles to add to WOW the user. If you are kind enough to share some of your creations, please give it to me in a "FileMaker for Dummies" format, I am just a Newbie after all. Thanks in advance Have a great day! Scott [color:"blue"]

I'm curious if it is possible for filemaker to call a phone number and play a recorded message via script. I'm not a telemarketer. I would like to have my patient database automatically call certain records and leave appointment reminders. Can this be done with some kind of plugin?? Thanks for any suggestions.

As I go thru the db's I notice that some of them don't have the LAYOUT stuff on the left and I can't figure out how to get it. Like one DB I know has 5 layouts associated with it but I can't select any except the first one because that whole area is missing and nothing seems to work to bring it back. What am I missing?

File Maker server 3.0 did an "unexpected shutdown". All attempts to bring the system back up failed. FM Server would start but the files would not open. So I tried to open the primary file with the FM3.0 editor and rec'd this alert box "The access privileges in this file have been damaged or tampered with" LUCKILY our daily backup had run about an hour before this and restoring the backup returned the application to service. Now, I have to know, what caused this. Anybody have any ideas? Did somebody really tamper with the file or is this just another FM bugga boo? Anyway to tell? Can I somehow recover the damaged file?

I have heard that going back to an old backup, cloning it, and importing records from an export of the recovered file is a reasonable way to avoid corruption problems..... But what if you are constantly updating the functionality of your database (adding new calculation fields, scripts, layouts, reports etc.) and you are not sure when the problems may have started to creep into the file? If you back to an old enough backup, you may be pretty confident, but it may not have your recent structural changes. Is there anything you can do short of taking all the exported data and rebuilding all the scripts (or importing them?) pasting in all the calculations and la…

I'm hoping that someone will have a suggestion on a different method to edit inserted objects. Currently, I have an inserted object (bmp file) that is activated and edited in Microsoft Paint by the user. The user is working with a tablet pc that allows them to edit the bmp with a pen. This works. However, it is slow as Microsoft Paint has to open and close for each editing occurence. Is there another option to allow the inserted object to be edited with a pen in Filemaker. I have seen a program to allow signature input in Filemaker. Is there a plug-in or program that allows drawing functions in Filemaker? I would be grateful for any suggestions.

could someone direct me in the direction i should take in order to correctly format bulleted lists in filemaker? it seems as though, when i insert TABS into the document, it will look great on screen, but printing is a different story. all the text gets jumbled around. any suggestions?

Sorry if this has been answered before, but I couldn't find it. The menu choices to show Toolbars at the top are disabled for some of my databases (but not all). I have no idea why! Is there a setting to change? Is one of my scripts causing a side-effect? A new, empty dbase does not have this problem. I'm not using OSX - I'm on a PC running W2K, using FMP6. ---

We have a global field in one of our databases that never seems to "remember" when new data is typed into it. The next time the database is opened, the field defaults to the old value. It's shared by FileMaker Server, but we used to have the same problem when it was shared by a regular version of FMPro. Any ideas? I'm about to give up and write an opening script that resets the field automatically, but that shouldn't be necessary.

Hello! Quick question: I

My office shares a database that is stored on a server. 2 people were correcting sets of files and unknowingly tried to edit some of the same records. This caused (we think) the database to crash along with the rest of the items on the server. So now, we've been taken off the server until the problem files are fixed. But our problem is that we don't know which files are broken! Or, might the problem be caused by something else? Any suggestions? Thanks much.

Is there a way that I could creat a script or something so that whenever an employee makes a change to a field in a current record it brings up a splash screen asking them if they are sure that they want to change this record? I don't want to lock them out of being able to edit current records but I do want them to be reminded that they are changing it. This happens because sometimes they think they are in "Find" mode when they are actually in "browse" and before they know it they have changed the record field and can't remember what it was before. Ron

I used FileMaker to create a database for my company's Invoicing/Quotation system. When creating Quotations for companies, there are certain phrases/words, etc that employees will have to use on a regular basis. In the past, Invoices and Quotes were made using Microsoft Word and there was a way of saving certain 'standard-text' into the program and then just inserting it whenever you needed it (to help speed up the process'n whatnot)... is there any way of doing this in FileMaker? is there a way that i can save different phrases/sentences/paragraphs in FM and then just choose to insert it whenever i need it? Thanks, Me

I created the phrase-field (i call it "Common Phrases") that holds a list of words (blah1, blah2, etc...) by way of a value-list. so, after creating this field, i'm able to click on it (while in Browse Mode) and choose a phrase (blah1, blah2, etc). The problem is that these phrases aren't being inserted into the field (a large, textbox-like field called "description") after i run the following script/button (just one line) Insert Calculated Result ["Common Phrases"] This is correct, right? so, while in browse-mode, i go to the Common Phrases field, i choose the phrase that i want, then i click in the "description" text-box, and then i click on the button to ins…

Hi all, I don't know if this is the appropiate thread but i didn't know where to put it else. I have a projectdatatbase. I am looking for a browser based calendar solution that can be synchronised with my database. Requirements. * Browser based * Drag and drop * Able to display different records from different databases. * Easy to use * Different views possible (per project/ per user/ per client/per vendor) Does anyone know if there is such a product available on the market? Hope someone can help me, Thx, Thierry

Does anyone know if it is possible to run FM6 on a Linux machine?

Some how I have changed the setting for the enter key to be the key that moves between fields in the layout view. I try to set up value lists and other similiar things and when I "enter" to create a new entry a carriage return is not created, it jumps to the next field. I checked preferences and a number of other places and cannot find where to change it. Can anyone tell me where to change the enter key parameter so that it is return carriage instead of to go to the next field? Thanks

I have one database almost completely done that contains information on students progress and students addresses and I want to create another database that has every record for the entire school housed in it...Im not sure if this makes sense so let me explain... I want to be able to have one database that each teacher can use to enter data about their classes...Then I want another database that will gather all the information from every teacher and house it in this database...Is this possible and if so how?

Is anyone else having problems getting to www.filemaker.com? It comes up with a search engine when I try going to it. I am trying to find the number for tech support. Does anyone happen to have it? Thanks, John

Hope someone can help. Let's say I want to create a database that has all my employees. In that database I want a couple fields named.. Total Employees and Total Engineers ect....How do I do these total field? I think I need to do some sort of calculation for that field but I have no clue on where to start. Thanks, Jaser

Hello. I'm getting near the end of creating a database solution for a dental practice. It currently has 17 files. A few of the files have a large number of fields(650), scripts(150-200), Relationships(70) and Layouts(44). The program seems to run very well. One of the larger files will probably only hold 3000-5000 records at maximum operation. I'm a little concerned about the complexity of a few of the files. They seem to do well. Should I be concerned about the above numbers? I expect to be networking about 15 stations for the dental practice. Comments or suggestions on how to avoid future problems or maintenance concerns would be appreciated. Thanks.

My wife Amie and I arrived a couple of days early for vacation. The resort (JW Mariott Desert Ridge Resort & Spa) is beautiful, perhaps nicer than the one in Palm Desert. The heat has been pretty bearable (in the low 100s) with very low humidity and a nice breeze. We drove here but got gas outside of Phoenix so we have not yet seen any problems in that regard. The resort have a variety of restraunts, pools, water features and even a lazy river for tubing. More updates to come directly from the FM Forums booth tomorrow!

All, I am a newbie at this so it might be really stupid question. I have a layout setup that lists out a form. column 1 QTY(quantity) column 2 Description (Drop down menu) column 3 Price per unit column 4 Price (Price per unit x QTY) - Currently I have to enter Quantity(which is correct) - Then I select an Item from the Description Column (these are listed values) - At this point when an Item is selected I would like the "Price per Unit" to automatically enter but I don't know how (currently i need to manually enter the price) - Then the Price total does a calculation of QTY x Price per Unit I don't know how…

Are the curent versions 100% compatible, such that data files can be exchanged over the internet after being modified under either system?

plz help, I get event id 1008 and 2003 happening every half second. the errors are: source perflib - 1008 The Open Procedure for service "FileMaker Server" in DLL "C:Program FilesFileMakerFileMaker Server 5.5fmsperf.dll" failed. Performance data for this service will not be available. Status code returned is data DWORD 0. and source file maker server - 2003 The description for Event ID ( 2003 ) in Source ( FileMaker Server ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: The event log file is corr…

I just have the basic Filemaker Program? I need to make a web page, and need the server, is their an all in one program?

Is there any way to "capture" the Enter key, to do the following: Signal the end of input (like the Tab key) Script another action depending on the field In other words, I would like to make the Enter key into a keyboard command that will then run a script depending on what field the cursor is in when the Enter key is pressed?

OK this is probally a really dumb question but I cannot figure it out. I have created a report to show our jobs in progress. when I run the script to view the list I can see all the records. When I print the report I see only the 1st record. What am I doing wrong??? Warren

I've been using Filemaker for some time now (since FMP3), but this is my first experience with Developer. When I create a runtime solution, it seems to run fine on my PC, but when I load it to another PC, even if that PC is faster and has more disk and RAM, it takes forever to open the application. It appears to be opening when clicked (hour glass blinks), then the hour glass disappears (returns to normal cursor). About 20-30 seconds later, the application opens. Sometimes it takes trying to open it twice. Anyone have this problem? Am I doing something wrong. (I read the instructions for installing a runtime application and I think I'm doing it right!) An…

Hi all, Sorry to be posting on this forum, this question really belongs on FMS forum, but I need help urgently. When I run FileMaker Server Comnsole, icons are not clickable at all. I was able to get to properties, and set # of databases hosted, etc. But I can not get to Task Scheduler for the life of me. Anyone know about this? Thanks

Can anyone tell me if it is possible to sort portal rows by a number field? I have a priority field and would like to be able to sort it so it reads in numeric order in the portal. The only way that I have found involves import and export and I'm hoping there is an easier solution.

Hi there, I have created a runtime solution system which contain 24 database files. This system i run with kiosk mode. I found that sometime if i keep on using for long time, the system will hang after i press some button. The mouse will change to loading icon as usual, but the system will hang on that time. The mouse still can move but it can perform any action. The only way i can go out is i press(Alt+Ctrl+Del) to exit. But after i open again, the system will run as normal, and the button that make the system hang also function correctly. I have using try this system for few days and face this problem 3 time. One time happen when i click on the button with insert pic…

I'm moving Filemaker Pro v5.x files from a Mac platform where they were created to a new Win XP platform (running Filemaker Pro v5.x) & can't open the files after they are copied over. The files copy OK & are recognized, but the squiggly indicator comes up while trying to open, then error message. "xxxx file cannot be found & is required for this operation" I can open the files on the Xp when they are hosted on the Mac as a guest. I can also open new files created on the Xp platform OK. I can't save or ercover the files to the Xp platform from the Mac either. Anybody with suggestions ?? Psw

I am a long-time Quark user who has a client who wants to print her greeting card designs "on-demand". Quark would be a steep learning curve for the client and I could avoid making individual Quark templates for each design if I can use FM. I've been experimenting with FM as an alternative. I currently use FM 4.1. There are memory issues using my current approach. The average scan is 8-9mb in size and there are 216 designs involved. Importing each .tiff scann into FM would seem to create a "lumbering elephant". Is FM 6 capable of putting a "thumbnail" in the container field and referencing the actual scan with a defined path? This is the Quark approach. Th…

I am working on a relational database to take the place of a (terrible) flat one. The original has almost 50,000 records. A lot of the data contains typos and mistakes which is one problem. I have populated my tables with accurate data but after the import of the old records into the new db- I will still have bad data. Other than going through each record- is there anything I can do to speed up the process? Thanks

Can I perform a file merge using records from multiple databases? Here's what I want to do: I want to auto-generate documents for my real estate business. For example, I want to generate a lease. This requires information from three databases: Name & stuff about the Tenant (Lessee) Address & stuff about the Property Name & stuff about the Manager (Lessor) Plus, information specific to this lease instance: # months rent/month amount of late fee etc. Once the document is generated, I want to save an electronic copy for reference. Eventually, I want to be able to keep an archival history of all documents generated for a tenant (leases, …

Hello everyone. It took a while. (Like 2 years) but I finally found you all. And what a great forum! A wealth of information and resources. So we've only just met and already I'm on the scrounge . . . I'm probably the messiest FM developer in the world. I try a script. I try it another way. I think of something different, and try it another way. Now I have 5 versions. Then I come at it from a different angle, try to use some Status function I haven't used before. Try that 5 ways. In half a dozen different relationships. And that's just breakfast. OK. You may say this reflects a lack of forward planning. Maybe true. All right, it is true. However, along the …

fmp5.5 I am not the biggest fan of the "status area" in my final layout. But I like the features in which it contains. One of the problems I am having is with the "Find" function. I have incorporated a find button into my layouts but am having difficulty trying to link it up to the appropriate action? Right now, it will execute a find. but when it gets to the found record, there is no way to get back to "all records"? -Except to double click on "find" again & cancel the request. I've tried running script, directly attaching "perform find" nothing seems to get me back to where I started before the find?

From the professionals to the beginners, I was wondering, how long it generally takes from the planning to the serving of a new database. My dB will be used for all internal Co. info. & resources. (as vague as this description is) I was just wondering how long this will generally take to create a system like this?::??? Sincerely, Newbie, fmp5.5 & fmp server

Is it possible to get duplicate warnings is real time? I have a file that checks for duplicated names and for duplicated addresses. The warning fields work, except for one thing - you have to go out of a record, and then come back to it (or do a find on the warning field being greater than 0) to get the warning field to show. It would be so much more convinient if the data entry person could see the warning just as the data is entered. Any ideas gratefully appreciated.

The other day, I was looking at a Filemaker solution for accounting called "EasyAccounting with Filemaker". I found a very interesting implementation of user interface in this solution. They were able to dim fields, portals and buttons on the fly depending on what field or checkbox was filled. I did not know this could be done in Filemaker Pro. This is a great way to help users understand your solution and do error checking without all the dialog boxes saying, "You forgot to fill...". At first I thought they were switching to other layouts that had the dimmed widgets, but I do not think this was done. Too many widgets on the screen would mean a separate layo…

I have to replace (actually re-enter) the contents of one field for each record in a large file (47K records) with the contents of the same field (for each record from a duplicate file. I need to re-enter these data, I think, because this field is a match field for a lookup relationship...and no "lookingup" occurs until the data in that match field (for each friggin' record!) is re-entered. This seems assinine to me, but hopefully I'm just missing something else that ought to be obvious. I couldn't find any info on this in the Help feature or the manual. Thanks, Pete

Can you use crystal reports with filemaker? If so how do you get started? I know how to use both filemaker and crystal reports I am just confused on how to pull the filemaker database onto crystal reports...Thanks a lot

I have a field "dues paid through". This field contains a date. Is it possible for a script or calculation that would change the font color in the "dues paid through" field from black to red if dues were not paid on time? Larry

Hello, I am creating a script that inserts text into a field, but I need the text to be formatted in italics. I do not need the whole field to be in Italics though. Is there anyway that I can just format that inputed text? Thanks in Advance!

I need to set up an auto entry with a

I have 2 questions that may be very simple... All I want to do is put some pictures in the background of my main forms to make it look more presentable...Do I have to create containers for these or can I just copy and paste pictures?? My second question is: is there any way to show what the user is choosing before they choose it? I have hands over whatever button they are about to click...is there away to display text when the hand goes over a certain button?? For example, They put the cursor of the "new" button, I want some text to pop up when they move the cursor over "new" that says..."insert new record" or something like that...is this possible?? Thanks a l…

I'm trying to prevent FM's usual error messages when dealing with clobbered, corrupted or files in need of recovery. It seems that FM ignores script step 'Set Error Capture (On)' and continues to display its own message and the FileOpen dialog. Ideally, I'd be able to trap the error and tell the user to use my Recover Utility which would allow them to restore the file from a backup folder. Anybody have any thoughts? Steve

hello users can someone assist me in with the following problem. I need to notify a person when a record is entered in the database any ideas Thanks D

Hi! I don't know if this is the right place to ask this question, hope you don't mind it at all. But anyway, I have a very very very BIG problem right now. My company wants to shift from Windows to Linux. Actually, almost 1/4 of out PCs are already running on Mandrake and Redhat. Is there anyway I can run Filemaker client on a Linux environment? Right now I'm testing it on WINE, It runs - single user mode, but i need it to work on 30 users using TCP/IP. Any Idea? Thanx!

We are using Filemaker Version 6 to develop our software. We use the software to autofill forms using data from a database. We have been developing a new version and recently came across a proplem when opening the file using Runtime. What we started doing was naming fields with either a ~ or a ! in the name. After placing the field into the form, we then run a script that searches the fields and fills them based on these characters. Without going too much into the script just yet, we are running an older version of Filemaker Runtime than what we used to develop the template. (Version 5.0 Runtime vs. Version 6 Developers) Could this be part of the problem? Any other …

On some of my installs it installs and others it does not. Is there any reason why? Its not listed at all in the plug-in menu and I've done the complete install. Any help? Thanks, Steve

Hi all, I know a little about FM Pro and have created several DBs, although they are a little basic but I know my way round the app. The problem now is I REALLY don't know where to start with creating a Diary, so I'm hoping that someone can point me in the right direction. I'm sure there are places where I can get them from at a cost but I'm more interested in learning and besides I actually enjoy it!!! (DOH!!!) Anyhoooooo if you can help I would really appreciate it. I have done a search on this forms but I didn't come up with anything hence the question Cheers. Killer Boo

Someone here at work has created a filmaker pro database. (FMP 6) I want to give other access to that database. Can multiple users access/read/write to the same database at the same time?? Can this be done without FM Server?? this is a Mac network

hi, I'm putting together a layout that has these five parts 1. header 2. sub summary - sorted by field A 3. sub summary - sorted by field b 4. body 5. footer It worked great and then I had to go change it. The problem is that the second sub summary (number 3 sorted by field will always start on another page. It will not start directly underneath the first sub summary. There's plenty of room, and it doesn't have the "start on next page option" selected. I had a similar report previously that worked fine, only difference was the fields are now set to slide up. Any suggestions would be great. Thanks! (if it helps I'm on a Mac running os 9, wit…

I have a list layout that is wider than the screen allows. When I scroll to the right, I lose the first field (which I need to see which record I am looking at). Is there any way to freeze a column so that while scrolling right, the first column stays on the screen? Any helo would be most appreciated. Kindest regards, Mark

can 2 filemaker client access a single database at the same time using muli-user, i mean. w/o the server? sorry, just my second week. thanks, louie

Hi, I have a filemaker developer solution for generating and printing barcodes (Barcodet) and i'm trying to make my own label template to print from.. To do this I want to edit one of the existing label layouts to fit my own (Barcodet comes with a bunch already setup as different layouts), but I cant get to them.. It seems like whenever Im in layout mode, I can only access that certain layout, I can't get to any of the others, They aren't listed in the layouts menu, any ideas on how I can get to them? Thanks, Alan Edit: I have tried going into Setup Layout Order, and checking the checkboxes next to them to include them in the layout menu, but tha…

and before everyone says something, i have used the search button! I am pretty new to fm but i was able to quickly setup an asset database for my work warehouse in no time with web companion access. I just have some goals that i am trying to figure out that i could use a little help/suggestions on. I would like to make it so you can select which assets can goto a packing slip. This would allow packing slips to be made in minutes instead of using excel to enter all of the information that is already present. The packing slip needs to be saved and the assets need to be either moved to another database or have the location field changed when the packing …

hi, its my second week on filemaker. i always saw on filemaker.com download progs, a -- sub bar i mean a line bar to indicate w/c layout ur'e in. On the upper left of your screen the layout list. i can't locate it, can someone give me a hand? thanks, louie

Hi everyone, I know that FMU doesn't have the restriction on the number of IPs accessing it on the web like FMPro does, but are there any other differences between the two? Is FMU more complicated to use or requires extra drivers and such? I am thinking of using PHP with FX.php module to publish the database. Will I have any problems doing so with FMU? Thanks, Eugene

On a peer-to-peer Mac network with the filehost machine running standard FileMaker v.6, can I backup my FileMaker solution to an external hard drive without closing the files, using Retrospect? I know that a Finder-copy of open FileMaker files is a no-no, but is it safe with Retrospect? ~Dennis

Hi all, I have been working on a new FileMaker system for our company for quite a while now. We've done some initial testing and it's going well. We have decided on a day in October that we will make the switch - from the old system to the new. The old system was made up of around 95 totally independent flat-file / repeating fields everywhere databases. The new system has 70 files and is very integrated with a common interface. There will be around 30 full time users. The system includes cost and time tracking, invoicing, estimates, shipping, inventories, administration, work requests, calendars, scheduling and contacts. Just looking for general a…

Hi there, I have a system to let user key in different report in ifferent database, and after they key in, i have a function/button to let them print the report, now i want to let user set the printer setup on the main menu, and after setting, all the related files/database will also use the same setting. I have try but the setting only can run on the main menu file, the other related files still need to set again. Is that have any solution about this problem? Regards, Henry

I have a report that list about 500 different items. These items can be grouped into about 5 different categories. Is there a way that I can have a heading listed before a group of products? Ex: (Category)Audio: Product 1, 2,3...; Video: Product A, Product B...)

I'm adding a subsummary field to an existing layout as part of a subsumamry. All the other fields have little up arrows which indicate to me that they will be generated dynamically. However the new field I've added only shows one repetition and isn't being dynamically generated like the other fields. I noticed it's missing the little up arrow at the bottom of its field border. Any ideas on how to set the field to have the up arrow and be part of the subsummary? Thanks. Chris

I have a database that contains PDF files. I can double-click on the PDF icon and the file opens. I would like to replicate this behavior online - that is, be able to click on an icon or a button from a browser and see the PDF file. I have created an Open URL script, but I can't run online. I can't see any buttons that I created. Any suggestions will be greatly appreciated

I didn't know where else to put this, the problem I'm having deals with relationships, scripts, all the good stuff. Anyway, enough talk. As simply as I can put it: - Two files, Household Members and Allegations. - If a record in Household Members has a value of 'Commission' or 'Omission' in the perpetrator field, that person (record) is going to need to have a record in the Allegations file. - This will need to be as dynamic as possible. i.e. say someone accidentally labeled a person to be a Perpetrator by Commission, while their field should really be N/A (thereby not needing an allegation record). So far, the way I've come along to solve this was …

I'm not sure where to start with this problem, so if you have any advice where to go, it is appreciated. I am running filemaker 5.5, with Filemaker Server 5, in a Windows 2000 Environment. I am creating a Database for Purchase Orders. THe database minimizes the data entry. 2 required fields are the Customer and PO Number. I am going to concatinate them to make a file name, ie: Customer Cisco, PO# 1234 would have a filename: Cisco1234.pdf We would like to be able to scan the actual purchase order into a file. 1) Can I have Filemaker open the scanning program? or 2) can I have filemaker Tell the scanner to scan the document (that's in the tray) and…

What's the easiest way of "unlocking" a locked button or series of objects so I can see the button properties? Thanks. Chris

Ok Lets see if I can explain this problem. I have two fields in my database, One is the

Hi there, now i found that if i set a field box with a size just like only can type for on line, but i found that if you press enter(return) key, it will still go to the next line. So every time if i go to the field, the box will change to more larger. Can i fix the size of the entry box so that if i only allow user to key in one line, when user press enter(return) key, it will not go to next line or no function. Regards Henry

Since May a customer has been successfully working with one main and two related files. Yesterday she noticed that 36 of 350 records stopped calculating an age (the field is based on record creation date minus customer-entered birthdate). By afternoon, 74 records, some of which were OK in the morning, no longer calculated age. Test records created today have the correct date. Some creation dates are showing up as future dates (Oct. 03), even though their computer's internal clock shows the right day. Fields connected to a yes/no value list set to default to "no" are showing up with random numbers - on some records, but not all. Info from one of the related files has …

Is it possible (in a LAN environment) to allow 2 people to access the same file at the same time? I was thinking that I could place the file on a server, map a drive to that server from each computer, and access the file that way. The only problem I see is that the file allows input and auto assigns a number to each record. If User1 made a new record, then User2 made a new record, they both would be unaware of the change, and the program would assign the next number for their newly created record.......or is this not true? I forsee a problem doing it this way, but I could be wrong. I just want to use 1 database folder for up to 3 users in a LAN environment, and a…

This is probably sounds like a newbie question, but it just hasn't happened to me before. My tool panel (not the toolbars but the tool panel) has vanished and doesn't come up in layout mode. Any ideas on how to get it back? Chris

I had enabled "Personal Web Sharing" on my Mac OS X. This reserves port 80 for its use only. FileMaker Pro's Web Companion needs the same port to display its pages. With "Personal Web Sharing" turned off, the display of the web pages works.

I don't actually own Unlimited, so would appreciate it if someone could do the following for me. I need to know what the Status( CurrentAppVersion ) function returns in Unlimited. The function should return not only the version number, but also give some indication that FMP Unlimited is the application. Thanks, Chuck

How well does Timbuktu work with FileMaker and Mac OS9? I have tried VPN, but we are using a slow DSL connection and it was just too slow. At the moment I only have two other users who is going to acess the database from a remote location. Is Timbuktu the best solution?

Hi everyone! I want to copy (in a script) all records (0 - many) from a database (called main) where a specific field ("id") matches a number (say 7) to a different database (called temp). The temp database is empty but with fields defined. How? Is there another way than doin it record by record? /Tobias

My databases have started to act a little touchy recently. When I open the database I am getting an error -10000. In my search for answers i have found only a possibility of a lock synchronization error but the error codes do not match up exactly. Searching for error -10000 on the filemaker knowledge base is futile. I have rebuilt all the databases and reinstalled filemaker as well. It helped for a little while but then the error started coming up again. Can anyone tell me with some curtainty what error -10000 is and how i might avoid it in the future? Thanks for your help

Hey, Is there any way I can make a Layout-Part (say, the Header) slide up like you can with fields? ~AeroGuy

I am a beginning user. I am using FileMaker Pro 6 on Mac OS X. I have the Web Companion using port 801. I have Personal FileSharing Enabled on my Mac. When I try to view web pages that I have just created using these hidden fields: <INPUT TYPE="hidden" NAME="-DB" VALUE="WorkRequest.fp5"> <INPUT TYPE="hidden" NAME="-Lay" VALUE="web"> <INPUT TYPE="hidden" NAME="-format" VALUE="new_reply.htm"> <INPUT TYPE="hidden" NAME="-error" VALUE="new_error.htm"> using the URL http://localhost/work-orders/FMPro?-db=WorkRequest&-lay=web&-format=new.htm&-view I get the error messages …

I have a file called 'client.fp5' that opens up in browse mode showing an individual record for a client (name, address, phone, related invoices, etc.) Here's the scenario....a customer calls and wants to place a service call, on this screen I just mentioned, I would like to be able to type in their last name, do a search, if it is found, then I could go to their record and create a new invoice, if no matching record was found, then I would have a choice of creating a new record for this client, after which point I could then create a new invoice. What is the best way to do this?

Here's what I have: Client.fp5 - Stores client info (name, address, phone, etc.) When a new client is added there is a Customer ID automatically assigned to that new customer. Invoice.fp5 - The invoice that gets printed out with the customer info, etc. What I'm trying to do: Right now I can go to the invoice screen and type in the customer ID and the client info will automatically be inserted where needed on the invoice. I would like to simplify this process. From the client info screen in the Client.fp5 file, I would like to be able to just click on a button "New Invoice" and have the Invoice.fp5 open and have the cusotmer ID already in there, which wo…

Hello, I was wondering if anyone has done this already. I am trying to use Filemaker Pro to connect via ODBC to a MySql database in another city. I need to update product tables for a website and my boss needs to use Filemaker pro only (for some reason). I would appreciate advice on the ODBC driver for OS 10.2, and how to establish an IP connection to MySQL database (they tell me that ODBC is all set up on the mysql end). Thank you , Denis

I have a client file that when opened, asks you for a password (for editing) if no password is entered then the file opens and the editing features are disabled. The problem is this: I got tired of having to hit enter on the password screen upon starting the app. and decided to go into the document preferences and set it to open the file using the default password. It does that just fine. The problem is that I can no longer open the file to edit it.....can't figure out how to reverse this. Any suggestions?

My images in Filemaker are just a link to images on the server which are eps files. In Illustrator they look clear and in FileMaker they appear slightly glasses. Is there a solution to this?

This is my first time ever touching a filemaker program, and no one else in the office has a clue. I am completely on my own. So, you will be hearing from me often. One of the first problems I came across with filemaker was with the delete feature. I had created 1 database with 5 different type of records in it. After I took my head out of my screen and looked at everything, I noticed that when I went to add a new or delete a record, it would add or delete a record to/ from every one of my different records within the database? :?? (( Let me explain a different way, using our little friend "Millennium Tech.'s" icon (the apple). I made a basket (the dat…

Hi, all! We all have reports we need to write, and sometimes those reports have grand totals. So we all make a Trailing Grand Summary and put the Grand_Total summary field in there, smile, and be happy. The problem is, what happens when records fill a page such that it bumbs our Trailing Grand Summary section off on to the next page? Well, the result is a poorly-looking report that is formatted something like... REPORT Fish..... $1.00 Lobster.. $3.00 Veal..... $4.00 <new page> GRAND TOTAL... $8.00 Now, I for one would rather that one record be removed from the first page and placed with the Grand Total on the second page so as…

I need to build a solution that converts English measurements to metrics. Any one know of someone who has already built a file or a plug-in that will do just that? If not, anyone have any suggestions or tips if I need to write the calculations myself?

hi all i recently got an error message while in "define fields" saying that the file was damaged. this happened as i was saving a calculation. it gave me the choice to continue or exit. i had this happen to me a while back, but fm would just crash without giving me choice. when i called support they told me i maxed-out fields, i was at about 5900 fields. they said that how the fields were named would affect how many would be available. so i made some adjustments and everything's been fine. since then i've added fields and not had any problems. i had it to about 6500 fields when the problem at the top occurred. i did perform a recover and it said there were no problem…

Hello all. I have a file, Customer.fp5. It contains a field CustomerID, which is a Number, Indexed, Auto-Enter Serial, No Modification. I have a file, Computer.fp5. It contains a field CustomerID, which is a Number, Indexed. By copying the CustomerID of a record in Customer.fp5, you effectively Assign a Computer to a Customer. It is a 1:m between Customer and Computer. I have a file Printer.fp5. These Printers are networked, so there is a m:n between Computers and Printers. Since there is a m:n between Computers and Printers, I created file called ComputerPrinter.fp5 to hold which Computers have which Printers assigned to them. This file has a fi…

I'm working on a meta-analysis DB for my wife's dissertation project, and I was wondering if there were any resources out there to add more advanced statistical capabilities to FMPro. . . We are calculating Effect Size r, Standard Error, weighted and unweighted means, and then we'll be transforming Cohen's d to Effect Size r. If you understand all the letters and names in the previous paragraph, I'd love some help on how to go about simplifying this process.

I am responsible for all aspects of a monthly trade magazine (editorial and advertising). I inherited FM as the db to track ad sales activity. FM is used mostly as a database to track contact with clients & prospects. Is Filemaker Pro 5.0 the best tool for that use? (I'm not a database expert, but it seems to me there may be other software -- such as ACT -- better suited for this use.) Second question: If I stay with FM, how can I give an outside sales rep remote access to database for him/her to enter client/prospect contact activity? Thanks.

Hello All, I'm having a lot of trouble getting rid of some white-space in a report layout that I've made. I can't for the life of me figure out why this space shows up... the objects/fields above and below this space have been given the ability to "slide" up using the FORMAT-SLIDING/PRINTING options. Is there something I'm missing? The white space occurs at the beginning of my BODY... before the body, in the layout, I have stuff in a TITLE HEADER AND HEADER. Since the white space occurs only on the first page of info (and not on page2), I can conclude that there's no problem with the HEADER and that this white space is somehow created in the TITLE HEADER …

Okay, this one's real weird... I have a database with info on 6 records stored in a particular database. I created a report-layout that contains a TITLE HEADER, HEADER, BODY, TRAILING GRAND SUMMARY, FOOTER, and TITLE FOOTER. The database's records are about companies A through F. The weird thing is that when I view data of Company A in PREVIEW mode, I see that all the info related to Company A shows up on pages 1 and 2 in my report (info i had in the TITLE HEADER, HEADER, BODY, TITLE FOOTER, and FOOTER)... but the info (some bit of text) that I placed in the TRAILING GRAND SUMMARY of this record's layout shows up on page 3 with info of COMPANY F showing …

I'm not sure where to post this but here we go: I have designed a sales report that basically takes the information out of my database does some calculations and drops all of the information into a form which I created, which in essesnce looks like and Excel spreadsheet. Accross the top of each column are the months and the rows are labeled as separate sales categories. What I want to do is have the report print out normally Jan-Dec, then the following month I want the report to start with Feb and go to Jan. Is there an easy way to do this without changing all of my field definitions along with making 12 separate layouts? Thank you