A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
video training course this week in the
Joined: Feb 06, 2008
Dec 13, 2010 13:43:27
I am having a problem with the below vba macro code
If IsNull(rs.Fields("ARC_MODEL").value) = True Then mstrModel = rs.Fields("Engine_Model").value Else mstrModel = rs.Fields("ARC_MODEL").value End If
What I am trying to do is assign the varible mstrModel with the value of arc_model if it is not null in the database and when it is assign engine_model to it instead.
It seems to be always getting assigned Engine_Model. Does anybody see something wrong with the above vb code.
I have modified the database with non null values for some of the arc_model columns in the resultset.
Thanks for any help.
Joined: Oct 13, 2005
Dec 14, 2010 04:03:50
Is the bit about
required in VBA? InJava™ it would usually be regarded as bad style to write
. Try missing out the = True.
Otherwise: very definite on't know!
I agree. Here's the link:
subject: vba code?
please tell me how this code works.
how can assign hidden variable value to JSTL variable,with out submit
null value to an integer attribute
Why Conditional expression null accepted to primitive datatype.
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015