Jim:
Put a row in the table PRODUCT, Field model# '0'
If you are also showing a model name, make that ' Add New Model'
Then change your where clause to read
Where Model# LIKE '&%' or model# = '0' ORDER BY Model#
Then the 'Add new model ' or the model# '0' will be the first item
the pop-up.
The user selects it,
Then trap that in an exit eep from the field, using that to do whatever
you do to enter a new model. Then use property commands to load the
edit field with the new model.
email me with your address at
[email protected]
I will send you some code that I use.
Dick Fey
Jim Belisle wrote:
Dennis,
The WHERE clause in the automatic popup is this:
WHERE Model# LIKE '&%' ORDER BY Model#
If I immediately hit the escape key I get an error
"No values chosen from the list." But no error number is with it.
If I enter a few letters and hit enter, a list of possible matches come up.
If I then hit escape I get an error message with the error number.
That error message I can suppress but not the first one.
Should I try something different?
Jim
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath
Sent: Friday, October 16, 2009 2:42 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: getting info or enter new
That should be
SET ERROR MESSAGE nnnn OFF/ON
Dennis
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of John Docherty
Sent: Friday, October 16, 2009 2:38 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: getting info or enter new
Jim,
Can you have an EEP that includes
SET ERROR nnnn OFF
when you enter the field, and another that turns it on when you leave ?
Regards,
John Docherty
From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle
Sent: Saturday, 17 October 2009 8:25 a.m.
To: RBASE-L Mailing List
Subject: [RBASE-L] - getting info or enter new
While entering orders in the Model field, I give the option for the entry
person to lookup the model with a pop up menu.
They also have the option (by pressing a button next to the model field) of
entering a new model into the proper table so it is available to use "on the
fly".
This is working fine.
I have tried making the popup automatic. That works except if they realize
they need to add a model because what they are looking for is not there
(such as parts orders, etc.) when they escape they get an error because no
value is picked from the popup.
When using an automatic popup is there a way to suppress the error message
if they do not choose an item?
My purpose is to force them to look carefully first before entering new
models such as parts, but get rid of the error message if they do have to
enter a new model after searching carefully.
Jim
