FileMaker Legacy fp3 and fp5

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?

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…

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…

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?

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.)

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…

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

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.

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 …

How do I get the data that's in a portal to display in another field as a drop-down menu value list? Thanks!

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).]

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…

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.

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.

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…

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.

Fairly new user of filemaker. Transitioned from old Q&A (dos) and currently Access 2000. Would like a suggestion for reference which goes into detail with scripting. Thanks. HHill

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

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

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…

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 :

how do I make that performs an external script? (like run a script in another file)

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?

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…

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

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?

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?

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

Apologies if this has been around before, but I can

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

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

Are there any script to close the whole File Maker Pro application but not only the files? -jimi

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

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...

How can I move or copy the first 100 records to a new database file?

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.

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?

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

-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…

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

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

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.

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.

Can I write a script which opens another database and then searchs through this database for a record

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)…

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

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.

My script is complicated because this test doesn't seem to work: IsEmpty( Status(CurrentFieldName) ) Am I asking too much?!

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…

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. ------------------

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

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

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.

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

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

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.

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

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…

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.

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]

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

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

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

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.

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? ------------------

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.

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

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.

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.

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

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.

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)

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

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]

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 ------------------

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

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.

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

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"!

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?

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

Running FM unlimited 5v3 WebCompanion v6 G4 450 256Mo Web Security 1 open Database I was running Filemaker unlimited for a couple of months without any problem, but since last week, Filmaker quits several times a day, for any reason with error 2, 3, or 10. I've tried to re-install it, scan disk, change computer, rebuild the database (export data, create new bank db and reimport), changing IP ports. It's crazy, the problem remains I wonder if I'm a victim of kind of pings attacks or something. Is there a security problem with this solution ? Thank you for your help.

Using v3.0v6 on NT I'm trying to print a total at the bottom of the last page of a report. I have used the suggestion found in the support database--Adding Continued on Next Page Formatting to Reports--by creating a number field, a calc field comparing the number field to the current page number. Then setting the field in a script. The problem is the report looks fine in preview mode, but when I print it still puts the value on every page. Suggestions?

Is FM3 server compatible with OS 9.x?

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.

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

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

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

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.

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

I am a beginner File Maker Pro user and I need help with database sharing does anyone know a good free resorce for database sharing.

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?

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

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 ------------------

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?

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.

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]

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

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

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