Posts for 08/2009

09 August 2009 - 15:38

Using wildcards in IIf() statements in Access objects

If you want to use criteria against one or more fields, depending on different scenarios, be it in queries or forms, the most logical step is of course to think in terms of using the IIf() function in Access.

This might be a solution, but it's not always necessary or the best solution. One thing and pitfall is definitely NOT to use any operators like 'Like' or 'Is not null' inside the arguments of your function.


E.g. these are some examples which are NOT going to work if used as Query criteria:

IIf([Forms]![Simple Selector]![OptGrpMemType]=1;"MRD";
IIf([Forms]![Simple Selector]![OptGrpMemType]=2;"NRD";Like "?RD" ))

The last argument has the Like operator

IIf([strPassedFunder] Is Null;Is Not Null;[strPassedFunder])

Is Not Null as a standalone argument is not going to work

IIf (checkbox=true;listbox value; "Like *")

Again the Like operator, moreover in between quotes

IIf([Forms]![frmLookup]![TypeSelect]=1;[Security TypeID]; 

'<>3' is the problem here

[Read more on Using wildcards in IIf() statements in Access objects...]
(0) Comments ·
06 August 2009 - 16:25


Through a friend who sent me a couple of CDs from Abraham-Hicks on the Law of Attraction, I got to listen to one of the better speakers and teachers on Consciousness I've heard already.
To the point, practical spirituality brought in a freeing, humorous and inviting way.
Actually Esther Hicks, who gets her "inspirations" from "Abraham", also appeared on the first version of the famous The Secret project, so you might, as I did, remember her from there.

How exactly 'the machinery' behind this phenomenon of "mediation", "inspiration" or "channeling" (or whatever you want to call it) works, is another pair of scissors - but the message definitely stands.
The teachings are a good example of how cultural translated, clear, understandable, non-dogmatic explanations can truly be enlightening and inspiring towards the wonderful path of self-discovery and self-management.

I intend to consciously create my own reality

Yes, of course they have a site , which is commercial and thoroughly marketeered, but you can find some broadening views and answers to questions people have through some free video clips made during the multifold of conferences they have and are doing. These alone already are quite a dose perhaps :-)

So offer yourself a break and browse to some of these highlights and insights, which are build up around the "universal laws" (and especially the "law of attraction") which got summarized as follows on their site:

  1. You Are a Physical Extension of That Which is Non-physical.
  2. You Are Here in This Body Because You Chose to Be Here.
  3. The Basis of Your Life is Freedom; the Purpose of Your Life is Joy.
  4. You Are a Creator; You Create With Your Every Thought.
  5. Anything That You Can Imagine is Yours to Be or Do or Have.
  6. As You Are Choosing Your Thoughts, Your Emotions Are Guiding You.
  7. The Universe Adores You for it Knows Your Broadest Intentions.
  8. Relax into Your Natural Well-Being. All is Well. (Really It Is!)
  9. You Are a Creator of Thoughtways on Your Unique Path of Joy.
  10. Actions to Be Taken and Possessions to Be Exchanged Are
  11. You May Appropriately Depart Your Body Without Illness or Pain.
  12. You Can Not Die; You Are Everlasting Life.

Cheers !

(0) Comments ·
03 August 2009 - 03:13

playing with 22, 7, 142857 and precision

In a reflection and research on Excels precision handling, I came across this magic number 142857. From the Wikipedia definition (

142857 is the six repeating digits of 1/7, 0.142857, and is the best-known cyclic number in base 10.
If you multiply the number by 2, 3, 4, 5, or 6, the answer will be a cyclic permutation of itself, and equivalent to 2/7, 3/7, 4/7 ,5/7 , or 6/7, respectively.

So in other words try this:
142857 * 2
142857 * 3
142857 * 4
142857 * 5
142857 * 6

But also this:

I hadn't realized that pi, or the famous 22/7 has this exact cyclic number too as decimals: 3,1428571428571428571428571428571...

22 and 7 being numbers which for all kind of reasons have always been predominant to me.
Makes you wonder ...
about the matrix of life e.g.

Oh, I almost forgot the point where it all started, the 'floating point', the maximum precision Excel can handle.

ps you'll find a 142857 calculator at Douglas Twitchell blog.

(0) Comments ·
01 August 2009 - 06:00

Dynamically sorting and filtering html tabular data on the client side

Now that javascript has re-incarnated into all kind of libraries and frameworks like Ajax and JQuery, It's amazing what can be done today on the client (browser) side when it comes to dynamic web pages.

I've been looking into a couple of solutions for a client who needs to provide web pages with sorting and filtering possibilities for html tables basically, but all triggered from the client's browser. In case you want to experiment too, have a look a the following.

sample of dynamic data filtering from client side
  • Firstly there's the use of the Spry, Adobe's open source javascript framework. Nicely embedded into Dreamweaver now (since CS3), it allows you to nicely access structured data, be it e.g. xml but also html tables !
    There's a whole bunch of possibilities and samples demonstrated on this page:
  • Then there are all these wonderful programmers and developers making all kind of solutions available. Matt Kruse proposes his Javascript Toolbox with all kind of libraries and the one to sort and filter tabular data is really very nice:
  • Toby Von Loesch is another one. He developed a very simple but powerful Javascript to filter a standard html table:

Amazing evolutions indeed ! And although limited (JavaScript, no database, functionalities etc.) really worth looking into as they bring speed and versatility to the client side of the application.

(1) Comments ·
Page 1 of 1 pages