FileMaker General Discussions
Older discussion forums for previous versions of FileMaker
-
hello, does anyone know how to host the database while using relationships from another file? thanks in advance
-
- 1 reply
- 779 views
-
-
Is there a way to show what the
-
- 3 replies
- 588 views
-
-
How do you change the alignment of the part labels from a horizontal format to a vertical format. I'm referring to the <header> <body> <footer> etc. Larry
-
- 3 replies
- 624 views
-
-
Hello, I have done some searches, and come up with very little on the subject of checkbooks. My reason has to do with a small business (publishing and mailing a periodical) I run, previously having done the checkbook in an old MS application called works. I maintain my mailing list in Filemaker. I have moved to a G4 mac from an older machine, and fortunately, I suppose, can no longer run works and have moved to MS Office. I have always wanted to do all of my business record keeping in Filemaker, as I felt I could integrate mailing list, revenue, and expense functions in one application that could greatly automate my tax preparation challenge. I do not find …
-
- 1 reply
- 1.1k views
-
-
We use a database in our office that is housed on our Mac OSX server (XServe). It is accessed accross in single user mode by 8 different users at various times. Some of the users are Windows XP users using FM6, some are Mac OS 9.2 (using FM 5 and 5.5) and some are Mac OS 10.2.4-6 (using FM 6). What is happening is that this database is frequently requiring the use of the recover function to be opened. A couple of weeks ago even this wouldn't work, so I rebuilt the database from scratch and imported the data from the previous day's backup. I thought this would solve my problem, but now I am having to recover the file again. Does anyone have any idea why this may be happeni…
-
- 11 replies
- 2.1k views
-
-
Ok, so here is my problem... We have a 3 database inventory/sales solution. There is one big problem though. Our first database (Order Form) is where we input items that customers order into a portal that is in relationship to our second database (Line Items), and then from line items it brings the item information and current inventory on hand from our products database. Now here is the problem, some of the items we sell in dozen and single quantities and what we need is a method of when the dozen item number is inputted into the order form portal, have it take 12 singles off the single item product record, in the products database, instead of taking one off of the do…
-
- 6 replies
- 2.1k views
-
-
Hi All, It time for me to upgrade from my Mac OS 9.2 Webstar 4.5/Web Server Connector to Mac OSX. The plan is to keep running FMU (v6) on a win2k box and upgrade the web server to something on Mac OSX. I would prefer to not buy OS X server and instead just use the built in Apache on OS X 10.2.6, so my question basically is: What does the latest version of FM Web Server Connector work with on MacOSX? Does it work without OS X server? Does it work on OS X 10.2.6 (non-server)? What versions of Apache does it work with? - Has anybody used it with Apache 2? My other option is to not use a web server connector and treat the win2k box with FMU …
-
- 1 reply
- 1k views
-
-
I recently rewrote my batch file used to backup our FM Server 5. We used to just copy the hosted files without stopping and restarting the FM Server service. The new batch file stops the service, copies the files, then restarts the service. Then it occurred to me that I have a new problem: Automatically re-opening the files in Unlimited 6 once the FM Server restarts. It occurred to me that I might be able to use a daemon and run Unlimited as a service. How does everyone else get around this? Thanks in advance.
-
- 2 replies
- 1k views
-
-
I would like to have FMPU run as a service on either a w2000 server or win xp pro machine. I also need to be able to use FMP on the same machine (for local users). I currently have FMP server 5.5 dishing up about 40 dbs, but only 10 or so will be needed by the web interface db to be shared. What are my options, (no I do not really want to buy another machine) My main problem is that aside from our server machine the rest are used by staff, and I don't want the FMPU closed down. Q2. Is there a way to run FMPU on a machine that is also running FMP Server. Cheers Charles
-
- 10 replies
- 1.7k views
-
-
I'm getting so unbelivably frustrated over here. I'm running FM Server 5.5 with FM Pro 6 to work on it. I also have developer, but rarely use it. The problem I've been having is I have been making changes to scripts so they work properly (it's mostly for navigational purposes), and after I fix them, they go one as if I have never fixed them in the first place. I seriously don't know what's going on, and I'm ready to start punching stuff. I end up fixing the same scripts literally every few hours, and it's unbelievably annoying. What the $#@$ is going on?: Should I stop the FM server and work on the files directly from the server??? ahhhhhhhhhhhh!
-
- 15 replies
- 1.5k views
-
-
Below is an if statement formula I am having trouble with. I get the error message "There are too few seperators in this function" Can someone help me get the syntax correct? If (ShipMethod = "Ground",5.95+AddWeightCost,If (ShipMethod = "2Day",8.95+AddWeightCost2,If (ShipMethod="Overnight",14.95+AddWeightCost2))) Thank you.
-
- 2 replies
- 815 views
-
-
I have some databases running on FM server. Should I do periodical operations to keep my solutions running smooth ? For example, have the hard-drive to be periodically defragmented ? Have the databases to be optimized (assuming that some kind of low-level optimization exists). Thank you!
-
- 1 reply
- 546 views
-
-
Simple. How do I get the layout in browse to have the "page look" where the form borders are "fixed" (similar to "page view". I know the fuzzy verticle bar in the layout mode marks that edge. But in browse how do i get the form not to expand to full monitor size??? Jonathan
-
- 2 replies
- 662 views
-
-
The specs: Filemaker 4.1 database is being shared on Macs & PCs. The file is being hosted on a Mac and has been working fine for years. Lately, one user on a Mac OS 9.0 machine experiences dimming with some of her text when she opens the shared database. This problem does not happen with any other user who access the database from their machines. This user will see some of the text fine, but other pieces, within the same field for example, will have the text dimmed and other words will display fine. If she increases the zoom, or if she prints the record, the text and fonts are fine. She only experiences this problem with this one shared database. Other databases on he…
-
- 1 reply
- 849 views
-
-
I see that FileMaker is offering a rebate on QuickBooks. Yet there is no standard solution for importing FileMaker into QuickBooks. Am I missing something here? Comments appreciated - Sam
-
- 8 replies
- 1.1k views
-
-
I am currently running a network of Mac's and need to get all electronic transactions HIPAA compliant. Can anyone point me in the right direction, via referal or possible Medical billing Applications for the Mac that will be compliant with HIPAA regulations. Even a "grunt" would be appreciated at this point! Yes I know! Macs can suck!
-
- 4 replies
- 863 views
-
-
I have recently put a Windows XP computer on the network and I have a 98 on there as well. The problem is when printing from filmaker v4 in XP the headers never print, but they still print from the 98 PC fine. Is there a way to fix this or is there something that I am doing wrong?
-
- 0 replies
- 684 views
-
-
Could someone point me to something that might explain the Perform Find/Replace dialog? There's alot of new stuff there and I can't find sufficient literature. Thanks Ken
-
- 6 replies
- 716 views
-
-
I have a set of 5 (or so) databases that are used for producing and printing calibration reports. We would like to use a laptop for doing this same thing on the road, but I'm struggling with exactly how to do that. Ideally, VPN would be best, because the on-site laptop user would have access the the most current information and I wouldn't have to modify the databases at all. It would be as if they are plugged into the network. But, this system would have to work virtually anywhere in North America, so a cellular phone hookup or 802.11 wireless hookup would be too spotty. I was interested in FileMaker Mobile, but my application seems too much for FileMaker Mob…
-
- 7 replies
- 893 views
-
-
Hi, I am a newbie to Filemaker . But it looks like i will have to take care about Whole Filemaker Pro. We want to Purchase the Filemaker pro unlimited. And Develop our websoulutions. I know how it works for the intranet or workgroup. But i couldnt understand how it works with the complete internet solutions for example a e-commerce project. Could any one give me an explanation. Did anyone setup the Filemaker Pro unlimited with webserver connector to IIS or Apache. How do i develop web applicaitons with it. I dont know if Filemaker pro unlimited can alone develop the whole web application(e-commerece etc). Do i have to use ASP, JSP, PHP like scripting l…
-
- 1 reply
- 906 views
-
-
Hi, Is there a trail version for filemaker pro unlimited. thanks, naveen
-
- 1 reply
- 1.6k views
-
-
I'm a building contractor and have developed a database in Excel that tracks employee/customer/material and subcontractor costs. For any of you familiar with XL, I am wondering if FM could do a similar job for me. I used FM once to create a membership database a couple years ago and it worked great for that. With the use of some 'very complicated' formulas and PivotTables I am able to sort data according to many criteria. Like total hours all employees spent on any particular job, hours a given employee has spent on a job, total hours for all employees and all jobs, etc. I'm also able to use formulas to invoice customers for time/materials/subs with Profit and …
-
- 13 replies
- 1.2k views
-
-
almost every time i encopunter something i can't figure out, i come here to post it. by the time i finish describing my problem, i understand it in a way that i didn't before, and the solution presents itself. does anyone else have this problem?
-
- 5 replies
- 1.7k views
-
-
Hay all, Having a feature problem in osX/9 here. Its really neat to drag a pic from safari to a container field in FM pro (my dad loves it). The problem is that the picture gets larger this way. Same with copy and paste. Is there a trick or app that can help me out on osX?
-
- 2 replies
- 840 views
-
-
What are the differences between Web Server Connector and Web Companion for getting a simple data base up and runnin gusing CDML? I know tha WSC will let you balance any thing else to say this is the WSC is better for something very basic. (Here are the catergories pick what you want, then FileMaker returns all the possible choices with in that catergory).
-
- 1 reply
- 1.1k views
-
-
I have a phone sheet, where each record is marked IN, OUT, NEED TO CALL, or CONNECTED. I have a button that will find and sort only the IN, OUT, and NEED TO CALL records. However, one record marked CONNECTED kept appearing after the find and sort (and only one of the records in that category, so I know that I didn't need to rewrite the script or there was a problem with the find). So, I deleted the record a number of times, but now when I sort a "phantom" record appears -- it's blank, and you can't enter the record. It goes away when you delete -- only to reappear when you do a find and sort. Why did this happen and how do I get rid of it? (Also, the file is hosted …
-
- 5 replies
- 1.3k views
-
-
Hi I'm doing a database in Filemaker for a British University. It started life as an Access database, until I discovered that the University IT dept doesn't support Access! So we decided to do it in Filemaker. I have some experience in Access and other RDBMS, but am new to Filemaker. So far I must say, I'm impressed by what it can do. I'm doing most of the development work on my premises which are a couple of hours jounrney from the University. To help me I have the Coulombre / Price book "Using FileMaker Pro 5" which is very helpful, as is this forum. I've done a "prototype" database - 3 main tables, several lookup tables. A couple more main tables to add soon…
-
- 6 replies
- 882 views
-
-
I am looing for a program that will bring a Filemaker window to the front if Filemaker is not the program open. I am using Keepitup to make sure the program is open but incase the program goes to the back I need it in front to work.
-
- 3 replies
- 1.1k views
-
-
I presently have two fields that require information to be entered when any changes are made on a record. The user is required to enter her name and date. User gets a beep when exiting if she did not enter name and date. I use the field validation for this task. It works fine until I make more changes on a later date. My fields are validated from earlier editions, and the user gets no beep. I want the name and date fields to be updated each time editions are made. The simple "update - yes or no" message is okay. This is not a heavy security issue. Your suggestions are always appreciated. Maxwell
-
- 1 reply
- 683 views
-
-
Hi, I need informations concerning FileMaker Pro and FileMaker Unlimited. Is it possible to connect to FMU5.0 using FileMakerPro v5.5 ? Or do I need to upgrade my FMU version ? Thx for your answers Jerry
-
- 8 replies
- 1.3k views
-
-
Is it posible to assign an Alpha-numeric bar-code to a jpg.? Or that the bar-code changes the jpg #. What I want to do is: take a picture, scan a preprinted bar-code, swipe the card through a slot reader. The bar-code should some how be relating to the letter string of the plasic card. Final purpose is: On a web site the customer types in the string and the picture shows up. Any hints? Norbert
-
- 8 replies
- 1.2k views
-
-
I have an environment where we are looking to upgrade from FMpro 4.1 clients and server. We have about 40 clients accessing shared databases being hosted by Fmpro Server. I need to know if the following scenario is possible before outlaying the money. We want to run FMPRO server 6 and host about 60 databases. We also want to run FMPRO Unlimited on this Computer and run web companion to serve some of the databases via a web interface. We want both WEB clients and Filemaker Pro version 6 clients to access the same databases at the same time. is this possible??
-
- 6 replies
- 1.2k views
-
-
Newbie is right! About 3 days new. Starting with an existing FM database that the users have been keying customer data in for about 6 months (1000+ records). Now we want to link to the corporate AS400 server for this header data. No problem ... the import through ODBC is complete. NOW ... how do I associate the new fields from the ODBC to the existing fields (of the same name and data type) without destroying any existing entries. PLUS I want to key in the FIRST field of this link and let the rest populate based on that FIRST field. WOW! I'll take this in small bites.
-
- 2 replies
- 786 views
-
-
Hi all, Does anyone know the background workings of how FileMaker loads records into layouts? i.e. If you have a database with 30 layouts and you bring up 1 record. Does FM populate every field on all 30 layouts with the data for that 1 record, or, does FM just populate the data in the current layout, then as you change to another layout it populates the fields in that layout? You may have seen another post of mine about speed problems I'm having with one of my databases, I'm just trying out different ideas to resolve this. So if anyone could answer the question above that would be great. Many thanks Ed.
-
- 1 reply
- 641 views
-
-
Hi, all, I'm using FMPro 5 for windows. I recently upgraded my monitor to a large size and am running the display at 1600x1200. Unfortunately, FMPro now displays some text - particularly field lists and import/export boxes with field lists - in type so miniscule I cannot read it. I don't have this problem with most other apps, or at least not so severe. I even reduced the monitor resolution but it didn't really do a lot of good. For the moment, I'm doing my FMPro import/export work on my laptop, but that's not always convenient. Is there any workaround involving FMPro? Thanks for any help. Ed
-
- 7 replies
- 960 views
-
-
I have to do a data base that will indicate a resume of all the bills sent a client (file resume). The existing file are the bills(file Bills). The thing is that in the resume file, there is a date and I need to see all the bills up that particular date. The relationship between the 2 are the "client name". I have a field in the bills file that copies the resume's date. If I could just found a way to indexed that field, I could probably manage my relationship. Any ideas Thanks
-
- 0 replies
- 601 views
-
-
Ok.. as I start to slide down the slope into FM I'd like to get into good habits. Is there an industry standard system for naming databases, fields, scripts, code etc etc that I should get into the habit of using to make me more user friendly in the future?
-
- 4 replies
- 647 views
-
-
Can script buttons be placed on the vertical "status area" tool bar on the left hand side of the display? I just need some buttons to always be available no matter what page of my 10 page report I'm on. These buttons are for quick navigation to other areas of my report so any method that would do this is appreciated.
-
- 5 replies
- 742 views
-
-
On sub records such as detail lines is there and advantage to keeping layouts plain vanilla as opposed to color layouts? Don't want to make them all matching and pretty if there is a reason not to. Thanks J
-
- 4 replies
- 730 views
-
-
If that is familiar to you then you know what it is. I know in older versions of FM the expand=1 line could be added to the regedit in the windows registry to increase the display size. Can this still be done? I can't remember where in the registry to place this line. Thanks!
-
- 0 replies
- 697 views
-
-
-
Hi, I'm very new to FMP. I have a couple of files: 1. School_project - which contains school_id, project_id, ... and a BUTTON I want the user to be able to click on the BUTTON and have it bring up a layout from another file (pub_quotes) this file contains project_id, pub_cd, qty, etc.. the common field is the project_id - however the two layouts are in different database files (school_proj.fp5 and pub_quotes.fp5). Any help would be greatly appreciated! Thanks!
-
- 2 replies
- 766 views
-
-
Have FM 4 on a Mac but our office has converted to Networked PC's. We need the data from FM 4 converted to...and looking for the best options. What is the best way to do this? We don't have a way to save the data to a CD on the Mac. Is there a way to transfer the files from the Mac to the PC? Can we convert from FM 4 if we bought version 6? Thanks for your help!
-
- 1 reply
- 796 views
-
-
How do i go about EMAILING a LAYOUT or other files/DB from within Filemaker?? Is this a Scipt or some thing else?? Corey....
-
- 1 reply
- 670 views
-
-
Hi there, firstable FX.php (http://www.iviking.org/) is a really cool project, but how do you get data from your Filemakerdatabase Unlimited Version 6.0 on MacOS X with the fx.php class, while Websecurity is enabled for the hosted Filemakerdatabase on another Server ? If it's disabled everything goes fine, don't know what to do. Well, is there a way connecting the database from another host, while having websecurity enabled for the hosted database in filemaker unlimited 6.0, please let me know it. Maybe someone can help us out and knows how to configure it. Thanks
-
- 23 replies
- 4.5k views
-
-
Ok here we go, I am still new to filemaker. I have 3 or 4 layouts that i have created. Each layout has a number of fields, but in each layout there is a job# field. Now data is being inported from a number of MS Access databases by OBDC, to these different layouts. now I would like to have a new layout which has the job# fields with all the fields from the other layouts with the same job#. Any ideas how I should do this? Thanks All
-
- 2 replies
- 1.3k views
-
-
I have a cross platform solution developed using FM 5.0. We now have Mac OSX on our lab machines and need to create a runtime version for training. However, one of my most important fields is a container field that we put copied portions of pdf files for display. However, on the unbound and bound versions the container fields are empty. Any suggestions
-
- 1 reply
- 549 views
-
-
I'm trying to decide whether or not to start a major new FileMaker project now or later. If there's gonna be a new version in the next month or two, I'll wait. Anybody have any ideas about when we can expect FileMaker 7? Are you holding off development of new projects in anticipation of major changes? I noticed something interesting when I searched for it on Google... The summary for the Peninsula group said "Works with ANY version of FileMaker from 4.0 on, including, 5, 5.5, 6 and is already being prepared for compatibility with FileMaker 7!" ... but when I went to their web site the second part had been removed. Must not have grooved with FM's non disclos…
-
- 6 replies
- 912 views
-
-
Hi! I have a problem with FileMaker running on Windows 2000: it takes more than 5 minutes to launch. It happens on two different machines, having FM v5 and v6, whereas it doesn't happen on other computers on our network. Anyone with a similar experience can help?
-
- 5 replies
- 584 views
-
-
We are currently using FM 4.1 (on a Mac 9.2), mostly serving pages over the web. We would like to upgrade to version 6 running on 10.2. We have around 50 login per 24 hours. At present we share some of the databases (via filesharing with 3 or 4 windows clients and serve from the same machine over the web). Is it possible to install FileMaker Unlimited on various clients (mac and windows - max 5), and still serve them over the web, or would we be better off with FM server.
-
- 10 replies
- 894 views
-
-
My business runs on an app I wrote with Dataease (Dos dinasaur). Hundreds of forms, dozens of relationships, hundreds of queries. Orders, Invoices, Routing, Employees, Inventory, customers, etc.. I enjoy programing and want to start on the right software to replace all of this. How do I decide if FM is adequate (seems most simple) or if I would be better off starting on VB.net or other types of more "programing" languages... any help very much appreciated. Wandering in Massachusetts.
-
- 3 replies
- 1.1k views
-
-
I have a strange problem which I hope someone can help with. I have an iMac running Filemaker 5.5 Server and hosting over 50 databases. 10 of these databases are accessed by a 500MHz G4 PowerMac running OSX.2 and FileMaker 6 unlimited. This then serves these databases to the web using FM Web publishing. On occasion, FMPro has quit, and these databases can then not be accessed (obviously!!), and it is time consuming to open each individual database again, and I am not always available to do this. I have created another database which runs a simple startup script which opens the required databases from the host server. The problem is that FM unexpe…
-
- 4 replies
- 615 views
-
-
Hi there, Is there something I can do so that when I view as a table, all the fields are shown? Right now, I'm missing a couple of fields. I don't know why it's doing this?? It shows the last name but not the first name. Thanks for you help!
-
- 1 reply
- 787 views
-
-
Hi all, I have a problem: 1 server 10 databases Databases needs to be shared on the web - so am running FMPro Unlimited Databases now also needs to be shared through the company for users who connect using FMPro. I know the users can connect to the databases using FMPro if I set the databases to be multi-user but from what I understand, Multi-user databases on FMPro Unlimited will oly deal with one request at a time, therefor making FMP Server the better option. But as I said I only have 1 server! Is it possible to run FMP Unlimited AND FMP Server on the same machine serving the same databases? Many Thanks Ed.
-
- 5 replies
- 1.1k views
-
-
I have 200+ clients accessing the FMServer with my app. Currently they get there by selecting the host by IP address. All our IP addresses are about to change. Will it work if I have everyone shift to the server name vice the IP address? This is FM 3.0 running on a W2K server.
-
- 1 reply
- 780 views
-
-
-
Perhaps somebody can provide the advice I need to keep from slipping further into an unnecessarily messy database. This is a timesheet/ payroll database. First, my parameters: - We have only a few employees, but I like to build things that can adapt in the future when we get more. - Each employee has multiple possible pay rates (depending on their activity). I don't want to hard-code these, since they may change in the future. - My boss wants me to track our activities in rough chunks - say, 2-4 different activities each day. (Thus, my basic unit isn't the day, but the "entry". - We are paid twice a month, which means payday wanders all over the calendar.…
-
- 4 replies
- 699 views
-
-
Can anyone help? I use V4 as a label database, I want to incorporate the relevant graphic in our 'specification' layout , each record has a unique number and the graphic can be identified with the same number. I have tried various methods with little success . Please can someone point me in the right direction. Thank you
-
- 3 replies
- 1k views
-
-
Hi, Is there a known tool to update/delete/edit passwords in databases hosted on the server? For instance, the employee leaves the company, and his passwords has to be deleted. Instead of searching through all databases to see where he had access, I want automatically to find and delete the passwords. Thanks
-
- 1 reply
- 646 views
-
-
First - whoever reads this and ponders a solution let me thank you in advance. This may be so simple I can't see the forest for the trees but ...... In my database for tracking fleet repairs when a job has been completed I need to eliminate it (omit) from the active database and export (I think) to another file. The problem is when I do this it always overwrites the "storage" file. I don't want to replace these old files but rather append them to the old file for future recall. Is this that difficult or I am over looking something really basic. Thanks again for whatever assistance you can render. Mike
-
- 3 replies
- 1.2k views
-
-
-
I'm looking for a FIleMaker Pro solution that is primarily set up for sending Emails. Don't need anything real big and booming, just something that will get the job done and that I'll be able to modify for my specific needs. We will be sending maybe 300 to 500 Emails per day. Thanks, Bill
-
- 14 replies
- 1k views
-
-
I want to set up a REPEATING (25) Field [sITE] so that it is a BUTTON. Clicking on a specific Repetition enters a TEXT Value that was first inputted into anotherFiled [sITE NAME]. EG. SITE NAME is bhp; the Repetitions in the SITE field are persons names; If i click on say the 4th, 9th and 18th REPETITIONS of the SITE Field, rather that having to manually enter the SITE NAME (bhp in this case) into the 4th, 9th and 18th Repetitions , i want to have this value entered AUTOMATICALLY into only the repetitions i click on. Any help would be appreciated. Corey....
-
- 0 replies
- 991 views
-
-
Hi All, I would like to know if there is a way to make an executable file in Filemaker. Let's say i make an executable file in filemaker when I click it it runs as the way i want and I don't need to install Filemaker software. It is like in Access we can do it. IS there a way or example to make an executable file in Filemaker? Thanks Anh Tran
-
- 1 reply
- 1.4k views
-
-
This is about the simplest, yet oddest question I've had so far. My boss was desiging a layout on his laptop for fun, he's running WinXP Pro on it, with FMP 6. I also have FMP 6, and I have windows 2000 on my desktop, and WinXP Home on my laptop. On his computer, the layout that he's created, when you enter text into a text field and want to carry to the next line, it exits the field instead of entering a new line. The same file on both my machines enter new lines. Is this a setting that I can change somewhere? I looked in the application preferences, and nothing jumped out at me. Thanks!
-
- 5 replies
- 1.2k views
-
-
Hi, i have been looking through this forum but haven't come to a definitive answer. What is the best way to keep fmu open on a win2k machine without requiring anyone standing infront of the machine / rlogin? Has anyone achieved this so that publishing doesn't need local / remote administration? setup is using fmu5.5 in DMZ login to fmserver on 2000 server box
-
- 1 reply
- 779 views
-
-
I've just been refused access to a floppy that I've used for years. The message says "Access has been changed or tampered with". Help!! This is really important. Help, Help!!!
-
- 4 replies
- 837 views
-
-
I inherited a Database made in the original Filemaker that's now 10 years old. I'm getting it relationalized into Clients and Transactions. Over the years there have been multiple records entered for the same client (i.e. each transaction duplicated most of the client info). When there are 5 or 6 records for the same client I want to combine them into one record (just as Address Book lets you merge records). I can easily locate all the records for a client but I'm looking for a way to put all that information in the same record. While addresses/phone numbers have changed over the years, I can find the most recent entry, but there's often data in older entries that isn't i…
-
- 6 replies
- 876 views
-
-
Hello all: We recently put a FM database on our OSX Server machine (G4 350 OS 10.2 Server). Right now, we are just using FM Pro 5.5 and I have Unlimited on its way. The server backs up at 8PM on Friday night. I have a couple of questions. 1. We use Retrospect Backup. My feeling is that I would have to close FM while the backup is occuring. But we also run Now-up-to-Date & Contact to serve calendars, and that does not have to be restarted. Will I have to close FM when the backup is happening? 2. If I do close it, does anyone know of an Applescript or a third party activator (or maybe some sort of OS10 Server feature) that will open up the FM files …
-
- 2 replies
- 711 views
-
-
I'm having a problem with versioning. I've made a few databases that get used in different projects. For example, there's one that records specific geologic information about an area. At any given time there are multiple copies of the database being used by different people who are recording data for different counties. When it's time to make some revisions on the database, however, I've got the problem of there being multiple copies. I don't want to implement the same changes in them all, so what should I do? I had some ideas. Currently I've just been making the changes to my "master" version, and then importing the projets' data into a clone of it and giving i…
-
- 0 replies
- 657 views
-
-
how do i remove the header from the pages that i print out?
-
- 4 replies
- 3.2k views
-
-
CTRL+N seems inconvenient for data entry navigation to a new record. It's simple enough to make a button with a script, but I have not been able configure a button so it could be tabbed to and "pressed" with ENTER and I prefer to avoid the use of the mouse for data entry. Is there, perhaps, a way to make a button "pressable" with ALT+[first letter of the button label]? Or, more to the point, what is the cleanest way to allow data entry navigation to a new record without the use of the mouse or CTRL+N?
-
- 9 replies
- 858 views
-
-
I searched the web and I found this reference. I have been trying to learn what this means. I've searched the fmforums, I've submitted requests for explanations but I haven't gotten some sort on answer yet. Well, here I am, trying still. What is that "FMPro?" I realize it' ssome sort of script. Can you help me? Are there any websites with tutorials that explain further its usage? I have FileMaker Unlimited. HELP!!
-
- 1 reply
- 804 views
-
-
How can FMP tables be accessed (read, write) without running FMP? Preferably with Cocoa.
-
- 4 replies
- 818 views
-
-
Been using 5.5 with OSX & 512 on a titanium. Been incredibly successful for about a month then all of a sudden my favorite file claims to be damaged and suggests I use recover to open it. I use recover which runs fine and save it on the desktop and but when I go to open it Filemaker unexpectedly quits everytime. I never get to even open the file...any ideas? Chris
-
- 5 replies
- 1.1k views
-
-
I have been trying to understand CDML and I thing the reason I can't take advantage of it is because it was not installed. Is it an option during the installation process or does it get installed automatically? Thanks, Evan
-
- 2 replies
- 848 views
-
-
hi, I am still struggling with the problem to close/open db via webbroswer which should work with the following settings - remote access enabled - create "cdml variable Tags" with the following statement "http://1.2.3.4/FMPro?-Db=01_pon.fp5&-format=dbclose.htm&-dbclose" Ok and great, but: what exactly is the dbclose.htm file? why do I need this file? what is defined in that file? where should this file be stored? in the webfolder? anyone out there who could give me some hints? thank you in advance harald
-
- 2 replies
- 841 views
-
-
Probably a basic question but I can't seem to find the answer. If I have 50 fields in a layout in rows and columns... What is the easiest way to make them all the exact size. I know I can do them one at time using object size but when I select them all and try it, it forces them all in an area of the size of one field. It seems there has to be a faster way to do this.
-
- 13 replies
- 3.3k views
-
-
Help.....Can anyone help me with speeding up a sort of an unindexed record? Any help will be greatly appreciated and your reward will be in Heaven. Many thanks
-
- 3 replies
- 791 views
-
-
Hi there- Our customer database is broken down that each product a customer requests is it's own separate record. So each customer has multiple records. For this report, I want to be able to see each customer, what is the potential sum of all their requests, the actual sum of what has been purchased and the difference between the two. I can do that for each customer, and it now looks like this: (list serial number) (list serial number) (list serial number) (customers last name)(potential sum)(actual sum)(difference) However I can only do this for one customer at a time because the summaries will summarize all the records in th…
-
- 1 reply
- 613 views
-
-
Hi all, This really is a newbie question. We have a filemaker database running At a certain point we decided to put the database on the web , so we got Filemaker unlimited. No I was able to get the database online using instant publishing, but then the buttons in the database do not work. So i realized we need custom web publishing, presuming that the buttons do work this way. Now I have no knowledge of HTML, and even lesser knowledge of CDML. So the manual is a bit complex for me. Can anyone explain me what minimum steps I have to take to get my Database on the net, with my buttons working....... Thx in advance Thierry
-
- 2 replies
- 969 views
-
-
Is it possible to convert File Maker Pro files on a File Maker Server without actually opening the files?
-
- 2 replies
- 683 views
-
-
I've got a site setup now that is using the FMU 5 version of WSC on the OLD OS X Server v1.2 ( NOT 10.2 ). And it's setup with Apache and SSL and it's VERY stable. I'm then using Server 5.5 on OS X 10.2 (client) and haev 2 older iMacs connecting to that, one runs OS X 10.2 and FileMaker 6 STD and basically just sends and checks email, and the other iMac runs OS 9 and FMU 5.0 My question is this, if I bought FMU 6 and ran it on an additional OS X box would the old WSC be able to connect to it, and properly load balance with the OS9 mac? I tried this with Win2k adn FMU 5 and the WSC seemed to hang if one of the machines froze (which of course - in addition to p…
-
- 0 replies
- 816 views
-
-
I'm using FileMaker Pro to compile a dictionary of a language. Part of my work requires that I index words into groups of "families." Conceptually, this just involves giving each member of a group a shared, unique identifier. But what baffles me in FMP is how to access non-contiguous records when one is at a given record. In forms view, is there any way to access (and edit) other records while remaining on the record one is on, i.e., is there no way to edit two non-contiguous records simultaneously? Ideally, what I'd like to be able to do is split my screen-space in two and be able to access two records independently of the other, and edit each on the basis of the content…
-
- 3 replies
- 889 views
-
-
Can anyone tell me about any in depth courses in Filemaker. I would call myself a basic intermediate user of it but would love to be able to get a better understanding of it. I would be looking for something that would run for a week or so, as I would probably have to travel a long distance to get there. I am based in Ireland. I mainly use windows but am trying to get to grips with my first Mac. Mark
-
- 17 replies
- 1.6k views
-
-
Does anyone have the Updaters for Filemaker Server 3. Filemaker has pulled all of the updates for Version 3 about a year ago. I have someone that need to update there server version and I cannot find the updates anywhere.
-
- 5 replies
- 1.1k views
-
-
Hi,everyone. I'm using inserted bitmap images that are edited and viewed by the user (doctors making treatment notes with a Tablet PC). Currently the image is selected by the user followed by the Microsoft paint program opening the object for editing in a new window. I'm wondering if there is a similar drawing program that will allow the user to edit the image within the confines of the container field. I'm would also appreciate any suggestions regarding incorporating Tablet PC use with the Filemaker database.
-
- 0 replies
- 682 views
-
-
Has anyone got any insight into what the future holds for filemaker? I am now getting to a point with it where I would prefer not to have to change to another product and start the learning curve again. But Alpha five is putting up a good argument at this stage. I would love to see a straightforward way of implementing the likes of SQL, of being able to store images wtihin the database in their original format. Having Pop-up calendars and calculators. Being able to bind ones databases together, being able to run a macro when exiting fields or at specific times. Having the ability to create backups quickly. Being able to create a runtime version of a file for use …
-
- 9 replies
- 1.3k views
-
-
-
A small database enclosed that 3 fields do not show up in Preview mode or print. If you look at record 14 and look at the field (lower right) "Plate information", the data shows in Browse but not the others mentioned. I think I checked the obvious, text box, relationships, field format, but the data disappears. Any idea what I am missing? customer data.zip
-
- 15 replies
- 1.1k views
-
-
In honor of my 500th post, I propose a contest: What's the highest number of dialogs you've stacked up when developing a FileMaker database? For example, click Define Fields, then Options, then Lookup/Specify, Define Relationships, New..., Hosts, Specify Host... That's 7 levels deep! I bet someone can beat it, though. Are you up to the challenge?
-
- 3 replies
- 682 views
-
-
Hi All, I'm running 3.0 on W2k boxes. I have a contacts database that is about 10 years old and has about 16,000 records. I don't think FMP was relational when this thing was originally built so using a related file was not even possible then and I don't want to try to convert it into one now. We have this big text field where the contact notes are kept. To keep users from having to do a lot of scrolling, our practice has been to add new notes to the TOP of the list. We like to have our user enter the date, his or her name, and a brief description of why contact was made. Example: (1-1-95) - John Doe This is the newer entry. (8-1-94) - Jane Doe …
-
- 6 replies
- 1.2k views
-
-
In a "Company Name field", I want to make sue the field is exited by a "Tab" and not by a "Carriage Return". I was looking through a file of mine the other day and found carriage returns everywhere, even it the State field. The only field I want to allow a carriage return is the "Notes" field. Thanks, Bill
-
- 1 reply
- 735 views
-
-
I seen several references to the problem, on several different forums and bbs, but never a solution or even a decent workaround. In Layout Mode, any attempt to move a field brings up the 'duplicate' dialogue box. OK, you can duplicate the field and remove the original but that's a lot of extra work. And, adding insult to injury, it seems you can only duplicate in one direction at a time ('move' the field right and down results in duplicating the field to the right. Then you have to duplicate it again -- down). Has anyone found a key combination that results in actually MOVING the field? Abbe
-
- 2 replies
- 898 views
-
-
I was talking with a business friend of mine the other day, talking about reports; Excel spread sheets and the like. I mention that I started using FileMaker because I could import Excel spreadsheets and enter my other data. He said there is a guy he knows in his office building who is developer in both FileMaker and 4D. I
-
- 7 replies
- 1.2k views
-
-
Please help, I have filemaker pro 5.5 running on a Mac OS X system and when I go to view->Toolbars it is "greyed" out. I know this is probably a simple problem, but I am a newbie to filemaker 5.5. Thank you for any help.
-
- 2 replies
- 770 views
-
-
I am running a shared databse using fmp5 but not the server version. Sometimes when a client computer is trying to connect to the entrance file "menu" at startup, it displays a message as follows: "Cannot connect to "menu" because host is overloaded." I have searched for information on the meaning of this message but have failed to find any. If I restart the server computer, and try again it works fine. The server is an eMac running OS9.2 and is very lightly loaded. Thanks for any help that can be given. Gary
-
- 5 replies
- 1k views
-
-
I am trying to find information on how to build a report from Summary Fields. I am presently manually entering this information from a FM database to Excel and pulling the Excel file in as an Object. The summary fields are monthly Purchase Request totals. I prefer to do this report in FM, but keeping it in Excel is an option as long as it enters the information automatically. I've looked into ODBC, but it does not recommend using summary fields. Any advice on this is appreciated!
-
- 2 replies
- 855 views
-
-
Hi, I have searching around in the newsgroups and various forums and haven't been able to find the answer I am looking for. I have filemaker unlimited 5.5 running on a windows 2000 pro computer with the apache web connector running on an rh7.1 linux apache webserver. The linux server has the public ip address and works great sending requests to the unlimited computer with the lan address using instant web publishing. I have created custom CDML/HTML pages that work great on the LAN. I am not sure however how to configure the custom pages with the web connector. I found some very good instructions here: http://forum.filemakerworld.com/viewtopic.php?t=407 …
-
- 4 replies
- 1.2k views
-
-
Hi, Is there any way to run FM scripts automatically at certain times of a day? To be more specific, we want to import data from a text file which is updated continuously. we want to have a process running to check the text file once every hour and import new records into FM. The OS is Windows NT. Thanks in advance.
-
- 7 replies
- 937 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online