Help: Find mode is driving me nuts. 
Author Message
 Help: Find mode is driving me nuts.
All I need to do is search my data and display the found set on a page
where the data can't be modified.  I'm helpless.  Every script I've
made is no good.. there always seems to be a way to fall out of the
script and end up having some records info showing up in my find
fields.  If someone has a failsafe script that will do this would you
be as kind as to share the secret with me?


Wed, 27 Mar 2002 03:00:00 GMT
 Help: Find mode is driving me nuts.

Quote:

> All I need to do is search my data and display the found set on a page
> where the data can't be modified.  I'm helpless.  Every script I've
> made is no good.. there always seems to be a way to fall out of the
> script and end up having some records info showing up in my find
> fields.  If someone has a failsafe script that will do this would you
> be as kind as to share the secret with me?

First off, make a results layout with all the fields formatted not to
allow entry. That satifies your first criteria.

Next, create global fields of the same data types as the fields you want
your users to find in. Put them on your Find layout. Using globals
prevents your users from seeing data in find fields if they end up back
in browse mode.

Next, in the script to find the records, use 2 steps...User Abort (Off)
and Set Error Capture (On) to prevent the users falling out of the find
in awkward places. You'll need about 4 scripts, and they'll look
something like this:

The go to Find layout script:

Perform script (Clear Global fields) <--clears the globals from previous
finds
Go to Layout (Find Layout) <--with global fields that allow entry

Find Script: (put this on a button on the find layout, along with a
button with the clear fields script)
Set User Abort (Off)
Enter find Mode
Perform Script (Set Find Fields from Globals) <--this sets the data from
the globals into the regular fields

Set Error Capture(On)
Perform find
If (Status(CurrentFoundCount) = 0)  <--traps for no records found)
  Show Message (You haven't found any records)  <-give only the OK
choice)
  Go to layout (find Layout)
  Enter Browse mode <--shows them their unsuccessful find & lets them
modify it
  Find All
Else
  go to Layout (Viewing layout)
  Enter Browse Mode
End If

This way users cannot cancel the find in the middle. Even if they find
nothing, they will end up back in the Find layout, where they can modify
their find & try again.  You can get fancy with letting them choose to
loop back into the find mode without going to browse mode by giving them
another choice in the Show message box, but I prefer the simplicity of
this method.  Global fields are always available in find mode, so you
can manipulate the data before setting it into the regular fields.

I also usually let users Preview their search results, pausing the
script and then giving them the choice of printing or returning to the
original layout, but the scripts above should get you started.

--

Allen & Allen Semiotics                          Web & Graphic Design
Long Beach CA USA               Filemaker Pro Consulting - Member CSA
562.938.7890  fax 562.938.7891            Custom Solutions & Training



Wed, 27 Mar 2002 03:00:00 GMT
 Help: Find mode is driving me nuts.
Thank you so much Lynn.  I'm going to get busy with that right now.



Quote:
>> All I need to do is search my data and display the found set on a page
>> where the data can't be modified.  I'm helpless.  Every script I've
>> made is no good.. there always seems to be a way to fall out of the
>> script and end up having some records info showing up in my find
...snip
>another choice in the Show message box, but I prefer the simplicity of
>this method.  Global fields are always available in find mode, so you
>can manipulate the data before setting it into the regular fields.



Thu, 28 Mar 2002 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. msdn docs drive me nuts, help find CDaoTableDef connect string format description

2. HTTP 404 - File not found Driving me NUTS!!!!

3. HELP: isql is driving me nuts!

4. Please Help, this is driving me nuts !!

5. This query is driving me nuts - please help !!

6. help vb & access2k is driving me nuts

7. HELP - ADO data Environment driving me nuts!

8. I am having a problem with a hard disk drive or floppy disk drive

9. SQL 7.0 Backup/Restore , Maybe I am nuts

10. Am I nuts?

11. Am I nuts or......

12. I am going *#&^! NUT about JDBC


 
Powered by phpBB® Forum Software