File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Languages » Other Languages
Bookmark "vba code?" Watch "vba code?" New topic
Author

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
Sheriff

Joined: Oct 13, 2005
Posts: 36453
    
  15
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: http://aspose.com/file-tools
 
subject: vba code?
 
Similar Threads
Why Conditional expression null accepted to primitive datatype.
null value to an integer attribute
please tell me how this code works.
how can assign hidden variable value to JSTL variable,with out submit
Javascript Parameter