What's wrong with this VBA ?

#1 (**permalink**) 28-Jul-2006, 08:13 AM

If Forms![ABC].[totalyear] Is Not Null And Forms![ABC].[paidyear] Is Not
Null Then
If Forms![ABC].[paidyear] < 3 And Forms![ABC].[regionplace] = "USA" Then
aiprs6 = "Alert, paidyear too small!!!"
End If
Else
End If

MsgBox aiprs6, , "AI"
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10474-whats-wrong-with-this-vba.html

-----------------------------
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10474

The problem ACCESS msg is "needing object" ( I transfer from Chinese to
English, thus not sure the exact English is )

*

#2 (**permalink**) 28-Jul-2006, 08:13 AM

Try
if not IsNull(Forms![ABC].[totalyear]) ...

HTH

Pieter

"Martin (Martin Lee)" wrote in message
news:ewQgzDwgGHA.4776@TK2MSFTNGP05.phx.gbl...
>
> If Forms![ABC].[totalyear] Is Not Null And Forms![ABC].[paidyear] Is Not
> Null Then
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10474
> If Forms![ABC].[paidyear] < 3 And Forms![ABC].[regionplace] = "USA"
> Then
> aiprs6 = "Alert, paidyear too small!!!"
> End If
> Else
> End If
>
> MsgBox aiprs6, , "AI"
>
>
> -----------------------------
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10474
>
> The problem ACCESS msg is "needing object" ( I transfer from Chinese to
> English, thus not sure the exact English is )
>

#3 (**permalink**) 28-Jul-2006, 08:13 AM

You are great! It works!

However, I wonder why my sentence is not workable, my sentence really seems
like a workable and "reasonable" VBA

Thanks again!

Martin Lee

"Pieter Wijnen"

Ð´ÈëÏûÏ¢ÐÂÎÅ:O85UKgwgGHA.1324@TK2MSFTNGP04.phx.gbl ...
> Try
> if not IsNull(Forms![ABC].[totalyear]) ...
>
> HTH
>
> Pieter
>
> "Martin (Martin Lee)" wrote in message
> news:ewQgzDwgGHA.4776@TK2MSFTNGP05.phx.gbl...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10474
>>
>> If Forms![ABC].[totalyear] Is Not Null And Forms![ABC].[paidyear] Is Not
>> Null Then
>> If Forms![ABC].[paidyear] < 3 And Forms![ABC].[regionplace] = "USA"
>> Then
>> aiprs6 = "Alert, paidyear too small!!!"
>> End If
>> Else
>> End If
>>
>> MsgBox aiprs6, , "AI"
>>
>>
>> -----------------------------
>>
>> The problem ACCESS msg is "needing object" ( I transfer from Chinese to
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10474
>> English, thus not sure the exact English is )
>>
>
>

#4 (**permalink**) 28-Jul-2006, 08:13 AM

"Is Not Null" is SQL, not VBA.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Martin (Martin Lee)" wrote in message
news:uLhGfpygGHA.1276@TK2MSFTNGP03.phx.gbl...
> You are great! It works!
>
> However, I wonder why my sentence is not workable, my sentence really
seems
> like a workable and "reasonable" VBA

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10474
>
> Thanks again!
>
> Martin Lee
>
>
> "Pieter Wijnen"
>
..with.norway>
> Ð´ÈëÏûÏ¢ÐÂÎÅ:O85UKgwgGHA.1324@TK2MSFTNGP04.phx.gbl ...
> > Try
> > if not IsNull(Forms![ABC].[totalyear]) ...
> >
> > HTH
> >
> > Pieter
> >
> > "Martin (Martin Lee)" wrote in message
> > news:ewQgzDwgGHA.4776@TK2MSFTNGP05.phx.gbl...
> >>
> >> If Forms![ABC].[totalyear] Is Not Null And Forms![ABC].[paidyear] Is
Not
> >> Null Then
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10474
> >> If Forms![ABC].[paidyear] < 3 And Forms![ABC].[regionplace] = "USA"
> >> Then
> >> aiprs6 = "Alert, paidyear too small!!!"
> >> End If
> >> Else
> >> End If
> >>
> >> MsgBox aiprs6, , "AI"
> >>
> >>
> >> -----------------------------
> >>
> >> The problem ACCESS msg is "needing object" ( I transfer from Chinese to
> >> English, thus not sure the exact English is )
> >>
> >
> >
>
>

#5 (**permalink**) 28-Jul-2006, 08:13 AM

Hi Mr. Steele !

I remembered not long before, I have made the same mistake. It looks quite
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10474
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10474
the same to me.

Martin Lee

"Douglas J Steele" Ð´ÈëÏûÏ¢ÐÂÎÅ:e0FDaxygGHA.1272@TK2MSFTNGP03.phx.gbl ...
> "Is Not Null" is SQL, not VBA.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "Martin (Martin Lee)" wrote in message
> news:uLhGfpygGHA.1276@TK2MSFTNGP03.phx.gbl...
>> You are great! It works!
>>
>> However, I wonder why my sentence is not workable, my sentence really
> seems
>> like a workable and "reasonable" VBA

>>
>> Thanks again!
>>
>> Martin Lee
>>
>>
>> "Pieter Wijnen"
>>
> > .with.norway>
>> Ð´ÈëÏûÏ¢ÐÂÎÅ:O85UKgwgGHA.1324@TK2MSFTNGP04.phx.gbl ...
>> > Try
>> > if not IsNull(Forms![ABC].[totalyear]) ...
>> >
>> > HTH
>> >
>> > Pieter
>> >
>> > "Martin (Martin Lee)" wrote in message
>> > news:ewQgzDwgGHA.4776@TK2MSFTNGP05.phx.gbl...
>> >>
>> >> If Forms![ABC].[totalyear] Is Not Null And Forms![ABC].[paidyear] Is
> Not
>> >> Null Then
>> >> If Forms![ABC].[paidyear] < 3 And Forms![ABC].[regionplace] = "USA"
>> >> Then
>> >> aiprs6 = "Alert, paidyear too small!!!"
>> >> End If
>> >> Else
>> >> End If
>> >>
>> >> MsgBox aiprs6, , "AI"
>> >>
>> >>
>> >> -----------------------------
>> >>
>> >> The problem ACCESS msg is "needing object" ( I transfer from Chinese
>> >> to
>> >> English, thus not sure the exact English is )
>> >>
>> >
>> >
>>
>>
>
>