Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

vba code?

 
Sam Doder
Ranch Hand
Posts: 204
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Pie
Posts: 49411
62
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic