This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori 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 OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 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: 44515
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?
It's not a secret anymore!