Re: Programming Help Please

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Do you mean that you still see the "Please enter Competitor and Reason
fields" even when "RTC" appears to be empty? If so, perhaps it contains an
empty string rather than a Null value. Try changing the test for
IsNull([RTC]) to the following, which will catch both Null values and empty
strings. I'll show the original line of code commented out followed by the
new line of code, to make it clear which line of code needs to be replaced.
"vbNullString" is an intrinsic VBA constant that corresponds to an empty
string, a string with no characters, which can also be entered by typing two
double quotes with nothing between them ...

'If Not IsNull([RTC]) Then
If Not Len([RTC] & vbNullString) = 0 Then

The above is the most efficient way to check for the presence of either a
Null value or an empty string, but it may be potentially a little confusing.
The following is less efficient, but perhaps easier to follow, and the
difference in efficiency won't be noticeable unless the code is being called
many times within a loop ...

If (Not IsNull[RTC]) And ([RTC] <> vbNullString) Then

--
Brendan Reynolds

"Mark S via AccessMonster.com" <u13137@uwe> wrote in message
news:586e9cbde4d8b@xxxxxx
> Hey Brendan...
>
> It's folks like you that make it so us newbies can learn and get better. I
> appreciate your help. Here is what I put in and I still get the Msgbox
> when I
> attempt to do the D condition. D is RTF for clarity. What am I doing
> wrong?
>
> Thanks again.
>
> Private Sub Form_BeforeUpdate(Cancel As Integer)
> If Not IsNull([RTC]) Then
> If IsNull([Competitor]) Or IsNull([Reason]) Then
> MsgBox "Please enter Competitor and Reason fields"
> Cancel = True
> End If
> Else
> 'A is Null
>
> If Not IsNull(RTF) Then
> If (Not IsNull(Competitor)) Or (Not IsNull(Reason)) Then
> 'see note below for alternative
> B = Null
> C = Null
> Cancel = True
> End If
> End If
> End If
>
> End Sub
>
> Brendan Reynolds wrote:
>>If Not IsNull (A) Then
>> If IsNull (B) Or IsNull (C) Then
>> Msgbox "Please fill in B and C"
>> Cancel = True
>> End If
>>Else
>> 'A is Null
>> If Not IsNull(D) Then
>> If (Not IsNull(B)) Or (Not IsNull(C)) Then
>> 'see note below for alternative
>> MsgBox "Please *don't* fill in B and C"
>> Cancel = True
>> End If
>> End If
>>End If
>>
>>Note: If appropriate, rather than prompting the user to *not* fill in the
>>values, you could simply set them to Null ...
>>
>> If Not IsNull(D) Then
>> B = Null
>> C = Null
>> End If
>>
>>> First, due to conditions beyond my control I can not do this at the
>>> table
>>> level. I am not a VBA programmer (yet). I need help in programming to
>>[quoted text clipped - 15 lines]
>>>
>>> Any help is appreciate. Thank you
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200512/1


.

Relevant Pages

  • Re: Programming Help Please
    ... That worked but I had to clear the RTC field. ... Brendan Reynolds wrote: ... >empty string rather than a Null value. ... >Null value or an empty string, but it may be potentially a little confusing. ...
    (microsoft.public.access.formscoding)
  • Re: Attachments to MAPI Message
    ... :> Do this before assigning the attachments to the message. ... :> String, _ ... :> 'is provided for sign-on. ... The default is an empty string. ...
    (microsoft.public.vb.controls.internet)
  • Re: toward null-safe cookie cutter Comparators
    ... The empty string signifies that a field was submitted but not filled with any value. ... Unfortunately when processing such forms the null value, an empty string, and an all whitespace string, usually need to be treated the same way. ... doing something dangerous at compile time. ... You have *no* trace whatsoever of which call of handleThing caused the problem. ...
    (comp.lang.java.programmer)
  • Re: What does this do ? !/somestring/
    ... transliteration)] it is interpreted as a search pattern at run time." ... contains a variable that is set to the empty string. ... because the m/Wor/ match was the last successful pattern match. ...
    (comp.lang.perl.misc)
  • Re: comments of less.rb appreciated
    ... There are no global variables in less.rb. ... ARGV is the command line argument Array. ... Otherwise use an empty string. ...
    (comp.lang.ruby)