File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
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!
rocket mass heater
subject: vba code?
please tell me how this code works.
null value to an integer attribute
Why Conditional expression null accepted to primitive datatype.
how can assign hidden variable value to JSTL variable,with out submit
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013