On windows 7 (VMware on OSX), using FMP17 and Microsoft Access 2016
Trying to do a ODBC import and selecting the datasource, I get asked for Username and password, even if the Access DB is not password protected.
The data sources are correct (tested from Livecode) and should be working without user name and password.
On the properties of the ODBC pane setup the path seems correct (not pointing to 32): %windir%\SysWOW64\odbcad32.exe
What am I missing?
I have a customer that has 3TB of photos in the program Picasa. They use it to edit images and then put some in Filemaker. Currently the images are on a NAS. The problem is it seems to be getting slower and slower. Picasa is discounted so I'm looking for a replacement that can handle the large amount of images they take on the job site and interact with Filemaker, seamlessly. they run on a windows platform but would like to perhaps introduce iPads to the mix in the future.
Not sure if this is the right place to post this question but I thought I'd give it a go.
Any guidance on the matter would be greatly appreciated.
I have a video in a global container field. If I play it in one record, say from start and for 10 seconds, and then move on to the next record, the video is from the beginning again. I would like the video to stay in the last paused frame, no matter what record I move to, Is this possible? And if so how?
Thanks for any help
I use FMPro infrequently--and would be most appropriately described as a novice. I've received help with the script below--but my portal isn't sorting by alphanumeric order--in the order I want it to.
I have a text field in my portal called __pkPosnCtrl. There is a max string of 20 characters in this field but location of letters or numbers within the field vary. The script allows my records to sort by toggling back and forth between ascending and descending order. There is an optional script parameter of "__pkPosnCtrl" which appears on a button over the portal label. Below is the script (I've added comments to help me understand and remember what the script is doing.)
Set Variable [$SP; Value: Get ( ScriptParameter)]
If [IsEmpty ($SP)]
Exit Script 
# make sure a record is active
If [Get ( FoundCount ) = 0]
Exit Script 
Set Variable [$SortField; Value: Get ( ScriptParameter ) ]
If [t01b_departments_POSITIONS::SortField = $SortField]
# If the $SortOrder is not equal to 1 go ahead and set it to 1, otherwise set it to 0
# Allows the enduser to toggle back and forth between ascending and descending order
Set Field [_t01b_departments_POSITIONS::SortField = $SortField]
# Since the $SortField is not equal to the column you just clicked go ahead and set the sort field
# equal to $SortField (of that colum)
Set Field [_t01b_departments_POSITIONS::SortField; $SortField]
# equal to $SortField (of that column)
Refresh Window [Flush cached join results]
Additionally, I'm sorting the relationship between my parent table T01_DEPARTMENTS and my child table _t01b_departments_POSITIONS based on 4
SortValueDynamicAscNumber, Unstored, from tblPOSITIONS, = Case (SortOrder=0; GetField (SortField))
SortValueDynamicAscText, Unstored, from tblPOSITIONS, = Case (SortOrder=0; GetField (SortField))
SortValueDynamicDescNumber, Unstored from tblPOSITIONS, = Case (SortOrder=1; GetField (SortField))
SortValueDynamicDescText, Unstored, from tblPOSITIONS, = Case (SortOrder=1; GetField (SortField))
When I perform an ascending sort (descending is also an issue) the result I'm getting is:
DevGrantWritPt48s1 DevMktgCoordFt66s1 DevCorRelEvMgrFt80s1 DevPreCirPGMgrFt80s1 DevVpAdvanceFt80s1 DevGiftProDbaFt80s2 DevAnnFunRCIIFt80s32
But what I want is:
DevAnnFunRCIIFt80s32 DevCorRelEvMgrFt80s1 DevGiftProDbaFt80s2 DevGrantWritPt48s1 DevMktgCoordFt66s1 DevPreCirPGMgrFt80s1 DevVpAdvanceFt80s1
Any ideas on how I can get the sort order I'm looking for?
Hello, I have been using FMP for only two weeks, so please excuse my ignorance.
I am using a trial version of FileMaker Pro 17 Advanced (184.108.40.206) on Windows 7
After accidentally deleting my primary layout, I successfully copied it from a backup. However, since then I have not been able to switch to table view. Both the button and the menu command are greyed out. Is there another step that I must do to be able to use the other views? I guess I could try to make a layout that mimics the table view, but I'd prefer to fix what I have broken.
Who Viewed the Topic