File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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 Elasticsearch in Action this week in the Big Data 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: 41084
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!
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: vba code?