I'm connecting to a FileMaker Server 9 database using a C# application so I can perform SQL actions on it but I want to integrate the domain account I'm using since I can have FileMaker recogn...
I have imported a database from Excel where First and Last name are in the same field.
I would like to split the First and the Last Name in 2 different fields First Name and Last Name.
Does ...
Hey I need to migrate FileMaker to SQL Server. Does anyone have _any_ experience with hooking to FileMaker through ODBC in order to pull data out of it?
I'm using the solution outlined at: http://www.experts-exchange.com/Databases/FileMaker/Q_21732690.html to create a query to an SQL server. However, it doesn't seem to be working to get all th...
I am looking to get an accurate calculation that calculates current AGE of an individual. For some reason I have been struggling with problems from a client, it is possible that they have issu...
Hi,
I have created an odbc connection to a Data Direct Sequalink 5.4 driver being hosted by Filemaker Server 8.
Using Windows Server 2003 with active directory.
I can connect to the data...
I'm running Hamachi on a small network and want to share a FileMaker Pro database over that VPN connection. I am using FileMaker Server 5.5 and wonder if it is possible to open a database over...
I lost the username and password to a FileMaker 9 Server i was building. does any oone know the location of the user account and password file. Thanks
Hi All,
Is there a way to call the last insert id in the SQL.
When I use VB.NET to setup an ODBC connection to FileMaker - I get warnings that the table has no primary key - although the...
I'm running FMP 9 on OS X. When I do a CSV export, the resulting file uses Mac format (CR) line breaks. Unfortunately almost the entire Mac world figured out that Mac line breaks were just an ...
How can I count repeating values and show each of those records how many times that value has been repeated.
I'm trying to show how many people are in a particular hotel room. The relations...
I need help to resolve a Sliding/Printing problem in a report:
main tables: Patients with Name-fields, GeneralCondition-field, Allergy-field, and more
related tables: MedicalConditions via a...
I am trying to invoke the DDE Execute command in a FMP 4.1 script. The goal is to have the script open a specific Excel sheet and run a macro.
can anyone advise if a script can automatically update mysql database at a certain time everyday? Currently we are using some .sh files using a mac and some applescripts. Looking to automate...
Hi,
I'm sure this isn't too hard, but I've looked around on the web and can't seem to find the answer. I want to create a drop down menu where users can choose an account from a value list....
Hey everyone,
I wonder if there is a smooth solution for the following topic.
To make it simple, lets say I have a table with 3 fields: Name, Details, Nationality.
I have one single ...
I have exported whole database from file maker pro as .tab file and then I imported .tab file into MS excel to analyze. But I found some of the data fields are not complete, those fields are m...
I have a single form that I want to be used for:
Quotation (form)
Work Order (form)
Invoice (form)
Same form - three uses.
I have created a value list called OrderType where the val...
I am trying to get a Perl program to read a file and create an outfile. I get all kinds of syntax errors when I run it.
The file I want to read is "C:/PerlScripts/Montag.txt"
Ultimately I w...
do you know how to make gantt chart with conditional form?
sample
http://www.ee-stuff.com/Expert/Upload/getFile.php?fid=7203
i want to make the color green, if each month is in between.
I have a layout which lists details of work shifts in date order. The list is continuously growing and rather than scroll down to the current date each time I open the layout, I want it to ope...
I've been all across the Internet today looking for an answer to this question and haven't found a satisfactory answer.
I'm using FileMaker 8 and I want to be able to change the background ...
i need a field change the money currency, yen, dolloar and euro, change from other field.
do you know how to do it?
should i use "case" script?
I have designed a Joke Database transformed from the Recipes Starter Solution in FileMaker Pro. I have a Form View, List View, Information Layout and Joke Card layout. The Joke Card layout is ...
I am trying to write a calculation that will total the 'parts sold' field by month of the current year and buy month of the previous year. I believe I will require 24 fields in my database e.g...
