FileMaker General Discussions
Older discussion forums for previous versions of FileMaker
-
I've got a Filemaker Pro 3 Server database of about 2000 records that's suddenly lost the ability to toggle between List and Form views. It works if you change the View setting, close down the database, and re-open it again, but you can't toggle in real-time. As this is co-incident with some problems searching in date fields, I'm guessing the database may be corrupted somehow, but my attempts at using the Recover feature haven't worked. I've also tried opening a copy of the database in Filemaker 5 and converting it to Filemaker 5 format..still no luck. Any suggestions? Thanks, Jim Fisher [email protected]
-
- 3 replies
- 747 views
-
-
When I launch FM Pro, it takes about a minute and a half to load. The first screen comes quickly, but the rest takes ages. Once it's all loaded then everything is fine, but it's so slooooow to start. Anyone any ideas? I'm on W98SE, 8oo mghz, 132 RAM.
-
- 2 replies
- 679 views
-
-
Let me try to explain what I mean. Do to nessesity, I have hade to learn how to put together a few DBs with various programs. I currently have my simple, but web enabled service database running with FMPro 4.1. I have also supported a Db in the maintenance department with Paradox 9. The HR department had me doing a few things with Access. With those experiences in mind, I find the options in the pull down menus and the screens available to be very sparse in FMPro. There are no separate "queries", or "Tables". No SQL options that I have found. No screens that make relating tables easy. How do you create a form that calls more than one table ? Can you have a predefined rep…
-
- 6 replies
- 856 views
-
-
What is the key commands to pause or interupt a startup script /opener script? Or should you just delete the file and start again and insert a pause statement? Thank you.
-
- 1 reply
- 609 views
-
-
-
I have a flat application file that is related to itself based on a field (link) whose value is always "1". On the form layout view I have a portal with 20 rows on the left side and the individual record on the right half of the screen. I am trying to scroll through the list in the portal and click on a row and want the record on the right to go to that record. What is happening when I assign the portal field as a button with the goto related record script attached, the record on the right performs correctley but the portal jumps back to the first record and I want it to stay on the "selected/clicked on" record. Thanks
-
- 4 replies
- 686 views
-
-
Is there a neat, free and simple conversion-program available (Somewhere ? Somehow ?) to convert my .xls-files (Office 97) to a FM Pro format for Mac :
-
- 3 replies
- 1.5k views
-
-
IMHO, seperating database and program in different files causes less risk of data lost.. Would someone pls tell me what is the advantage of saving them in the same file as in FMP? -jimi
-
- 1 reply
- 671 views
-
-
So these folks say they need information in "CSV format, pipe delimited". What the heck do these terms mean? And can FMP accommodate them?
-
- 7 replies
- 1.1k views
-
-
I know that you can't modify calculation field. But, is there any other way of going around and modify the calculation fields?
-
- 2 replies
- 799 views
-
-
I can't believe this is so difficult to find, so I hope I am just missing something obvious, though I've been searching web sites and news groups for hours. I have a simple "Price Book" database in FileMaker Pro 5 for Mac. One of the fields is a Text field with a "filename to a JPEG image". I simply want the browse screen to display the picture when a record appears (just like a web page would with <img src="mypic.jpg"> ). I can't seem to find anything to do this, INSERT PICTURE doesn't appear to let you specify a variable for the Filename. The ScriptMaker in FMP5 seems to be highly crippled, I can't manually edit any of the code to forc…
-
- 6 replies
- 1.2k views
-
-
I'm having an awful time relating, and correlating the way that FileMaker Pro5.0, functions and it's terms compared to Access which is the Program I used for a database! Is it me or is it really minus some of the abilities of Access. I keep trying but, I am having an awful time understanding FileMaker Pros functions, and how they will work for me! If anybody knows both programs well, I could use help in a big way!
-
- 6 replies
- 991 views
-
-
I am trying to Match 2 fields from one database to a portal in another. I can do one or the other with relationships, but can't get it so that both fields in the new database have to match in order for the portal to show the data. Example on my job ticket database I have one field that asks for client, in another field I have a request for Job #. I want the other database to display all the jobs for that client and that job number in a portal. Seems simple but I have not figured it out yet.
-
- 1 reply
- 615 views
-
-
Hey people, need a little help if you have the time. I have to replace Microshaft Access here at my work. Does FileMaker 5 read these files?: If not what can? Can anyone answer this questions? Cheers from the Doc
-
- 2 replies
- 900 views
-
-
You could just add 91 days. It won't be quite correct but maybe good enough. The next_rev field is a calculation field where the calculation is: last_rev + 91 result is a date.
-
- 2 replies
- 798 views
-
-
I have a Master menu FM file with buttons to link to other fm files. The script opens the 2nd fm file and closes the menu and has the same procedure to go back to the menu file. However the script doesnt always work and open the other file. What is the best way of linking a menu fm file to a number of different files and back. Cheers
-
- 4 replies
- 681 views
-
-
Do you know what the estimated limit should be on the amount of fields in one database? Is 130 too many?
-
- 2 replies
- 668 views
-
-
I would like to create a database that will allow me to see the records running from left to right and the fields within each record listed below it. Example: (printed) If you were to look at a sheet of legal paper you would see four records going across the paper from left to right. Below each of the four records you would see seven fields (days of week) listed below it. I would like to have two weeks worth of information on one sheet of paper and it's easier to run the information vertical and not horizontal. Can anyone help? -Thanks
-
- 1 reply
- 628 views
-
-
Hopefully someone can help me. I'm trying to breakdown film scripts by the Actors and their Chrono days in the script. I have set up each scene # as an individual record with Scene #, Location, Chrono, Roles, as fields, but when I try to place more than one actor in the roles field via a portal FM creates another record of the scene with just one actor. What can I do? I also want another lay out for each actor displaying only the scenes he or she is in and then be able to makes notes about that scene. Of course I would like all of this to take place in one main form and then filter out automatically. I'm new to FM so please be patient and fairly basic. Thanks for t…
-
- 1 reply
- 752 views
-
-
The problem with posting on other bulletin boards within the FM Forums is that so few people check them. A client has FMPv4 on a PC running Win95. They need to upgrade their system software in order to use a new CD-R they've bought. Can they upgrade to WinMe and still run FMPv4, or do they need to upgrade to FMPv5?
-
- 1 reply
- 760 views
-
-
I have reciently installed a peer to peer network on two Windows 2000 systems. Now I am sharing my solution on this little network. I have gone through all the steps to share my files correctly (open file, hosts, etc...). Every thing is going great... accept when I proform a script (by hiting a button) that takes me to my Job Schedule which shows me all my jobs for today and the future. The script step is simply a Perform Find. Before writing this script I did the find that I wanted done in this script, which was >=// in the Job Date field. This has been working perfectly for about 7 years now. It still works perfectly on the host machien. The problem is that w…
-
- 0 replies
- 685 views
-
-
I have an invoicing database with a parts file,invoice file etc. I have kept the rates by which items in the invoice are calculated in another Admin file with the rates as global number fields. Admin is related to Invoice by the business name and all has been well until I realized that when rates need to be changed they should be of a lookup type so that only subsequent invoices are affected by the changes. I've added new _rate fields in the invoice file that are set to lookup the global in Admin. All are of type Number and I've read all I can find in my docs, but no values appear in the new _rate fields. Are globals not allowed to play that game? Thanks Bill Jayne…
-
- 4 replies
- 548 views
-
-
I am trying to find a range of dates automatically in a script. When I execute the script I get a question mark in the date, and a statement that no records match the request. The script reads: . . Enter Find Mode [] Set field ["date","Date(Month(Today),Day(Today-5),Year(Today))..Date(Month(Today),Day(Today),Year(Today))"] Perform Find [] How do I go about scripting this to find the last five days?
-
- 2 replies
- 1.2k views
-
-
I have a list of 1000 potential jurors. I need to be able to select, say 100, random jurors and put them into a separate database. Eventually, the unused jurors will return to the 1000 potential jurors. I have tried using RANDOM but the Random field must be able to be recalculated at will and also I can't get it to create unique integers. (Geaorge, I sorry. Ididn't explain myself very well.)
-
- 4 replies
- 774 views
-
-
I have spent most of today on this scripting problem and have not found the answer either in my mind or in this forum. I need to identify records in an inventory database. I have a field for 'date last sold' and 'date last received.' I need to find stuff where both of these field are more than a certain number of days. Like for instance, stuff we haven't received or sold for 90 days. I want to make this a variable report, so the report generator can put in the number of days and the date they want to count from. So far, no problem, just use a couple of global variables and an entry screen. Here, however IS the problem: I want an expression in Find mode like: date receiv…
-
- 3 replies
- 861 views
-
-
Hi. I'm building a solution for my clients and I was thinking how could I make some kind of master file that's store the company's name, logo, home address, telephone number etc. that is used then in related files, printouts etc. Is it possible to use global field? Thanks, ------------------ Reynir
-
- 1 reply
- 840 views
-
-
In my bound solution I've included both an "About" script and a "Help" script. The "About" script works beautifully. The "Help" script works -- once. Then, when I close the Help file, the "Help" menu choice disappears. Even when I'm working from the main file, which is always open. How can I keep the "Help" menu option available after closing the Help file? As I said, the main solution file is always open, so that's not the problem.
-
- 0 replies
- 657 views
-
-
I have come across a problem in my database that I did not foresee. Each product has a set of "testing areas" that we need to watch for. For example "Product A" has 4 testing areas that may fail. So when you are entering information for "Product A" and "Test 1"fails you need to enter the number of product A's that failed in the "Test 1" area. Down the road as a "Product A" changes it's "Testing areas" will change. What is the best way to set this up so that when "Product A's " testing areas change, I can make the changes to the "Testing areas" and the old records will stay the same?, and the old reports will stay the same? Basically, I need to be making changes to …
-
- 3 replies
- 645 views
-
-
How do I get the data that's in a portal to display in another field as a drop-down menu value list? Thanks!
-
- 3 replies
- 1.2k views
-
-
NEVERMIND WE SEEM TO HAVE TO MANY MACINTRASH USERS HERE. Besides i figured out my problem. [This message has been edited by ttinsman (edited March 07, 2001).]
-
- 0 replies
- 575 views
-
-
THANK YOU VERY MUCH FOR THE INFORMATION YOU HAVE GIVEN ME. I HAVE RUN INTO A NEW PROBLEM. I CREATED MY RELATIONSHIPS AND LOOKUPS AND I NEEDED TO CREATE SOME FORMULAS IN MY REPORT TO GRAB THE APPROPRIATE INFORMATION. I AM NOTICING THAT WHEN IT GRABS THE APPROPRIATE INFORMATION FOR THE REPORT IT WILL SAY 4 RECORDS FOUND AND YOU PAGE THROUGH THEM AND IT IS THE SAME RECORD AS THE FIRST. EXAMPLE - I SEARCH FOR PRODUCT "Z" THAT WAS COMPLETED IN MARCH. THE TOTALS GO INTO THE APPROPRIATE AREAS FOR MARCH BUT YOU HAVE 4 RECORDS FOUND, ALL THE INFORMATION STAYS ON THE FIRST RECORD. WHICH IS OKAY UNLESS PRODUCT "Z"'S "TESTING AREA" CHANGES IN THE MIDDLE OF THE MONTH. ON THE R…
-
- 3 replies
- 767 views
-
-
I have two databases. Each record has a number in both databases I want to write a script that will take a number from the fist data base and preform a find in the second data base.
-
- 1 reply
- 650 views
-
-
I am currenting using email to transfer files to outlying associates. I am doing this interactively. I want to automate the process. The problem I am having is in creating, automatically, a file id. My thought is some sort of concatenation of my id, month and day, and associates id. For instance, HMH0413XXX would be the id for a letter from me on the 13th of April to XXX. Can anyone tell me how to do this through scripting.
-
- 3 replies
- 772 views
-
-
I am using a calculated field to build a filename. I now want to use that file name in an export specification. I want a script to copy the filename from the calcuated field (have been able to do that) and then paste the name into the export file. Then the script should be able to cause the export scripting step to complete itself without operator intervention. I have been able to copy the name into the clipboard, but I have had to use the CTRL-V keystroke to insert the name at the export filename spec, and then press the enter key until the export is completed. It is really not too complicated, but I am trying to get it to complete itself so that other operators wi…
-
- 1 reply
- 1.1k views
-
-
When trying to insert picture into a container field, I received an "error -43 occurred during initialization of Claris XTND System" msg. I've checked the technical q/a at filemaker.com but couldn't find any reference to this. Anyone have any suggestions for a possible solution? Thank you.
-
- 4 replies
- 620 views
-
-
-
Patience please ladies and gents. 1. When I import a jpeg image into a container field (as a reference only) there appears to be a limit on the image size apr 2megs; much larger and jpeg error #53 is returned. Is this correct? If so how do you reference and therefore display larger images? 2. Anybody fancy giving me a laymans/idiots guide as to how I would open the images, as per 1 above, in photoshop or similiar. I am using macs. When I say idiots guide I really do mean idiot. Thanks in advance for your help Regards Lawrence/Anne
-
- 1 reply
- 677 views
-
-
Who can help me by telling me the possibility about communication between FM Pro and an LDAP server? It's realy very important and urgent. Thanks in advance Eve SilverTop.fp7.zip
-
- 1 reply
- 1.5k views
-
-
Here is the situation (please help!): I am running a mac using system 9.1 (with 256mb of RAM), fmp 5.0 with latest updates, and AOL 5.0. About 75% of the time when I am in AOL mail and I return a fmp database, fmp crashes with type 2 or type 3 error. I thought this was possibly a memory starvation problem so I set fmp's memory in Mac os to 30mb then 45mb then 60mb. Situation the same. I then reinstalled both AOL and FMP (first AOL, then FMP and then vice versa). I ripped out preferences, fonts. etc. No change. If I change the memory allocated, it sometimes works for an afternoon and then back to the same situation. Any advice. This only happened since I change to versio…
-
- 1 reply
- 747 views
-
-
We have a client who have a performance problem with there new computer Dell Optiplex pentium III 800. They installed FMServer 5 and FMP 5 on the same computer (using WinNT workstation). When they access to the server via the LAN their is no speed performance problem but when they access via the FMP installed on the same computer it is VERY, VERY, VERY SLOW.... Any idea of what is the problem : By the way, the FMServer console open but is not working, any idea :
-
- 2 replies
- 571 views
-
-
how do I make that performs an external script? (like run a script in another file)
-
- 1 reply
- 699 views
-
-
I'm just starting with FileMaker (5.0) and cannot find in the help how to size new layouts. The samples files provided are nicely built layouts with that standalone look. But when you start a new layout and add fields to it, the page is like a humongous spreadsheet (in layout mode) - you can scroll right and down almost indefinately. And there are no right or bottom borders you can grab and drag to size the layout. So how do I do it?
-
- 1 reply
- 1.4k views
-
-
I have 4.0 & 5.0 question... I am using the program to invoice customers...My invoice records have customer i.d., date, labor, materials... labor and materials are repeating fields... I am interested in creating a layout so that I can look up all materials for one client in one form... all i can do now is create a layout showing materials but it is separated so that each record for a particular client has repeating fields... I was to create a layout so that I will be able to show all materials on one form for one year for one client (though the client may have 14 records with 10-15 materials on each record) Also...when I try to export the repeated fields (mater…
-
- 1 reply
- 708 views
-
-
I want to create a field that would always add the number preceding it, the field would be cumulative. Is this possible and if so , how do I proceed. This field would be part of a timesheet and it would add time spent on projects by different employees thanks Gary
-
- 2 replies
- 661 views
-
-
I am trying to get a script to work. I have several databases tied together (relational) and I want a button from one layout in a specific database to bring another layout on a different database. I keep trying with no success. Can anyone help?
-
- 1 reply
- 599 views
-
-
I'm looking for the FMP3 buttons... the ones that came with the program. i have them on a CD, but since i have FMP5 on my computer, it won't read the CD (at least, i think that's why). All i want are the buttons file for a database i'm currently building. does anyone have this file they can email me?
-
- 3 replies
- 922 views
-
-
I'm not sure if I neeed a script to do what i want to do.. Basically i have 2 feilds a (Date feild) and a (week no feild. Is there a way I can make the Week feild know what week it is in the year by looking at the dat. is there a script of some sort to do this. Cheers Carlos
-
- 1 reply
- 686 views
-
-
Apologies if this has been around before, but I can
-
- 10 replies
- 792 views
-
-
I have recently been asked about using FMPro in an enterprised environment (Oracle etc) Lots of Acronymns where thrown around like COM+ and EJB,R3 etc which mean little to me at this stage. What I would like to know is does anyone know where i Can go to see how FMPro can be used with these larger systems and what the pitfalls might be. Cheers in advance
-
- 1 reply
- 656 views
-
-
5500*0.0157 should be exactly 86.35 right? but in FMP it gives me 86.349999999999999 where truncate(num, 2) will be 86.34, I have tried to round it to 3 dp b4 truncate, even tried to change the round result to text and then back to number for truncating, it still gives me 86.34 how can I fix this error? -jimi
-
- 5 replies
- 824 views
-
-
Are there any script to close the whole File Maker Pro application but not only the files? -jimi
-
- 2 replies
- 755 views
-
-
I want to disable keyboard shortcuts within a particular layout for security purposes. In particular Find, Print, Delete. I'm currently using fp3. Any suggestions would be appreciated. Thanks
-
- 2 replies
- 746 views
-
-
I've read on line at Filmaker.com that those who have FMpro v2.1 can get an up grade to FMpro v3 which is y2k ok. But when I called their 800# all the gal could tell me was I couldn't get the full version of FMpro v3,only some upgrades. She didn't know what upgrades ment, v2.1 to v3 or for v3 only? I don't want to shell out the bucks for FMpro v5 until I play around with what I already have. FMpro v2 works and I don't see any y2k problems ahead unless I'm wrong. Anyway how long will FMpro v5 be good before. I'm upgrade poor as it is. Thanks for any help. Ed...
-
- 3 replies
- 637 views
-
-
How can I move or copy the first 100 records to a new database file?
-
- 3 replies
- 684 views
-
-
I'm working on a database file where each layout window size needs to vary. Can windows in each layout be sized so when navigating using buttons, each layout displayed will have it's own size? Thanks.
-
- 1 reply
- 729 views
-
-
So this Windows95-based client has to upgrade their OS in order to hook up a CD-R. The question is, can they upgrade to WindowsMe and continue using FMPv4, or do they need to stop with Windows98? And is Win2K even an option here?
-
- 1 reply
- 656 views
-
-
I have a field that is called zip code which some records have zip only and others have a space then zip + four. I can perform a find on the records to just locate the zip+four records, now I want to move only the last four numbers to a new field and leave the five zipcode values in the field. How can this be done? Thanks
-
- 2 replies
- 605 views
-
-
-I want to design a layout to display a 3x3 grid of cells, each cell representing a position in a storage box for sewing buttons. -Each record will contain 9 fields, one for each cell of the storage box plus a field indicating box number. -Assume I have the contents of 10 button boxes entered into 10 records. -How do I search for all "blue" buttons and display for each hit, the corresponding cell contents, grid position, and box number in a spreadsheet-style layout? Alteratively, how could I do the same thing using a unique record for each cell and still easily display the box view showing its contents and easily print a catalog of the 10 box views? Thanks for any…
-
- 5 replies
- 2.3k views
-
-
I have a file "invoice" which store the main info of invoices(such as customer name) and another file "invoice txn" which save the content of each invoice (such as item purchased). In an invoice, for each item in Invoice Txn, I have to run some script and decide whether I need to keep it in another file "invoice item" If all above processes are run thr' a LAN, would it be greatly slowered because of the repetitive process? (for me it's more than 10 times slower than run in server) thx for any suggestion
-
- 1 reply
- 572 views
-
-
I have two Macs networked. How can I prevent people from closing windows on the host machine. I try to have them always hide but they close out of habit. I also need a script that will open all the files I need then hide them all. I created a script that open, hide, open, hide but it doesn't work. It only opens all the files. And lastly. . . How can I have the guest machine automatically open a file from the host? ...steven
-
- 4 replies
- 821 views
-
-
quick question hope someone can answer: anyone have any experience integrating quark xpress tags (a semi-scriptable page layout program) into filemaker? tia jeremy ------------------ Life's great when you're a millionaire. . . well, ya know, i'm assuming.
-
- 5 replies
- 811 views
-
-
I am attempting to route output from scripts to various printers. Can I accomplish with Filemaker or will I require a plug-in to do this?? Thanks.
-
- 1 reply
- 606 views
-
-
Can I write a script which opens another database and then searchs through this database for a record
-
- 1 reply
- 553 views
-
-
Hello, I'm trying to figure out how to determine how many of a unique item occur per category, using the following sample database: Bank Park Chase Everglades Mellon Yellowstone Mellon Everglades Citi Central Chase Everglades Mellon Central My goal is to set it up so that I get the following info: Bank Mellon 3 Chase 2 Citi 1 Park Everglades 3 Central 2 Yellowstone 1 I'm using FM 4.0 and tried doing this with subsummaries, but things never work out correctly. I've been using FM for awhile, but only sporadically and still consider myself to be a newbie. For the past two days, I've been struggling with this problem (and the manual)…
-
- 0 replies
- 723 views
-
-
I need to export records from one file to another. Unfortunately, the records are being exported out of an FM 5.0 file and they need to be imported into an FM 4.1 file. When I try to do this I get a message that reads the files cannot be read. Is there any hope? Thanks
-
- 1 reply
- 762 views
-
-
Hi, the connection between the FileMaker Pro and ASP was solved. But I encountered another problem. I can only display text data in the web browser but display "rubbish" for the image, e.g "???A[]AA". The data is retrieved from FileMaker Pro database and I use dreamweaver ultra dev to display the data in the asp form.
-
- 0 replies
- 645 views
-
-
My script is complicated because this test doesn't seem to work: IsEmpty( Status(CurrentFieldName) ) Am I asking too much?!
-
- 4 replies
- 837 views
-
-
I'm having some terrible problems with filemaker pro 4.1's internally stored record numbers. My understanding of this special record number field is that Filemaker is supposed to generate a new unique value for it for every record that gets created in the database. I also expect it to increment serially through the entire life of the database. But instead what I see is that when a new record gets created, sometimes the record number for other records in the database get "pushed up" by +1 and the new record is assigned a previously used record number. Example: John Smith=1 Bob Jones=2 Lisa Clay=3 Tim Riley=4 Create a new record: Sharon Taylor You get: John S…
-
- 3 replies
- 819 views
-
-
I have created a page that will reside on our www site. This page will be used to input customer info. i will then want it to be downloaded to my fmpro file that resides on my network here. Can someone give me some help doing this or can you point me in a direction that will help me out. Thank you very much. ------------------
-
- 0 replies
- 906 views
-
-
I have a button in dbs #1 that opens dbs #2. Is it possible to have it also make dbs #2 the active window? TIA, Bill
-
- 2 replies
- 706 views
-
-
RE: My earlier 4.0 vs 5.0 question. I have several users who need to buy 4.0 and can't find it anywhere. If we can't find it, looks like we will be forced to upgrade everybody to 5.0. In my user group that'll be about 20 clients plus the server creating a budget crunch. Anybody know where I may buy 4.0? Thanks
-
- 1 reply
- 552 views
-
-
Hi, may I how to open a FileMaker database connection in ASP? Another question I would like to ask is that, how does the ODBC FileMaker Pro driver know which FileMaker database to connect to when only the datasource name and description is specify? Is it that the datasource name must be similar to the database name? Thanks.
-
- 0 replies
- 691 views
-
-
Hey, All-- I'm sorting a portal row by the Creation date descending. The relationship is set to allow creation of related records. This brings the latest dates up first, however, the blank record is still at the bottom, and is frequently hidden below the scroll. Is there any way to have the blank record appear first, st the top of the portal? Thanks Jeffrey Ellis
-
- 2 replies
- 774 views
-
-
I have a database which stores the paths to high quality images. The number and size of the picyures makes storing them directly impractical. Is there any way to show the path to the picture without having to manually input it. Obviously FMP knows where an image is. How does one display that information? TIA, Bill
-
- 0 replies
- 656 views
-
-
Am attempting to build an automatic online email database where web viewers enter their email to receive monthly newsletters via email. Which Filemaker product should I look into? Too many options for this newbie and I don't know where to begin or what the correct term I should be using when I speak about this email database. Any advice or resources would be greatly appreciated.
-
- 1 reply
- 634 views
-
-
I am using FM5.0 and would like to be able to publish my database to my website's server that is not located at my ISP's server. Specifically, I want to be able to send it to tripod.com or zkey.com. Is this possible? If so, how? THANKS anaserene
-
- 1 reply
- 655 views
-
-
I'm new to FileMaker so I may be way off track, but here's my question: How does FileMaker know which file to open if multiple machines are hosting files with the same name? We have FileMaker Server 5 and it is hosting a file named "Y2K". As a test, I created another multiuser file named "Y2K" on my client PC (with totally different fields). I tested a script which uses the "OPEN" statement and it appears to open the first file named "Y2K" (which happens to be on my PC, not on the server). What this means is that now that we've had to put a fully-capable client on each user's machine, any user could potentially screw up existing scripts, etc. by simply creating and hos…
-
- 3 replies
- 791 views
-
-
Does anyone know of a database or template that tracks vacation. We have 350 employees and are currently using FM5.0 to keep track of other employee information.
-
- 0 replies
- 910 views
-
-
I have managed to connect to an FMP db from a VB 5.0 program using ODBC. I can create a recordset and read the data. The question now is how do I write to it. I have the options set in the program to open the recordset to allow read/write but that apparently doesn't matter since as soon as I issue an Edit command I get an error indicating that the recordset is read only. What am I missing? Is there some setting in FMP that might be wrong? As always all help will be appreciated. Dave [email protected]
-
- 3 replies
- 1.1k views
-
-
I would create a calc field that returns the month and year of the date. Then create a layout with a sub-summary part when sorted by this new calc field. Next, do a sort on that field (and any other fields you want, such as "Product", "Customer", etc.). Then create a script that sorts, goes to the layout with your new sub-summary part. Note: The sub-summary will only show up in Preview mode (or when you print). HTH, Dan
-
- 2 replies
- 844 views
-
-
Hi folks, We have a File Maker server behind the firewall. I want to host with TCP/IP but I don't know which port(s) should be open for this. Thanks for your help, Yalcin
-
- 1 reply
- 864 views
-
-
I am running a filemaker database from a server and giving access to users to log in via a web browser. All this is working fine, but when they log in the web page has <align> tags all over the page. For some reason if you log into the databse via a web browser on a PC it looks fine, using the same web browser on a Mac and the database is distorted. Does anyone have any ideas. Much appreciated. Carlos
-
- 2 replies
- 683 views
-
-
When importing JPEG pictures into a container field in File maker, there is an error saying "JPEG Error #53" Can anyone help with this? The error is shown with larg meg size pic is being imported. However the manual states any size can be imported. Any help would be good.
-
- 2 replies
- 872 views
-
-
i was wondering. it says you can build royalty-free runtime solutions. does this mean you can build a program that will run just like filemaker, but for a single database? and can i still use all my scripts? and how many computers can i have this runtime application on? ------------------
-
- 2 replies
- 675 views
-
-
Please Help! In my database I have several questions that use radio buttons with value lists. I would like to figure out how to display the total number of specific responses for each value from the list. So if I have a possible response of YES, NO or MAYBE.. I would like to have a results page display how many people chose YES, how many chose NO and so on. ANY HELP WOULD BE GREAT! I cannot seem to find this in the books I have.
-
- 2 replies
- 594 views
-
-
Hi- I am having a problem thinking of a way to list all of the managers for a department for each page. (There are hundreds of departments). The current page break is department but each department contains multiple managers. Currenty, Filemaker is only listing the first manager on that page instead of all managers. Is this possible in FileMaker. I can't use a global field because the information will change for each page. Please help. Thanks in advance for any response. Thumperman
-
- 2 replies
- 588 views
-
-
Hi, I'm looking for a method to generate random PIN numbers. These PIN numbers will be used to access a secure site. Question: How do I create a field that generates a random number (lets say with 5 digits?) For example: 47618 Thanks.
-
- 2 replies
- 770 views
-
-
In contract db I calculate monthly sales. In find mode I select individual sales rep to calculate monthly sales for the rep. Now I want to run a report for all sales reps showing their individual performance. I would like to save the reps monthly actual in the rep db where there is a record for each rep. Of course there is other stuff like quota and year to date actual versus quota that I think I can handle.
-
- 1 reply
- 628 views
-
-
On the invoice layout are number fields, for financial stuff. I need to make these number fields accesible for letters (PM: Pro Memory). I know this is not possible. I could change the numbers field to text, but then I'd loose the way numbers are displayed (Fl xxx,xx) I tried placing wo fields on top of eachother, one text and one number field, but how do I make sure the number goes in a numberfield and text in an text field. Or is ther another way to solve this? Hope I made myself clear.... ------------------ Yeti
-
- 5 replies
- 608 views
-
-
Members of my user group are rushing me toward adopting FM 5.0. I was told that we could stay with 4.0 because we have a small network of users, and 5.0 was mainly for internet compatibility. Should we go to 5.0 regardless? Thanks.
-
- 2 replies
- 758 views
-
-
I want to know if it is possible to make a data base run indepedently of the File Maker Application. (Like compiling for Computer code)
-
- 1 reply
- 644 views
-
-
Hi All! I have a problem converting an FM3 database to version 5. I have a text fields, which contain non-English (French, for example) text. Conversion to FileMaker version 5 destroys almost all accented characters. The only solution I know is to export all data from FM3 and import it into FM5 converted file. Perhaps, there is another (more
-
- 0 replies
- 694 views
-
-
Hi, I am in serious need of a FilemakerPro5 database programmer. This is a very good opportunity for the right person. If you want to work on a contract for 6 to 9 months at Apple Computers in Sacramento. Let's talk. This is a full-time position on site. ------------------ Terri Holub Technical Recruiter [email protected]
-
- 3 replies
- 632 views
-
-
I can't seem to be able to do this in the layout. Is there anyway to put this on the layout so when I print reports with multiple pages, it will display page 1 of 3, 2 of 3, 3 of 3, etc. Please help. Thanks! Thumperman ------------------
-
- 3 replies
- 667 views
-
-
From previous responses, thank you very much, I learned how to take info from one DB which had an active and inactive field to show only active customers in a pop up menu in other DB's. New question: If there a way to show active items from 3 different DB's in the same pop up menu: example I have a JOB db which has job numbers and I have a SERVICE DB which has service numbers. Can I make a pop up menu look for active service #'s and active job #'s and disply them in the same pop up menu? Thanks in advance
-
- 0 replies
- 550 views
-
-
I'm creating a Sales/Contact Dbase and want to write my docs in Word (mac). Can I link specific docs to specific records and possibly access the docs through FM. Maybe a script that accesses Apple script and opens the doc? Is there a built-in way? They advertise seamless integration w/ office, but I don't see it.
-
- 3 replies
- 732 views
-
-
Any recommendations for easy faxing from Filemaker 4 using Windows 98. I used to do this very easily on the Mac using global village fax software - just hold down the apple key and file print turns into file fax. No such luck on new PC software it doesn't recognise Filemaker 4.0 at all. Any suggestions would be much appreciated
-
- 4 replies
- 939 views
-
-
The conversion seem to go smoothly. However, the formulas didn't seem to make it. creating the formulas across are no problem. Can't figure out how to create formulas for columns. any suggestions> ------------------ -------------------------------------------------------------------------- Phillip M. Jones, CET |MEMBER:VPEA (LIFE) ETA-I, NESDA,ISCET, Sterling 616 Liberty Street |Who's Who. PHONE:540-632-5045, FAX:540-632-0868 Martinsville Va 24112-1809|[email protected], ICQ11269732, AIM pjonescet -------------------------------------------------------------------------- If it's "fixed", don't "break it"!
-
- 0 replies
- 790 views
-
-
Sorry for the incredibly basic question. I am very new to FM. Bear with me as I get up to speed. What is the proper way to make FM go to the beginning of the first line in a large text field? Is there a sendkeys equivalent in FM?
-
- 2 replies
- 681 views
-
-
I was wondering if you can do a calculation and after the calculation is performed it stays unique to that DB. Example: I have an employee database which has a "hourly rate" field. I also have a timesheet DB that looks at the employee "hourly rate" and calculates the hours work times the rate. If months later I want to increase the hourly rate I do not want it to affect any previous timesheets, just the new records. Any help is appreciated: Dave
-
- 3 replies
- 810 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online