use VBA function in WHERE clause

[jwstockwell]

Can you use a VBA function in a WHERE clause - either in query designer and run it immed or using ado/dao in immed window ?

I want to :

UPDATE mytable SET field1 = "JANE" WHERE iseven(mytable.idnumber)

TIA

 

[LittleSmudge]

Why don't you try it and then report back on your findings


Hint :-
I'm expecting a positive report.


G LS

 

[jwstockwell]

I get an undefined function error when I try it in the query designer - should i try immed window?

 

[cmmrfrds]

Make it a Public function in the standards module and Access should be able to find it any place in the application.

 

[jwstockwell]

Thanks - Finally got it when I switched to the SQL view and watched what happened in design view when I coded the query - I was trying to put 'iseven(idnumber) = TRUE' in the criteria for field1 - hahaha - the where clause was pretty funky