Dane

Oddly enough, putting the search term in quotes makes no difference... I guess Quick Find uses different rules than a regular find. As for why I'm using Quick Find instead of searching on a specific field, I've inherited a horrific data set where serial numbers might have been entered in any one of a half dozen different fields, depending upon the user doing the data entry. *sigh*

Yah, that I knew. But the issue here is my number fields don't have text, they only have numbers. It's the Quick Find criterion that has text in it. That's why I'm so puzzled.

Wow. Can't believe I've used FM for years and never bumped into this before. Ah, well, always something new to learn. Thanks!

Er, but an index of 301 should not match the entry in the Quick Find box, DBT3W01. Unless the search routine filters alpha characters out of the searched-for text before comparison, but that makes no sense. That kind of processing would give you matches between, say, ASDF3GHJK4QWERTY5 and 345, which is nonsensical. Will play around with a few other fields and entries, see what kind of matching I come up with. Thanks.

Thank you, good point. Started turning off Quick Find for various numeric fields, & found the one that seemed to be responsible for it. Not sure why it was matching that field, since it's a field that's never had any text. But DBT3W01 was matching 301. I can't recall ever bumping against this behavior before-- is this normal? I re-indexed the field, turned Quick Find back on for it, & still have the same problem. False positives are odd.

Tried it with the Serial No. field, no change. Any way to do the whole file at once? Or is it just each field one at a time? I'm not sure which field the spurious match is being generated from, since it (the match) doesn't actually exist...

Most fields have Quick Find enabled; by and large I haven't gotten around to turning it off for fields where it's not useful yet. Early days. Serial Number field is a text field, since they're frequently alpha-numeric. What really puzzles me is that a more specific search criterion would generate more results, not fewer.

Added them to the description; not include in the search itself.

I have a dirt-simple inventory DB, just started working on it, basically flat-file so far (i.e., no related tables in use yet), only 800 records, most fields still empty. Quick Find is not working properly for me. If I use the Quick Find field to search for a part of a serial number, e.g., "DBT", I get no results. If I search for a longer string, i.e., more specific, "DBT30" I get one result. If I search for "DBT301" I get two results. Neither record has this string anywhere in any field. Oddly enough, the two records returned are two records I modified earlier today, may be coincidence, not sure. Have tried this on my "main" layout, have also created an alternative, all-fields table-view data-dump layout, same results. Saw another thread discussion where pop-overs were to blame, but I have no pop-overs, on either layout. Suggestions? Thanks.

I'm pretty sure the answer is "No", but just in case I've somehow overlooked the obvious in my various searches, I was wondering if anyone knows a way to change FileMaker's Default Table View Properties.  Specifically, I pretty much ALWAYS want to "Include Header Part" and "Include Footer Part" when in Table view, but I have to go in and check the appropriate checkboxes every bloody time I create a new layout. I don't think it would be so annoying if it weren't for the fact that it's buried a couple of layers deep...  Thanks--

If you enter layout mode and go to Layout Setup, UNcheck "Show field frames when record is active", and only the field that is currently active (has the cursor in it) will be opaque; all the others will remain transparent.

For IWP Forms, I don't do any data validation in the field definition; I script it all, and have a field by the "Submit" button that gets populated with error messages after Submit is clicked (assuming there were errors, of course...). No data lost, a record can be saved as a "work in progress" or incomplete. The main catch is you can't let your users use the Submit button on the status area; you have to build your own Submit button with the validation script attached. So you either have to lock out the status area (and replicate all the functions thereon that your users need) or let them have access to the status area & trust they'll remember not to use that conveniently placed Submit button over there on the side... up to you how your salesforce would work best.

FWIW: Setting in OS X Server seems to have been at fault: In Server Admin, select Web service, click on the Sites tab, and under General options for the web site, the third line down (at least in server version 10.5.6) is IP Address:. Setting this field to the IP address of the box bollixed things up; setting it to "any" from the drop-down list allows FM PHP to run properly. No clue why....:confused:

I'll second this request for help-- I've created a dead-simple tiny db to test with, and still get this error. Also, monitoring memory usage, I see that memory is nowhere near capacity, so the error message is spurious. Error logs don't specify any particular area in the php file, alas (sometime poorly formed php will give a line number where an error occurred). I can hand code a simple php page (w/o accessing FMP), which will display properly, so it's not a problem with the php install. Did a clean install of OS X Server before installing FMS 10, so system settings are pretty standard. Single machine setup, FMP & PHP & Apache all on the same box, no external links. Suggestions?

First line of code I put into any loop is Exit Loop If [Get ( ActiveModifierKeys )= 28] which allows you to exit the loop by pressing Ctrl-Alt-Command. Saves a world of heartache if you accidentally create an infinite loop.

When printing the Relationships graph, have an option/checkbox that adds 1: a number next to each relationship connector in the diagram 2: a numbered list appended to the graphical printout detailing the relationships between the linked table occurrences. --Dane

Someone told me that this is a "known issue" with FMP. The issue is with drop-down lists and web interface; to keep from losing the plusses, they need to be at the end of the list. So the drop-down lists, which originally looked like: E+ E E- M+ M M- NA Now looks like: E M NA E+ E- M+ M- --and things work just fine (knock wood). Hope this saves someone else some grief. --Dane

I've got an odd problem, with a teacher report card layout. Works fine when accessed via FMP, but when they access the same layout via the Web interface, any grade with a plus at the end (M+, E+) gets the plus sign deleted when the record is saved. e.g., a teacher can enter a student's grades via the web interface as E M+ M- E+ S+ and when the record is committed, the values become E M M- E S -- the minus signs stay; just the plus signs disappear. And any grades previously entered via FMP which have plusses on them get "downgraded" to just the lettergrade w/o a plus. Each grade field is its own field, not a field with repetition The values are entered from a drop-down list. The fields are text fields, with no validation. No script is performed for data validation that I can tell (DB was designed by someone else, of course....). Knocking my head against the wall here-- any suggestions? --Dane

Hi, this seems like it should be simple, but I can't find it in any discussion thread here or book. I'm printing pages for a directory from FMP 8.5; these pages will make up the middle part of the directory (the first few pages being indices, notes, etc.) Is there any way to get the page numbering in the printed report to start at, say, 8, instead of 1? The only option for page numbering in footers I can find is just the "##" symbol, with no way to manipulate that. Thanks-- Dane

Beautiful! Thanks!

If you can copy and paste the "box" symbol, you could use the Substitute function, replace the "box" with a space or paragraph character. e.g., Substitute ("EmailBodyText";"box";" ")

This is almost what I need to do-- I need to be able to lock all but one field in a portal record. Specifically, on a requisition form, once the requisiton has been approved and signed off on (with a password, by the Principal), the only field on the record that should remain editable is a "Quantity recieved" field that is filled in when the requisition comes in. (To prevent items from being added to the requisition after it's been approved.) Locking the whole thing seems easy, using the above suggestions. Not quite sure how to do this, though... Suggestions? -Dane

Assuming you only have households of one or two voters, this would be a good situation for the classic use of powers-of-two coding for your category codes. E.g.: Democrat = 1 Republican = 2 Unaffiliated =4 Libertarian = 8 Monarchist =16 Anarchist = 32 First perform a check to see if both addressees have the same party affiliation; if so, then category code = whatever that party is. If they're different, add the two numbers together. The resulting number is unique for each possible pair combination; e.g., Republican + Democrat = 3; Democrat + Libertarian = 9, Anarchist + Republican = 34 (and what a marriage that must be...), etc. Changing addressee to "The Smiths" would require a check for more than one person of that last name at that address; if only one person, address goes to FIRSTNAME & " " & LASTNAME if more than one, address goes to "The " & LASTNAME & "s" (You might want to get anal retentive about grammar and check for last letter of the last name being an "s"....) Good luck dealing with households like mine, where my wife & I have different last names.... -Dane

Odd problem. I have a list of thirty or so teacher names. When filling out report cards, the teachers select their name and are automatically taken to their class lists. A few times over the past week-- say 4 or 5 times-- the value list has spontaneously changed. Visually it's the same, but when a teacher selects her name, she gets no matching students, even though the student lists show her name in the teacher field. Further investigation revealed that on the value list the name now has an invisible character padded onto the end of the name, so "Ms. Smith" has now become "Ms. Smith ", and a match doesn't occur. The character is either a tab or something wide, since the cursor when placed at the end of the line is further than a normal character's width from the end of the name (but it's only a single character). So, has anyone else encounted this? Any idea what could be adding characters to my value list? (It was all different teachers, btw, not the same one over & over). The value list isn't touched by any scripts; it's just a simple name list. As a work-around, I suppose I could generate a list, possibly using the Trim function to get rid of these characters, but I don't think I should have to.... Thanks-- Dane

If you check the FMPUG Starter Template at http://fmforums.com/forum/showtopic.php?tid/125385/ it has a script in it which does that. In summary: Adjust Window [Resize To Fit] Move/Resize Window, with settings of Distance From Top: Round(((Get(WindowDesktopHeight) - Get(WindowHeight)) / 2); 0) Distance From Left: Round(((Get(WindowDesktopWidth) - Get(WindowWidth)) / 2); 0) --Dane