VB 6.0 Don't Add a New REcord

[Joe-Paul]

Hi:

I need to try this a different way.

I have a datagrid in VB 6.0 and the user can add new records. I want to
validate the record before it is saved and, if a particular cell is not
completed, I don't want the program to save the record when the user moves
off of it.

If I put code in the Before_Update event checking for the required data and
the data isn't there, I can do "Cancel = true"...then I get a message that
says "Action is Cancelled"... It doesn't allow me to put in my own message.
I can use vbdataerrcontinue, and the error message is not shown, but the
record is saved.

How do I keep the record from saving with my own message and not a "program"
error message?

Thanks for any assistance.

JP

[Steve Gerrard]

"Joe-Paul" <Ha*********@comcast.net> wrote in message
news:1c********************@comcast.com...

If I put code in the Before_Update event checking for the required data and
the data isn't there, I can do "Cancel = true"...then I get a message that
says "Action is Cancelled"... It doesn't allow me to put in my own message. I
can use vbdataerrcontinue, and the error message is not shown, but the record
is saved.

I think you need to trap the "Action is Cancelled" message in the Error event of
the datagrid, set the Error event's Response parameter to 0 (vbDataErrContinue),
and do your message there.

[Joe-Paul]

Steve...thanks

I've used the vbDataErrContinue and the message is suppressed. But the
record is still saved. I don't want it to save that record.

JP

"Steve Gerrard" <my********@comcast.net> wrote in message
news:7u********************@comcast.com...

"Joe-Paul" <Ha*********@comcast.net> wrote in message
news:1c********************@comcast.com...

If I put code in the Before_Update event checking for the required data
and the data isn't there, I can do "Cancel = true"...then I get a message
that says "Action is Cancelled"... It doesn't allow me to put in my own
message. I can use vbdataerrcontinue, and the error message is not shown,
but the record is saved.

I think you need to trap the "Action is Cancelled" message in the Error
event of the datagrid, set the Error event's Response parameter to 0
(vbDataErrContinue), and do your message there.

[Steve Gerrard]

"Joe-Paul" <Ha*********@comcast.net> wrote in message
news:uv********************@comcast.com...

"Steve Gerrard" <my********@comcast.net> wrote in message
news:7u********************@comcast.com...

"Joe-Paul" <Ha*********@comcast.net> wrote in message
news:1c********************@comcast.com...

If I put code in the Before_Update event checking for the required data and
the data isn't there, I can do "Cancel = true"...then I get a message that
says "Action is Cancelled"... It doesn't allow me to put in my own message.
I can use vbdataerrcontinue, and the error message is not shown,
but the record is saved.

I think you need to trap the "Action is Cancelled" message in the Error event
of the datagrid, set the Error event's Response parameter to 0
(vbDataErrContinue), and do your message there.

I've used the vbDataErrContinue and the message is suppressed. But the record
is still saved. I don't want it to save that record.

JP

Don't use vbDataErrContinue in the BeforeUpdate event. Setting Cancel =
vbDataErrContinue is the same as Cancel = False, hence the record is saved.

Set Cancel = True. Then in the Error event, set Response = vbDataErrContinue.

[Joe-Paul]

Thanks Steve... It just takes a sledge hammer at times to get through my
thick skull...

It's now late...and I'll try it tomorrow.

Thanks Again,
JP
"Steve Gerrard" <my********@comcast.net> wrote in message
news:Nr********************@comcast.com...

"Joe-Paul" <Ha*********@comcast.net> wrote in message
news:uv********************@comcast.com...

"Steve Gerrard" <my********@comcast.net> wrote in message
news:7u********************@comcast.com...

"Joe-Paul" <Ha*********@comcast.net> wrote in message
news:1c********************@comcast.com...

If I put code in the Before_Update event checking for the required data
and the data isn't there, I can do "Cancel = true"...then I get a
message that says "Action is Cancelled"... It doesn't allow me to put
in my own message. I can use vbdataerrcontinue, and the error message
is not shown,
but the record is saved.

I think you need to trap the "Action is Cancelled" message in the Error
event of the datagrid, set the Error event's Response parameter to 0
(vbDataErrContinue), and do your message there.

I've used the vbDataErrContinue and the message is suppressed. But the
record is still saved. I don't want it to save that record.

JP

Don't use vbDataErrContinue in the BeforeUpdate event. Setting Cancel =
vbDataErrContinue is the same as Cancel = False, hence the record is
saved.

Set Cancel = True. Then in the Error event, set Response =
vbDataErrContinue.