I have a calculation that takes this information from another field: 5/11/2006 10:27 AM
and converts it to: {ts '2006-5-11 10:27:0'}
Here's the calculation:
"{ts '" & Year (fDate_Modifi...
Hi All,
How do I say 'NOT EQUAL' in an SQL statement for FM 6.0 Pro
!= does not work!
Cheers
Is there a Now() or equivalent function in Filemaker Pro 7 (Mac) that would allow me to build a SQL query to select only records with a date of "right now" and 5 days before?
Right now I ha...
Hi, I would like to convert a filemaker pro database to a Ms Access one.
I export the records to Access.
Now I have a question about repeating field in Filemaker pro, when I convert the ...
can we install oracle on windowsxp professional ?
This is what I am trying to do:
I have a file that contains countries, companys and email addresses, I have this file in .doc(MS Word) and .txt format.
I want to parse these information in...
Hello,
I have set up a database in Filemaker Pro 8 on my Mac, and I want to query the records. I have experience with PHP/MySQL and also a little with MS Access querying. I thought it would...
I host a PHP Web site that is connected with FX.php to a FileMaker 8 Advanced data base. The database contain PDF stored in multimedia fields (fields that can contain files). I can make links ...
The Edit/Sharing/FileMaker Network Settings will show me how many users are presently connected to the database, but not who (account name or IP address). How can I find this out ? It would be...
Hi Experts,
I am trying to create a payroll / leave system in Filemaker. The objective is:
1. Get daily time & attendance data from bio metric machine from remote offices
2. Import the ...
can I write a n execute SQL' statement to query into the field definition for a calculated field? If so, what is the format in the calculated field 'options' dialogue?
I am running a script to filter records by Year which works well. The only problem is that I have to enter the year in question in the actual script. What I want to be able to do is select a y...
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...
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 have a filemaker 3 database that I converted to filemaker 5 format using Filemaker Pro 6 on Win XP. I would like to convert the database to SQL Server. I have no experience using filemaker...
(Using FileMaker Pro Avdanced 8.5v2)
I am working on a database that will act as a Purchase Order system. It has two tables:
1. Accounts
2. Purchases
"Accounts" contains two fields wi...
Hi,
Does anyone have experience running Filemaker with Windows 7 64 bit?
We run Filemaker Pro 8.5 on several laptops through a simple LAN, accessing Filemaker from a PC. We are looking a...
Hi There,
I am trying to open a cash drawer in VB6 that is connected to a PRP-085lllT thermal receipt printer via RJ45 Telephone like cable. The printer is connected to the pc via usb.
...
I have hidden the left navigation pane from users, but I need to let them know how many records they have found when they perform a FIND? is this possible?
thx..BobR
Can anyone explain whether FileMaker or Access is a better tool for a school database to track people, mailing lists, donations and pledges, fundraising campaigns, and assorted data like after...
I have records which are duplicates. I can easily find the duplicate records but how can I delete them while leaving one of the duplicates in the database .
thanks
Is it possible to use a 32-bit ODBC driver in a Win 2008 64-bit OS machine ?
Is 32-bit emulation mode related in any way ?
I have a new layout I'm creating that will be used for reference by staff. On this page, I'm planning to put a label called Marketing and then put a few links underneath of places we use as v...
Greetings,
I've found several questions about creating a file to open a remote filemaker db.
How do I modify that script so it opens a specific database instead of just opening the ope...
At the moment, we are sending out emails with text only however they are wishing to shift to html formatted emails.
All the content are stored in the FileMaker Pro DB and I'm not too sure w...
