Create a warning.

[radink]

Hey all,

Is there a way to pop up a warning when someone goes to change a field?
I would only like this to occur when the field is NOT empty.

Thanks!!

[ManningFan]

On the BeforeUpdate event, throw in something like;

if not isnull(me.fieldname) then
msgbox "Warning!"
end if

You might need to change the first line to "if me.fieldname is not null
then", I'm not 100% sure about that.
radink wrote:

Hey all,

Is there a way to pop up a warning when someone goes to change a field?
I would only like this to occur when the field is NOT empty.

Thanks!!

[radink]

This worked! The only other thing I would like is to have that message
box have an ok and cancel button. The ok letting the field change, and
the cancel leaving it alone.

Thanks!!

ManningFan wrote:

On the BeforeUpdate event, throw in something like;

if not isnull(me.fieldname) then
msgbox "Warning!"
end if

You might need to change the first line to "if me.fieldname is not null
then", I'm not 100% sure about that.
radink wrote:

Hey all,

Is there a way to pop up a warning when someone goes to change a field?
I would only like this to occur when the field is NOT empty.

Thanks!!

[ManningFan]

As a rule I only answer 1 question and then you're on your own,
otherwise you won't learn nothin'.

Google the Internet, it can be very helpful. (hint: search "msgbox
vbok" or "msgbox vbyesno")

radink wrote:

This worked! The only other thing I would like is to have that message
box have an ok and cancel button. The ok letting the field change, and
the cancel leaving it alone.

Thanks!!

ManningFan wrote:

On the BeforeUpdate event, throw in something like;

if not isnull(me.fieldname) then
msgbox "Warning!"
end if

You might need to change the first line to "if me.fieldname is not null
then", I'm not 100% sure about that.
radink wrote:

Hey all,
>
Is there a way to pop up a warning when someone goes to change a field?
I would only like this to occur when the field is NOT empty.
>
Thanks!!

[radink]

OK thanks.

However it is not working. It still shows the warning even if the field
is empty to start with.
I have been searching also. Everything I've found seems to have the
same problem, with the warning showing up regardless of the field being
empty or filled. It is a combobox, so I don't know if that matters.

ManningFan wrote:

As a rule I only answer 1 question and then you're on your own,
otherwise you won't learn nothin'.

Google the Internet, it can be very helpful. (hint: search "msgbox
vbok" or "msgbox vbyesno")

radink wrote:

This worked! The only other thing I would like is to have that message
box have an ok and cancel button. The ok letting the field change, and
the cancel leaving it alone.

Thanks!!

ManningFan wrote:

On the BeforeUpdate event, throw in something like;
>
if not isnull(me.fieldname) then
msgbox "Warning!"
end if
>
You might need to change the first line to "if me.fieldname is not null
then", I'm not 100% sure about that.
>
>
radink wrote:
Hey all,

Is there a way to pop up a warning when someone goes to change a field?
I would only like this to occur when the field is NOT empty.

Thanks!!

[Jana]

Try changing:
if not isnull(me.fieldname) then
to:
If Nz(me.fieldname,"") <"" Then

HTH,
Jana

radink wrote:

OK thanks.

However it is not working. It still shows the warning even if the field
is empty to start with.
I have been searching also. Everything I've found seems to have the
same problem, with the warning showing up regardless of the field being
empty or filled. It is a combobox, so I don't know if that matters.

ManningFan wrote:

As a rule I only answer 1 question and then you're on your own,
otherwise you won't learn nothin'.

Google the Internet, it can be very helpful. (hint: search "msgbox
vbok" or "msgbox vbyesno")

radink wrote:

This worked! The only other thing I would like is to have that message
box have an ok and cancel button. The ok letting the field change, and
the cancel leaving it alone.
>
Thanks!!
>
ManningFan wrote:
On the BeforeUpdate event, throw in something like;

if not isnull(me.fieldname) then
msgbox "Warning!"
end if

You might need to change the first line to "if me.fieldname is not null
then", I'm not 100% sure about that.


radink wrote:
Hey all,
>
Is there a way to pop up a warning when someone goes to change a field?
I would only like this to occur when the field is NOT empty.
>
Thanks!!

[radink]

Jana,

Thanks for replying.

Unfortunately that did not help. It still shows up either way.

Jana wrote:

Try changing:
if not isnull(me.fieldname) then
to:
If Nz(me.fieldname,"") <"" Then

HTH,
Jana

radink wrote:

OK thanks.

However it is not working. It still shows the warning even if the field
is empty to start with.
I have been searching also. Everything I've found seems to have the
same problem, with the warning showing up regardless of the field being
empty or filled. It is a combobox, so I don't know if that matters.

ManningFan wrote:

As a rule I only answer 1 question and then you're on your own,
otherwise you won't learn nothin'.
>
Google the Internet, it can be very helpful. (hint: search "msgbox
vbok" or "msgbox vbyesno")
>
radink wrote:
This worked! The only other thing I would like is to have that message
box have an ok and cancel button. The ok letting the field change, and
the cancel leaving it alone.

Thanks!!

ManningFan wrote:
On the BeforeUpdate event, throw in something like;
>
if not isnull(me.fieldname) then
msgbox "Warning!"
end if
>
You might need to change the first line to "if me.fieldname is not null
then", I'm not 100% sure about that.
>
>
radink wrote:
Hey all,

Is there a way to pop up a warning when someone goes to change a field?
I would only like this to occur when the field is NOT empty.

Thanks!!

[Jana]

Radink:

I see what you mean. Try this instead:

If Nz(Me.FieldName.OldValue, "") <"" Then
MsgBox "warning"
End If

HTH,
Jana

radink wrote:

Jana,

Thanks for replying.

Unfortunately that did not help. It still shows up either way.

Jana wrote:

Try changing:
if not isnull(me.fieldname) then
to:
If Nz(me.fieldname,"") <"" Then

HTH,
Jana

radink wrote:

OK thanks.
>
However it is not working. It still shows the warning even if the field
is empty to start with.
I have been searching also. Everything I've found seems to have the
same problem, with the warning showing up regardless of the field being
empty or filled. It is a combobox, so I don't know if that matters.
>
ManningFan wrote:
As a rule I only answer 1 question and then you're on your own,
otherwise you won't learn nothin'.

Google the Internet, it can be very helpful. (hint: search "msgbox
vbok" or "msgbox vbyesno")

radink wrote:
This worked! The only other thing I would like is to have that message
box have an ok and cancel button. The ok letting the field change, and
the cancel leaving it alone.
>
Thanks!!
>
ManningFan wrote:
On the BeforeUpdate event, throw in something like;

if not isnull(me.fieldname) then
msgbox "Warning!"
end if

You might need to change the first line to "if me.fieldname is not null
then", I'm not 100% sure about that.


radink wrote:
Hey all,
>
Is there a way to pop up a warning when someone goes to change a field?
I would only like this to occur when the field is NOT empty.
>
Thanks!!

[radink]

If Len(Me.Employee.OldValue & "") 0 Then

worked for me.

Thanks!
Jana wrote:

Radink:

I see what you mean. Try this instead:

If Nz(Me.FieldName.OldValue, "") <"" Then
MsgBox "warning"
End If

HTH,
Jana

radink wrote:

Jana,

Thanks for replying.

Unfortunately that did not help. It still shows up either way.

Jana wrote:

Try changing:
if not isnull(me.fieldname) then
to:
If Nz(me.fieldname,"") <"" Then
>
HTH,
Jana
>
radink wrote:
OK thanks.

However it is not working. It still shows the warning even if the field
is empty to start with.
I have been searching also. Everything I've found seems to have the
same problem, with the warning showing up regardless of the field being
empty or filled. It is a combobox, so I don't know if that matters.

ManningFan wrote:
As a rule I only answer 1 question and then you're on your own,
otherwise you won't learn nothin'.
>
Google the Internet, it can be very helpful. (hint: search "msgbox
vbok" or "msgbox vbyesno")
>
radink wrote:
This worked! The only other thing I would like is to have that message
box have an ok and cancel button. The ok letting the field change, and
the cancel leaving it alone.

Thanks!!

ManningFan wrote:
On the BeforeUpdate event, throw in something like;
>
if not isnull(me.fieldname) then
msgbox "Warning!"
end if
>
You might need to change the first line to "if me.fieldname is not null
then", I'm not 100% sure about that.
>
>
radink wrote:
Hey all,

Is there a way to pop up a warning when someone goes to change a field?
I would only like this to occur when the field is NOT empty.

Thanks!!

[Jana]

Glad I could help :)

Jana
radink wrote:

If Len(Me.Employee.OldValue & "") 0 Then

worked for me.

Thanks!
Jana wrote:

Radink:

I see what you mean. Try this instead:

If Nz(Me.FieldName.OldValue, "") <"" Then
MsgBox "warning"
End If

HTH,
Jana

radink wrote:

Jana,
>
Thanks for replying.
>
Unfortunately that did not help. It still shows up either way.
>
Jana wrote:
Try changing:
if not isnull(me.fieldname) then
to:
If Nz(me.fieldname,"") <"" Then

HTH,
Jana

radink wrote:
OK thanks.
>
However it is not working. It still shows the warning even if the field
is empty to start with.
I have been searching also. Everything I've found seems to have the
same problem, with the warning showing up regardless of the field being
empty or filled. It is a combobox, so I don't know if that matters.
>
ManningFan wrote:
As a rule I only answer 1 question and then you're on your own,
otherwise you won't learn nothin'.

Google the Internet, it can be very helpful. (hint: search "msgbox
vbok" or "msgbox vbyesno")

radink wrote:
This worked! The only other thing I would like is to have that message
box have an ok and cancel button. The ok letting the field change, and
the cancel leaving it alone.
>
Thanks!!
>
ManningFan wrote:
On the BeforeUpdate event, throw in something like;

if not isnull(me.fieldname) then
msgbox "Warning!"
end if

You might need to change the first line to "if me.fieldname is not null
then", I'm not 100% sure about that.


radink wrote:
Hey all,
>
Is there a way to pop up a warning when someone goes to change a field?
I would only like this to occur when the field is NOT empty.
>
Thanks!!