This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Other Languages and the fly likes vba code? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Languages » Other Languages
Bookmark "vba code?" Watch "vba code?" New topic

vba code?

Sam Doder
Ranch Hand

Joined: Feb 06, 2008
Posts: 204
I am having a problem with the below vba macro code

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.
Campbell Ritchie

Joined: Oct 13, 2005
Posts: 38020
Is the bit about = True required in VBA? InJavaâ„¢ it would usually be regarded as bad style to write == true. Try missing out the = True.

Otherwise: very definite on't know!
I agree. Here's the link:
subject: vba code?
Similar Threads
how can assign hidden variable value to JSTL variable,with out submit
Javascript Parameter
please tell me how this code works.
Why Conditional expression null accepted to primitive datatype.
null value to an integer attribute