Not equal to??

[superrob5]

Is there a way to check in macro where something is not equal to a text value.


like
Status is not equal to complete

 

[FoFa]

You can do limited checking in a macro. Using Conditional section of the macro, it basically says if this condition is true, execute this macro instruction, else bypass this instruction. But it is limited to either executing or NOT executing instructions.

 

[Uncle Gizmo]

I never really got involved with macros, but went straight into VBA code.

It should be relatively simple to accomplish in VBA.

 

[superrob5]

thanks, but does anyone know how to do it with macros?

 

[superrob5]

(Not IsNull([COMPLETION DATE])) And ([STATUS]<>"CANCELLED","COMPLETE")


This is what I have and its not working.???

 

[Mile-O]

This what you want?

((Not IsNull([COMPLETION DATE])) And (([STATUS]<>"CANCELLED") OR ([Status]<>"COMPLETE")))


That database of yours must be choking with macros by now...

 

[superrob5]

I have not had any problems with macros in my database. i know most people don't like them but they havent failed til now.


The statement is now
((Not IsNull([COMPLETION DATE])) And (([STATUS]<>"CANCELLED") And ([Status]<>"COMPLETE")))


the thing that was change was one of the or statements. Now it works. I can't believe that that was the reason. eh programming.


Rob