Less/greater than in Find mode

[polarpro]

Hey there,

I wonder if there is a way to make a Search Layout a little easier for my users.

In my database you can search for different newspapers. Each newspaper record has a start year. When in Find Mode, there is the start_year field, and the user can key in let’s say <=1990 to find all the records that started before or in 1990.

Well, every now and then it happens that the users mix up the < and > signs. So, I’d like to offer them a field where they simply enter four digits for the year and the explanation text next to it says something like „Searches for all publications that start with the entered year or earlier.“

Your help is highly appreciated!

Thank you,

polarpro

[LaRetta]

You can have a button with :less: on it. Tooltip could explain what it means. Script attached would run your find and, when attached to your button, have script parameter with ":less:" .

Then script would be:

Set Error Capture [ On ]

Enter Find Mode [ pause ]

Modify Last Find

Set Field [ theDate ; Get ( ScriptParameter ) & theDate ]

Perform Find

If [ not Get ( FoundCount ) ]

... do whatever if no records

Else

... do whatever if records

End If

This script has not been tested. You can then have buttons with ==, :great: etc.

[comment]

Try something like this?

FindBeforeAfter.fp7.zip

[LaRetta]

Also eliminates problem of User mixing up browse and find mode or entering something incorrectly during the paused find. Much nicer, Michael, no surprise there! :laugh2:

[polarpro]

Hi LaRetta, hi Michael:

Thanks a lot for your fast help! LaRetta's button will find its way on a layout regarding a similar problem, and the FindBeforeAfter.fp7 is really an elegant solution for the described problem. Great!

Regards!

Mike