FileMaker General Discussions
Older discussion forums for previous versions of FileMaker
-
Hi, there: I wonder whether can FileMaker Pro5 can manage media file,like audio, video and images, in its database and how? BTW, I am using Macintosh. Thanks for replying.
-
- 2 replies
- 618 views
-
-
Hello, Good People! This should be easy: I want to paste links to the web into individual records in an FMP database so when you're in a record for a particular company, you can just click on the link and out you go to the desired website. Is this in the help section? If not, can you do it? Muchas gracias Gregor
-
- 0 replies
- 634 views
-
-
I am using Filemaker 4.1 for the Mac, When printing address labels from a database, Filemaker is randomly leaving out the Street address field. There are several hundred address's in the database and there is no pattern to which streets are going to be left off. Any suggestions would be greatly appreciated. Thanks, Dan
-
- 4 replies
- 917 views
-
-
Using Mac FM4.02 and Mac FM Server3 on TCP/IP server. Photos display if they are pasted in container field but not if they are just referenced. Is there no way to display referenced photos in a TCP/IP shared database? Does FM5 do it? Thanks. ------------------ Dan Dryden [email protected] et
-
- 2 replies
- 866 views
-
-
I am trying to export records to a comma delimited text fields to be imported into another program. The exported records have quotation marks around the text fields. Is it possible to export these records without the quote marks? Filemaker is putting them there.
-
- 3 replies
- 790 views
-
-
How can I determine if the last 2 non-printing characters are a CR and Line Feed in a field? I'm using FM5 under Win98. Thanks
-
- 5 replies
- 649 views
-
-
-
I posted in this forum yesterday, asking about database design theory. I got a few answers, but I don't see the post here now. What gives?
-
- 2 replies
- 894 views
-
-
I'm trying to format a field that the user inputs a telephone number and it formats it automatically to a certain format. Everytime I set the calculation in that field (using the replace command) I get a circular reference error. I know it's a simle mistake, but I can't figure it out. My field is a calc field to produce text with a replace function of the contents of that field. How else would I be able to do that? Thanks, frustatration
-
- 6 replies
- 1.5k views
-
-
I'm wondering if it is possible to have a repeating date field and have it calculate dates based on the value from another field. Basically I want to have the repeating date field create a schedule based upon the start date of a treatment. so if the start date is 1/1/2000 then 15 dates are calulated in one repeating date field. make sense? Any help is greatly appreciated. email is [email protected] thanks again ------------------
-
- 5 replies
- 787 views
-
-
So the info I want to import into a FMP file is comma separated text that includes basic HTML text formatting codes (such as <U> & </U> ). Is there a way to have the import read the HTML codes and format the text accordingly?
-
- 1 reply
- 700 views
-
-
Is there any way to concatenate all the values from a single field in multiple related records (one-to-many relationship)? Specifically, a video conference booking is in multiple venues, but for display purposes, I'd like to show all the venues for a single video conference booking on one line. Is there any way of doing this in a calculation field? I know that I can set up a portal for the booking and run a script to concatenate from each portal row, but I'd like to do it by a calculation field to avoid the possiblility of having outdated data displayed.
-
- 5 replies
- 886 views
-
-
I am a beginner-level filemaker user and I am attempting to setup a database system to monitor website statistics. I have cleaned up and imported the information into fm, and what I am left with is a number of repeating fields within the stats due to people logging in to www. and directly to the address. I have stripped the www's, so that I have duplicate records. What I want to do with this is take all of the records that match, add the numbers in the hits field, and delete the duplicates. Can anyone help me with a script step to do this? Thanks all, Patrick [email protected]
-
- 1 reply
- 671 views
-
-
Well I needed to create my own functions for FMPro because the find and the export functions are limited. I am wanting to export two different flat files for each search result...one with fewer records than the other and a sub search of that one...i ended up figuring it out, and have included the code below, if anyone could use it...I think that it came out very well...opinions??? tell application "FileMaker Pro" set CDID_Box to display dialog "Please enter the desired CD to export:" default answer "" set CDID to text returned of CDID_Box show (records where cell "CD ROM Number" contains CDID) set number_of_matches to count records set target_file_name to
-
- 1 reply
- 1.3k views
-
-
Well I needed to create my own functions for FMPro because the find and the export functions are limited. I am wanting to export two different flat files for each search result...one with fewer records than the other and a sub search of that one...i ended up figuring it out, and have included the code below, if anyone could use it...I think that it came out very well...opinions??? tell application "FileMaker Pro" set CDID_Box to display dialog "Please enter the desired CD to export:" default answer "" set CDID to text returned of CDID_Box show (records where cell "CD ROM Number" contains CDID) set number_of_matches to count records set target_file_name to
-
- 1 reply
- 623 views
-
-
If I'm updating my database on a Mac, then email it to a PC and try to open it, I get an error message and it won't open. Is there a way I can Use both a Mac and PC to make updates? Is the file not compatible between the two? Thanks, Debbie
-
- 8 replies
- 973 views
-
-
How do I add 100 years to an existing date field. The date is showing as year 1900 and I need it to show as the year 2000. This was an import from a ClarisWorks database. I have tried everthing I can think of to add 100 years but it doesne't seem to work.
-
- 2 replies
- 1.3k views
-
-
i need to know how to do something. right now the database has a few fields, Fristname, Lastname, OS, Memory, and userid. i set up a calc field that takes all those fields and list them in a string. so what i need now is a calc that will look throught the database records and find records that have like 2 things in common. like as you fill in the fields on a record you have a field that is showing the record numbers that have the same string info.. does that make any since?
-
- 6 replies
- 1.2k views
-
-
I'm using FM5unlimited, Webstar 4.3, Lasso plug-in, LetterRip, and some applescript to record email messages intoa web accessible archive. Recently Filemaker started hanging with a dialog box stating "Unable to write to disk" Tried changing the memory setting from save on idle to save every 10 minutes or as needed, and that slowed down the occurance of the error message but not entirely. The site does get a bit of traffic which keeps FM very busy, but this error is a show stopper for the whole operation. If anyone has seen this problem or can suggest a fix, please let me know. Michael
-
- 0 replies
- 702 views
-
-
When I run my application on a windows NT 4.0 machine, no problem. Run it on my desktop running Win 95 or Windows ME and I crash to desktop with the following error. MSVCRT.DLL error. Does anyone know if this is a division by zero error or have experience with this problem? Help?
-
- 2 replies
- 1.8k views
-
-
When I try to open FMP5 on my PC running Windows NT 4, the splash screen appears and I can see the font menu being built. At some point during this, the system crashes ("beginning physical memory dump"). The README file that comes on the install CD addresses this potential problem, saying that it may be due to a corrupt font file. It advises you to restart the system, remove the corrupt font, delete the file "FileMaker Pro Fonts.FMF", and restart the application. I've deleted FileMaker Pro Fonts.FMF but am not sure how to find the possibly corrupt font on my system. This PC has a lot of software on it - it's in a student computer lab at a university - and therefore a…
-
- 3 replies
- 676 views
-
-
Why is there no way to copy a script from one file to another? I have some rather complicated ones that I'd rather not have to re-enter. Also... can you get a layout from one file to another?
-
- 2 replies
- 1.4k views
-
-
We use FM Pro5 unlimited version for Web Purchase Requisition access. Often times user wants to re-order the same item purchased in the past. How do they duplicate the order once they found the old one?
-
- 0 replies
- 747 views
-
-
I represent a photographic agency. We have about 100,000+ images, jpegs (200-500K) which we need to put on a database. 1. Is Filemaker pro suitable? I imagine each image would have 4/5 fields associated with it, i.e. Name,Location, Description, Category etc. Would we be able to search through the images using these fields? 2. When we search for an image, i.e. dog, can all results be previewed as thumbs on a page. i.e page 1 of 5 , 10 images/thumbs per page? Clicking a thumb takes you to the actual image file? Any and all help appreciated Thanx in advance. ------------------
-
- 1 reply
- 624 views
-
-
Hi group. Hope someone can help me with this. I'm designing a layout which has numerous fields, most of which have defined value lists. I'm trying to get it so I can merge them onto a pre-written form letter. They need to be such that there are commas between words and periods after sentences. My fields are such that the user may need to choose more than one value. I've placed the <<merge>> parentheses in the appropriate location, but cannot pre-place commas because the fields may not always have values. Any suggestions on using merged fields more efficiently? Regards, Confused
-
- 1 reply
- 1.1k views
-
-
Is there a calculation in Filemaker that will check to see if the data entered is specifically of an alpha or numeric format? ie. I need to check that a code eg ABC1234 must start with 3 letters followed by 4 numbers. Thanks in advance for any help. Elsie
-
- 2 replies
- 739 views
-
-
We have a record, in the record is a field that has info separated by colons, Ex: blue:green:black we want to make a pull down menu with this information. We can't figure out on how to make filemaker recognize the ( in the field, so that the pull down menu sees each bit of information as separate info. We know how to enter the info to make a pull down menu, but not how to make it recognize what is in the field. Thanks
-
- 1 reply
- 579 views
-
-
I am creating a script that will select a series of records based on one field, and export selected fields to one text file (delimited) and all fields to another text file...I am just starting with it and am using the "get" method, and am getting memory errors (108), and cannot figure out why...any help??? tell application "FileMaker Pro" every cell of current record end tell also... tell application "FileMaker Pro" cell "Description" as text every record whose cell "DiscoveryId" = "JEFF FOOTT.00001" end tell
-
- 0 replies
- 651 views
-
-
Hi after doing a search for duplicates how can I delete them searching for duplicates using the "!" mark shows the original record plus the duplicates so using the "Delete Found Records" feature is not possible I want to keep the original record while removing the duplicates any ideas??? THANKS
-
- 1 reply
- 660 views
-
-
Hello all (nice board!), I was looking to not have to purchase a program that only runs on WIndows based computers called Fringe Facts Pro (www.bsiweb.com). What I am looking for would be a Mac based FM Pro 5 template or app. that would give summary for all associates regarding 401/Medical/dental/disability/profit sharing/FICA/un employment etc.... This would run on one machine or a FM Server system and include math calculations and charting etc. for yearly reports for all associates. Any help to avoid me wasting more time (on a 56k connection here at work) looking would be helpful. If anyone has any help regarding this or could pass on my request, I would be gra…
-
- 3 replies
- 638 views
-
-
i have an existing job ticket system, which needs to be improved and time sheets and supplier info all needs to be dumped in to a job ticket database, as well as media bookings etc etc, and then into an accounting pkg. has somone out there developed a framework for a typical pr and ad agency ------------------
-
- 3 replies
- 688 views
-
-
I am trying to build a statement. I want to be able to show a summary of unpaid balances before a particular date then an itemized list of charges from that date with a grand total at the bottom. I have not been able to figure out the balance forward portion. Any suggestions.
-
- 1 reply
- 936 views
-
-
Is anyone aware of a site using FM to display realty property listings?
-
- 1 reply
- 789 views
-
-
Hi, I've encountered an irritating problem after converting an existing FMP4-DB (Mac) to FMP5 (win 2000): After the conversion the "predifined custom sorting" that can be specified with the web companion no longer work correctly. It seem as if the web companion dosn't get the identity of the valuelist right. When I check the sorting criteria afterwards the "custom order based on value list" is checked correctly, but in stead of the name of the value list, it just states <unknown>. As a result the sorting is done alphabetically and not as intended using the sorting order stated in the value list. Have anyone experienced the same problem? (and found a solution) …
-
- 0 replies
- 623 views
-
-
-
This is a continuation of my last posting about the Recover command. Live Oak suggested a UPS since he seems to think it's a rare occassion. I believe it happens more frequently than Filemaker admits. I'm using FM5 on Win98 and trying to built a Kiosk solution that has 4 files that appear as one to the user. My goal was to trap the error about using the Recover command, and then just replace the file with a backup copy. In the last 8 months of using FM5, I have had a number of files get clobbered and require recovery. I believe this happens if Windows freezes as FM is in the process of updating its indexes. On rare occassions the file has not been recoverable (layout…
-
- 8 replies
- 814 views
-
-
I bound a 4.0 solution in a WIN98 environment. A user is trying to execute it on a WIN NT4 machine and gets the following error: "I have just attempted to install and run your demo on a 300mhz computer running NT 4.0 with service pack 6 and I get the following error along with two other associated errors when I attempt to start th program: Unable to locate the open procedure "NwPfOpenODIPerformanceData" in DLL "Nwpfctrs.dll" for the "OdiLoad" service. Performance data for this service will not be available. Error Status is data DWORD 0." Should solutions bound on WIN98 work on an NT machine or do they need to be bound on an NT machine? Any insight would be appr…
-
- 1 reply
- 734 views
-
-
Can Windows FM 5.0 respond to data submits and requests from Microsoft ASP pages (hosted on IIS 5)? Anyone out there done this? * Though FM 5 supposed to support ODBC, which is I think the connection type to use, I don't see FM listed in the ASP documentation as being supported. * Thanks!
-
- 0 replies
- 629 views
-
-
is there a problem to run FM Server and Unlimited on the same computer : Tks
-
- 3 replies
- 896 views
-
-
I'm attempting to truncate a 10 digit integer(located in a text field as text) by stripping off the last 5 numbers which are always Zeros. Ultimate goal is to make it a 5 digit integer (without the zeros). Can someone point me in the correct direction. Respectfully, Eun Mi
-
- 4 replies
- 740 views
-
-
I have to have a script that will take certain characeters from one field and paste them in another.. for example the record would look like this ---------------------- First Name: John Last Name: Doe Record Number: 26 User ID: ---------------------- and i would like to have a script that will look at the first name and take the first letter and paste it in the userid field.. ---------------------- First Name: John Last Name: Doe Record Number: 26 User ID: J ---------------------- then look at the secondname and take the first letter and put it in the userid field ---------------------- First Name: John Last Name: Doe Record Number: 26…
-
- 2 replies
- 785 views
-
-
G'dday all, I'm designing a database in Filemaker Pro 4.1. I have a customer's database and a quotations database. Now when the user is creating a quotation in the quotations database they have to select a customer. The customer database will be very large however and I don't want them to have to scroll through a long value list. So what I want to do is create an intermediate database. Now in this intermediate database I want to have a field where they can type the information about the customer (e.g. business name, address, etc.) and this field will be linked (in a relationship) to a similar field in the customer database that has all that information. Now when they are…
-
- 2 replies
- 851 views
-
-
Hi I first wanted to thank everyone here in this forum for the help. This forum is the best idea since sliced bread and I have benefited tremendously - Thank you. Now, I am trying create an automated report for work in progress. I have a relationship between cost db and a timeslip db. I need to retrieve the cost from the timeslip db for a certain customer for a certain period (ie: from the opening of the job 1/15/01 until 1/31/01) even though there are timeslip entries after 1/31, I only need the cost up to 1/31. Here is the kicker.... I need this to happen on multiple records and I need it to be automated as much as possible. I know this is just within reach, but I c…
-
- 0 replies
- 640 views
-
-
Hopefully, a simple problem for someone. I wish to apply a wildcard character or equivalent when using an 'If' instruction in a calc for the same field containing similar info, e.g. fields contain 'Door Large' or Door Small' or 'Door Medium' etc. How can I ask FM to identify all fields containing 'Door'? Thanks in advance. K
-
- 3 replies
- 840 views
-
-
Is there a way for a client copy of Filemaker 5 to open a password protected database from Filemaker Server 5? I looked at the open file script step but there doesn't appear to be a way to include the appropriate password. I would like for several remote databases to be opened each time Filemaker is launched. Any help would be much appreciated
-
- 4 replies
- 628 views
-
-
We run a small real estate office on island in Queensland (www.cynthiadykerealty.com.au). Have been using FM for appprox 5 years, FM2 then FM3 now FM4 for managing our listings, feature cards etc on 4 Win98 PC's, peir to peir network. Installed all updates to bring to V3. For window/feature cards we previously printed cards from fm and glued on photos. Now we are going digital camera. Need to print cards complete with photo out of FM. Tried storing photos in database, continually crashes (now know why - 44mb database for approx 60 photos) when FM says maximun 32mb). Have tried every which way to store photos externally and only store reference in FM. Tried JPG, BMP, PSP. …
-
- 8 replies
- 1.1k views
-
-
I know FM Pro2.1 is from the stone ages, but I would like to run FMP2.1 under windows NT4 for test reasons... Anyone tried such an bold atempt /J
-
- 1 reply
- 712 views
-
-
I thought I figured this out, but actually I didn't. It could be quite simple. I'm trying to have 2 criterias for my sum. (Category, Type) I have a Sum d/b. CategoryField= (Meat, Veggie, Milk, Carbo) TotalCost_Expensive Field TotalCost_Medium Field TotalCost_Cheap Field Portal Window(Everything d/: In another d/b, called Everything d/b, I have a list of everything (This is a related file by CategoryField.) CategoryField TypeField = (Expensive, Medium, Cheap) (The Type field applies to Meat, Veggie..etc) CostField Product ---------------------- Example: *Sum d/b. Form 1. Category: Meat Portal row1: Product=Chicken; Type=Expensive; Cost=$500…
-
- 0 replies
- 712 views
-
-
Is there a way anyone knows of to lock windows in FMP 5 running on Mac OS 8.6? I already am running SecureFM to lock menus and the close box, but would like to prevent users from minimizing or windowshading the window. Also would like to prevent manual resizing or moving of the window. The goal is to prevent access to underlying windows in a multi file system except via scripts which perform certain critical tasks. Thanks in advance...
-
- 1 reply
- 677 views
-
-
I am trying to find a way to capture the find criteria so that it the criteria (ie date range) will display at the top of a report. For example, I want to know the work in progress from 2/1/01...2/13/01. Once the "set" is found, I need to have the date range displayed at the top of the report. Is there a way to capture a find range and put it in a field?
-
- 3 replies
- 675 views
-
-
I have all my estimates, orders, invoices in a Filemaker 4.0v1 database that then print out on A4. Sometimes the estimates need to be more than one page. How can I get to run out a second page using the same calculations without creating a new record which would make a new calculation. Cheers Judy
-
- 5 replies
- 1k views
-
-
Set up a password, change the "available menu commands" to editing or none. The challenge is that doing this will dsiable ALL the shortcuts, so you'll have to make buttons on the layout to perform finds, make new records etc.
-
- 1 reply
- 665 views
-
-
I am attempting to develop a ticketing solution in FMP 5. [email protected] (Mike) I have *no* scripting knowledge or experience, however I do know the difference between a field definition and a relationship. I seem to be hung on on a couple of points that seem like they ~must~ be relatively easy to do and need your help, please. The two big items would be: 1) Creating a number of new tickets based on values entered by the operator. For instance, someone walks up to the window and request 20 tickets. The operator enters "20" in the appropriate field, and 20 new records are created and printed. Now, I am thinking "duplicate records based on the current record" to…
-
- 1 reply
- 704 views
-
-
I want to be able to calculate a shipping price total, based on preset prices, but these prices vary depending on weight. How do I add a calculation that figures the weight of the shipment and then calls the appropriate price for that weight? I have not been able to figure this out. I am using Win NT, Filemaker Pro 3.0 Thank you in advance
-
- 3 replies
- 955 views
-
-
In FM Pro 5, when I try to remotely open a file not already open on a host computer I get a message indicating that the file is read only, and I cannot change anything. I have enabled sharing, as well as access priviledges through users & groups but it does not work. Everything is OK if the file is open on the host first. Is this a bug or a "feature"? How can I get around it.? I can't have 75 databases open at once.
-
- 2 replies
- 698 views
-
-
Does anyone have or can direct me to detailed comparison of Filemaker vs Lotus Notes? OR can you relate insight you've acquired while using both apps. Am currently using Fmp extensively and org would like to move to Lotus Notes. Thanks.
-
- 3 replies
- 1.9k views
-
-
Is anyone sucessfully running FMServer 3.0 on Win2K Server?
-
- 0 replies
- 680 views
-
-
How can i use a script to paste from a 3 fields to a portal? I have 3 fields (date, pay & how_pay) and i need a script to press a button and erase from these fields and paste in a portal with other 3 fields same. Please help me it's urgent to me Thanks Jorge
-
- 2 replies
- 604 views
-
-
I have an Invoice file and a line items file for items/goods sold, would it be wise to use the same "items" file for recording payments as well. If I keep all purchases and payments with in the same file I can create a Statement type invoice. or should I have a seperate file for payments?
-
- 4 replies
- 672 views
-
-
Does the database have password protection? Has the machine's hard disk been checked for errors? Is FMP updated to the latest patch level? Des the OS have the latest updates installed? Do you have a backup?
-
- 2 replies
- 603 views
-
-
I am putting together a file of my families recipes and have a problem. I cannot figure out how to expand the field where the ingredients go. If a recipe has more than 14 ingredients, I cannot put it in. Can someone please help me? Thanks, Alli
-
- 1 reply
- 739 views
-
-
We conducted a workshop last weekend with participants in a Mac computer lab and participants in a PC computer lab. The participants completed an online evaluation form created on FM 5.0 Unlimited. The participants in the Mac lab had no problem either with bringing up the form or submiting new records. However, only seven or eight were able to pull up the form on their browser in the PC lab and when they submitted, it gave an error that this page could not be displayed. Does anyone have any ideas about how to correct this problem? Please let me know. Thanks
-
- 0 replies
- 668 views
-
-
We conducted a workshop last weekend with participants in a Mac computer lab and participants in a PC computer lab. The participants completed an online evaluation form created on FM 5.0 Unlimited. The participants in the Mac lab had no problem either with bringing up the form or submiting new records. However, only seven or eight were able to pull up the form on their browser in the PC lab and when they submitted, it gave an error that this page could not be displayed. Does anyone have any ideas about how to correct this problem? Please let me know. Thanks
-
- 0 replies
- 786 views
-
-
If I upload a fp5 file, set as multiuser, to my webhost, then change the file and folder permissions on the website to rwx, should I not be able to add new records or edit existing records from my desktop? I can browse to the site's folder and choose the file that I uploaded and open it. I cannot add new records or alter the records that are already there. I can navigate to all records and perform finds as well as change the form layout. Thanks
-
- 0 replies
- 634 views
-
-
Can anyone recommend the best procedure for sharing a database file between two computers in two locations. Changes are made to each database at each location and then copied to the other. I have copied the .fp3 after changes are made on to a zip disk and then when brought to the second location I have dragged the file over the .fp3 file in that computer in Windows Explorer. Is there a better method using some sort of back-up and restore command. I am currently using Filemaker Pro 4.0 under Windows 98SE. Any suggestions?
-
- 2 replies
- 731 views
-
-
I am having a problem with running scripts over the web. I have set this up so that some DBs work, and successfully run scripts through the web, but others give me a 102 error (missing field). Does anyone have any ideas about what could be causing this problem?
-
- 1 reply
- 656 views
-
-
Dear Friends, I have adapted one of FMP's templates for personnel records to my small mail order needs, I would like to give all my 2500 customers a unique ID number. I know how to give all new customers an ID number but I have come stuck with all the present records, I think i nedd a script or something but i have no clear idea where to start. I have a visual quickstart manual but it doesn't give to much help. Anyone out there who can give some guidance? Rob Dunford
-
- 1 reply
- 1.4k views
-
-
The auto enter from previous record only works in the current session. If you close out and re-open the file there is no previous record. You would need to set up an open script to find the last record created and set those value(s) in some global fields then use the globals to populate the fields.
-
- 4 replies
- 834 views
-
-
I was told there was a way to attach a file by using the send message scipting function, does anybody know anything about this. thanks in advance. [email protected]
-
- 1 reply
- 603 views
-
-
I would like to be able to send SMS messages from FMP. Is it possible ? Do I need something special ? In advance, many thanks. JLM
-
- 1 reply
- 681 views
-
-
After I installed Filemaker Pro 4 on a Windows 98 computer I was not able to enter data in several of the fields with pull down menus. Other pull down menus worked fine. This has happened on several PC's with Windows 98. However, when I installed the same Filemaker on another PC with Windows 98 it worked. I am also able to access all fields from a Mac.
-
- 1 reply
- 669 views
-
-
I'm doing a Kiosk retail product using FM5 under Windows 98. I am trying to trap and handle the Recover command (by using a backup file instead of recovering) in a script. At the top of the script I have Set Error Capture (ON), and I'm testing immediately after the OPEN statement with Status(CurrentError), but the error never gets trapped and the system displays a message about using the Recover command. Is is possible to avoid a user seeing this message and having to use the recover command? If the Web Companion generates an error code (805 according to the documentation), why doesn't FM by itself do the same thing? Thanks for any assistance
-
- 1 reply
- 1k views
-
-
Hey all, I am trying to determine what the best solution is for our company given some requirement by my boss regarding a database. Basically, he wants something that he can download to a laptop and bring to a client, have all the data there, perhaps enter new stuff and then sync up with the database at the office. However, he would also like to if possible have the database web-accessible. The company is mostly Mac with some PC's and he uses a Mac, but we need something that's compatible with both. From what I have gathered from my research we could do a couple of things. We could set up kind of a dual system and use SQL Server on our current host and built a fron…
-
- 5 replies
- 604 views
-
-
I am running a serial number database in a major solution, running on FMP 5.0 server. Problem is is that when users ask for a serial number in that database and increase the number by one, the field is not updated immediately. This may give two users the same number when accessing the field shortly after each other. Is the any possibility of forcing the data update on the server? As I am aware the "Flush Cache to Disc" does not work on servers? ------------------
-
- 5 replies
- 766 views
-
-
I've been searching and searching for an international phone number format calculation - Seems all I can find is US formatting. I would like it to be able to handle both if possible. . .. If anyone has some info on this, please do tell.
-
- 2 replies
- 763 views
-
-
I have an archivist that I am thinking of building a database for. The one thing that keeps us from doing it in Filemaker is that fact that once you enter data is automatically saved unless changed. She has users (not very careful users) making changes to an archive database where she is paranoid that precious data will be changed and can not be retrieved. Therefore, she wants all records to stay the same until the user does something positive (like click a save button). Is there any way that people have found to provide this "commit" function in FM? Thanks, Marshall Spriggs
-
- 1 reply
- 907 views
-
-
1. in the image field of a record I have a text message "jpeg error 52" 2. trying to insert a jpeg [doesn't seem to be corrupted as far as I can tell...]forces a shutdown of program, with a messsage saying that it is generating an error log. Can't find said log... any tips gratefully rec'd! ------------------ rob
-
- 2 replies
- 664 views
-
-
how can i retrieve data from a fm database that is sat on an NT sever from our isp, it works fine locally, but not when we have uploaded our files, please help as our client does not want 2 use MS Access to recreate his database, but so far we can not retrieve the data from FM after it has been uploaded.
-
- 1 reply
- 1.2k views
-
-
I'm having trouble with what you mean by "recognize to a second file". Could you restate what you are trying to do in without the jargon? Sound like you are asking how to build a relationship between the two files. -bd
-
- 1 reply
- 788 views
-
-
I posted the following yesterday, but I haven't received a usable technique yet. Surely this must have come up before? I need a (transparent to the user) method of preventing parts of my solution from opening under the following situation: I'm developing a Kiosk solution (FM5 and Win98) that has 4 FM5 databases as part of the solution. How does one protect the files so that they can't be opened and examined by a copy of Filemaker that also happens to be on a user's machine? I want the files to ONLY be openable by my main file under script control (or by one of my other datafiles also under script control). If I password protect each file, how can I then open them aut…
-
- 2 replies
- 1.2k views
-
-
In FM5 I want to print thefiles fields and field definitions. Under FM5 help I am told to go under "file" to "print" and I will be given to option to print field def's. All I get, however are the options connected with my HP printer and nothing relevent to FP5. Where have I gone wrong??
-
- 1 reply
- 584 views
-
-
Here's the deal. It's a SIMPLE layout, just a bunch of fields. I'm shrinking and sliding up, no problems. However, the fields are running through the page margins, and when I preview and print, the records that cross two pages often will show 1/2 a line on the bottom of one page, and the other 1/2 of the line on the top of the next page. Needless to say, this looks terribly sloppy. Any advice? Thanks Bevin
-
- 1 reply
- 632 views
-
-
I have install my FM server on a NT. but i active my Database and i have this error: (10048) i think for my bad configuration, i have read all the instruction but nothing. please help me.
-
- 3 replies
- 1.7k views
-
-
We publish church directories with FileMaker - we just upgraded 100+ seats to FM5 from FM4.1. Most are on Win98 and we have three NT FM Servers. But our publishing dept uses Mac's and has small files - in single user mode - stored with image files on a Novell 5.1 server. These files are used to drive Xdata and are currently in 4.1 format. With FM5.0v3 on the Mac with Novell client v5.13 from ProSoft, when we try to navigate the directory structure to find a file, the Mac frequently locks up. This will happen before we even locate the file. We are running G3's and found some relief by installing Farallon network cards instead of using the onboard network connector. Usin…
-
- 0 replies
- 616 views
-
-
I recently upgraded from FM 3.0 to 4.0. I keep a database of clients with approx. 7,000 records on two computers in different locations. After converting my file to the new program it remained a managable size of of approx 900KB which allowed me to transport it between computers using only a floppy. After only adding a few dozen records the file has suddenly grown to 2.2MB in size. Using 3.0 even with 9,000 records the file size never exceeded 1.0MB How do I get the size back to where it belongs for easy transport between computers when it is updated?
-
- 3 replies
- 742 views
-
-
A few weeks ago I asked the forum how to email from Outlook/Entourage and received helpful information and as far as I knew all was working like a dream! - Until this wonderful option was revealed to different departments within my company.... The original email senders are all working on macs and the new users are on PC's.... I have a problem... the pc's are reading something different and my body copy is not transfering over. Now, after much investigation, I have narrowed down the problem... On the PC when there is a "subject" line, all the copy including the copy designated for the body, ends up in the subject line. Please see the example of my calculation below - …
-
- 1 reply
- 609 views
-
-
I am making a DB to enter invoices. I am entering every line of each invoice. (Each product I buy) Since there will be many duplicate products bought, is there a way to make the field recognize a description already entered and start typing along with you, like Quicken? This will cut down typing. Thanks in advance
-
- 4 replies
- 856 views
-
-
Is there a way to insert a document name and when clicked on, will open up MS Word if the associations are setup and the extension is .doc? Thanks
-
- 1 reply
- 669 views
-
-
I have a "company" database and a "contacts" database with a portal in the "company" database showing the contacts related to their company. I have a script that prints out labels of all employees from a found set in the "company" database. But what I would like, is to put the employees into groups, to mark them in the portal, and then only print labels for all company's with contacts that belongs to that group. Can anyone help? Thanks Peter
-
- 2 replies
- 965 views
-
-
I have a need to search for a specific date in multiple date fields (6 of them) - one date - six fields to search in. That date should only appear once but it is possible that it could appear in any one of those six fields. Is there a way to search multiple fields? Thanks in advance! s.
-
- 5 replies
- 993 views
-
-
I was wondering if anyone could help me with a problem that I am having. I have created a FM 4.0 database that writes HTML into a single field (called HTML) based on the results of numerous other fields. I am attempting to access this through the web, so that someone would be able to log in using a password, and be returned a web page consisting of the contents of the HTML field as a portion of the page that is returned. I am having problems with the CDML, in that I can get it to return the HTML field to the user, but what they see is the HTML coding itself. I want them to see the web page as the HTML field would format it. If anyone could help me in this, I would…
-
- 2 replies
- 705 views
-
-
-
Can't seem to figure out how to hit my URL so I can remotely admin my DB. I have enabled and password assigned such a feature, but what, if someone could say, do I type in as URL to admin it? Please Help!!!
-
- 0 replies
- 604 views
-
-
I have set up a database to describe the location of cells in Liquid Nitrogen stores.It comprises two relational databases, namely Cells database, which describes cell types and gives details regarding that cell type such as growth media etc. The second database (Banks database) describes cell location within the actual Liquid Nitrogen storage system and comprises 3 layouts. Layout one is the active list which describes all cells currently in the frozen stores, layout two is the inactive list which lists all cells that have been removed and these files have a thaw date. Finally layout 3 which is the data entry list shows all files ever created whether active or inactive …
-
- 2 replies
- 643 views
-
-
Is there a way to convert a number field to a text field with the numbers layout? Example: input =500 fieldlayout as number = $500.00 second field as editable text must be the same as $500.00 and not 500
-
- 2 replies
- 1.2k views
-
-
Hi. I'm trying to pretty up the UI by replacing the grey buttons with pictures/icons. But they all look ugly, with really really bad aliasing. I know that FMP reduces the image to 72dpi but the same picture looks far uglier in FMP than it does in other programs. Any workarounds/tips/suggestions? jeff
-
- 1 reply
- 719 views
-
-
I like to think of myself as not being an idiot, but no matter how much I read from the manual and the help files, I can't understand what the PatternCount function does. Can somebody please explain it? Thanks. Paul
-
- 3 replies
- 614 views
-
-
-
Is there a way anyone knows of to lock windows in FMP 5 running on Mac OS 8.6? I already am running SecureFM to lock menus and the close box, but would like to prevent users from minimizing or windowshading the window. Also would like to prevent manual resizing or moving of the window. The goal is to prevent access to underlying windows in a multi file system except via scripts which perform certain critical tasks. Thanks in advance...
-
- 0 replies
- 744 views
-
-
Hi, I'm trying to make a template for a report. If I make a couple of boxes (fields) then are the sizes always fixed when printing? Is there a way to dynamically shrink, so there is no huge blank spaces? Sometimes my context will short or long depending on topic. Thanks!
-
- 3 replies
- 839 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online