Recent posts and inspirations

22 November 2013 - 13:45

C/2012 S1 aka ISON

Discovery date : 21 September 2012 - objects flying into our Galaxy at the speed of light...

(0) Comments ·
26 January 2012 - 09:52

Wisdom 2.0

Wisdom 2.0 summit

This is the name the annual Sillicon Valley conference and happening, pondering on the relationship between Technology and Mindfullness and consciousness.
Great !

Interesting evolution: hi-tech people realising that no matter how much technology we put into the balance, it's finally our state of mind which is the missing link towards success and fulfillment.

Worth paying a visit:

(0) Comments ·
15 August 2011 - 13:20

What’s moving you?

Welcome board Bio Farm St Blaise - owner Maurice Meyer

There once was an organic farmer who in the midst of his fields happen to have a thought bubbling up. It was a very simple but powerful one.

He was aware that so many farmers out there are doing their work with increasing concern for the wellbeing of the earth and its inhabitants, and that many had chosen -as he did- to cultivate organic, bio- and biodynamic food.
He was in contact with several of such people and exchanged with some of them in his region on a material level.

So the thought he had sounded more or less as follows :
"What if I just went out to visit some of these organic farmers worlwide to ask them what really moves them?" - that is: "what was behind their choice, why did they do it; and what would be their message for the world?".

An immaterial exchange which could be recorded on video, to then publish it into a documentary film and also on the net. Just to exchange and inspire...

He contacted a friend - cameraman... arrange for his farm to continue for a while without him, and off they went ! ...

Income Bio Farm St Blaise - owner Maurice Meyer

The farmer actually exists.
I met him recently during our family holiday in Alsace, France. His name is Maurice Meyer and he went twice to South-Africa already to start realizing this thought. Next on the agenda are Brazil, but also some European countries.

His publishing has started on an internet blog, where several short documentaries can be seen, both in English and French.

Really fresh and inspiring food - Just as an exemple I've added a sample one hereunder !

(3) Comments ·
05 August 2011 - 15:16

Interesting mind broadening inputs

As many of us I receive all kind of inputs in my mailbox all the time. These are a selection of some of those mind broadening sites or videos which came along my path over the summer time this year:

(1) Comments ·
30 January 2011 - 13:18

Full outer join in Access

During a course a participant informed about Access' possibility to create a full outer join.
If you've gone into the topic of joins, you might have realised too there isn't really a feature doing that - there's an inner join, a left and right join, but no way in one go to get a full outer join.

Of course I didn't needed more to get my curiosity taking off, and I found a really well written and clarifying article from the hand of Gregory A. Larsen.

His simple device is: if it can't be done in one time, do it in 3 + one time: create the 3 distinct queries that are possible and with a 4th union query you just combine those results.
Cool !

Here's another example from the Northwind Database:

SELECT Customers.CompanyName, Customers.CustomerID, Employees.LastName, 
Customers.City, Employees.FirstName, Employees.City
FROM Customers INNER JOIN Employees ON Customers.City = Employees.City


SELECT Customers.CompanyName, Customers.CustomerID, Employees.LastName, 
Customers.City, Employees.FirstName, Employees.City
FROM Customers LEFT JOIN Employees ON Customers.City = Employees.City
WHERE (((Employees.City) Is Null))


SELECT Customers.CompanyName, Customers.CustomerID, Employees.LastName, 
Customers.City, Employees.FirstName, Employees.City
FROM Customers RIGHT JOIN Employees ON Customers.City = Employees.City
WHERE (((Customers.City) Is Null))
(1) Comments ·
29 January 2011 - 01:48

Handling multi-selection lists in Access

One of the new features in Access 2007 was the possibility to implement multivalued fields, but that's not always going to help out for various reasons.
So handling data from lists where multiple selections are accepted remains a interesting challenge.

Here are some links I found helpful in implementing a solution for this:

(0) Comments ·
20 January 2011 - 05:42

Office Manuals for Download

The Mouse Training group has released their Office Manuals 2007 (2003 & 2000) are still available as well.

They form a good basis for those who are in to self training and are thus worth a download:

(6) Comments ·
19 January 2011 - 06:04
09 January 2011 - 14:26

Conditional Formatting for Excel charts

If you'd like to obtain some conditional formatting in your Excel charts, you'll have to as roll up the sleeves.
As there's no immediately feature for that - unlike of course the (greatly enhanced since Excel 2007) conditional formatting possibilities for cells- you'll have to proceed through VBA.

conditional formatted chart

Here are some links and samples to get you going:

If you really and rather go for something without VBA, then Andy Pope has some interesting scenarios for some specific situations:

(1) Comments ·
27 December 2010 - 16:30

Best wishes for 2011

best wishes for 2011

Best wishes for a 2011 'beyond' !
With the inspirations, through a friend who shared his enthusiasm about the CD 'Beyond' (with Tina Turner, Dechen Shak Dagsay & Regula Curti), and has this written on the inside cover:

We need a repeated discipline, a genuine training,
to let go our old habits of mind and to find and sustain a new way of seeing -
Go beyond rights and wrongs ...
Go beyond ...
(0) Comments ·
25 September 2010 - 07:41
21 September 2010 - 05:43

Introspection, brains and consciousness

Specific Brain Region Linked to Introspective Thoughts

A friend sent me this link earlier this week: it concerns an article on a study , explaining how the location for higher functions of the brain, like introversion , is behind the eyes.

Everyone knows this location actually, as it is symbolized by Indian women wearing the 'tilak', a small painted dot in the middle of the forehead, pinpointing to the same location (although the tilak now generally is used either aesthetically or to indicate a married status eg).

So, great to see that Science now also gets interest in the location of the 'Third Eye'.
But, as stated the article, Science is still in darkness as to what exactly triggers off the use of those precise regions...

A French article on the study can be found at Le Monde
Full article is available by subscription at here

(0) Comments ·
31 August 2010 - 07:34

Flash and IE … grrrr !

I was struggling lately with some Flash which I couldn't get to work on IE, no matter which version.
It finally turned out to be linked to a wrong clsid attribute value in the object tag.

This worked for me:

< object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" 
width="640" height="480" title="Program" id="progamID" >

This did not work:


Now these class attributes were generated by Dreamweaver and I don't really have good understanding what they stand for; but the puzzling thing was that this attribute apparently affects browsers differently.

On the way to this solution I passed to several sites on the matter of using Flash on websites:

On publishing Flash with the help of Javascript:

(0) Comments ·
24 August 2010 - 08:22

Default paper size in Word

If ever you're pondering on how to get the right paper size back when you start a Word document, here are a couple of links which might be of help:

Basically you need to think 'basic template' and change it asper your need - so that means going in search of or normal.dotx (from 2007 onwards) - in case you need help for that:

(6) Comments ·
17 July 2010 - 10:44
05 May 2010 - 09:02

Veggie Day Celebration in GentC

one year veggie day in Gent

EVA, the 'Ethical Vegetarian Association' in Gent, Belgium, has successfully promoted the campaign to take up a vegetarian diet for at least one day a week -
on Thursday. The local authorities have been endorsing the project, making Gent one of the first, if not the first city in the world to officially endorse the one vegetarian day a week.

The project celebrates it's one year anniversary this week, and launched a video on YouTube under the slogan:

One day makes such a big difference
Een dag maakt zo'n groot verschil
(1) Comments ·
03 May 2010 - 15:12

personal.xlsb in Excel 2007 not loading automatically anymore

This happened to me and I was really pondering what was going on.
But I remembered that when Excel has a crash, the next time it loads it might prompt to de-activate certain add-ins. And indeed that did the trick.

personal.xlsb is gone !!!

So this might help out if you encounter the same issue:

  • Click on the Office button and go to the Excel options
  • Choose Add-ins
  • Go to the combo box at the bottom entitled 'Manage'
  • See whether you find personal.xlsb add-in and enable it again.
(0) Comments ·
28 April 2010 - 15:23

Error handling and debugging in VBA

If you're after some good explanation and highlights in terms of error handling and debugging with VBA, I would suggest these:

(0) Comments ·
15 April 2010 - 15:21

Commands from prompt, batch files and backups

I was asked recently to do a course on DOS-commands and on RUN-commands, i.e. commands you can type at the run prompt.

And although I scoped it somewhat to the most used and/or basic ones, there are people coming up with huge lists of them:

This course really felt like 'closing a cycle', as my very first IT manual ever was a DOS manual which came along with a Commodore PC - one without even a harddisk, that was, back in 1986.
And speaking of DOS commands of course brings us to batch files.
If ever you want to try some:

Actually I'm using a batch files for my daily backups to external harddisks, with log files on top of it.... All thanks to good old DOS and a double click of a shortcut on my desktop :-)
Here's what I use:

set LogPath=e:\Backups\
set LogFileExt=.txt
set LogFileName=Backup%LogFileExt%
::use set MyLogFile=%date:~4% instead to remove the day of the week
::set MyLogFile=%date%
set MyLogFile=%date%
set MyLogFile=%MyLogFile:/=-%
set MyLogFile=%LogPath%%MyLogFile%_%LogFileName%
::Note that the quotes are REQUIRED around %MyLogFIle% in case it contains a space
If NOT Exist "%MyLogFile%" goto:noseparator
echo.%Date% >>"%MyLogFile%"
echo.%Time% >>"%MyLogFile%"

xcopy d:\data g:\data /d/s/c/h/r/y/f/k >>"%MyLogFile%"
xcopy d:\2013Website g:\2013Website /d/s/c/h/r/y/f/k  >>"%MyLogFile%"
xcopy d:\Graphics g:\Graphics /d/s/c/h/r/y/f/k /EXCLUDE:e:\exclude.txt  >>"%MyLogFile%"
xcopy d:\Images g:\Images /d/s/c/h/r/y/f/k /EXCLUDE:e:\exclude.txt  >>"%MyLogFile%"

xcopy e:\Audio h:\Audio /d/s/c/h/r/y/f/k  >>"%MyLogFile%"
xcopy e:\Video h:\Video /d/s/c/h/r/y/f/k  >>"%MyLogFile%"
xcopy e:\VideoAudioTraining h:\VideoAudioTraining /d/s/c/h/r/y/f/k  >>"%MyLogFile%"

(2) Comments ·
13 April 2010 - 10:21

Excel Pivot Tables unplugged: hide items in a filter combo

Excel pivot tables are just a fantastic tool. And you can even boost it in various ways.
Just some creative ideas I encountered while working on a problem with hiding items in a filter.

Sometimes you just need to think out of the box to get where you want to get. And that may mean create an extra column with new data, you can then integrate in your pivot table analysis.
As as sample of this approach: Filter an Excel Pivot table for upcoming dates.

And did you know there are some specific shortcuts and manipulations to sort and hide information in pivottables? You'll find a good article on this at following blog topic.

What I hadn't realised yet is that in pre-2007 versions, there was an option in the 'page field zone' to hide certain items from appearing in the combo box, as you can see in this article on .
Excel 2007 uses a new concept under the name of 'report filter' and as the 'multi-selection' feature has been added, this possibility to remove items from appearing in the combo has disappeared.
So if certain data shouldn't appear, you might have to go back to the source data and hide them there and thus use a 'out of the box' solution.

(0) Comments ·
12 April 2010 - 04:50

Access development: syntax of sql queries in VBA

One of the toughest things to do when coding VBA in Access development projects is coming to terms with SQL queries.
I've found following tips and tricks helpful :

SQL2VBA form

Allen Browne, one of the main authorities on the matter, proposes a form with VBA code which actually does the hard coding into VBA of any SQL string of your choice.
You'll find the code and procedure at his site:

Another thing you might have ran into is using query parameters into SQL strings. Well you can't basically, you must 'transform' them and here is how: If you run into the error "Queries: Too few parameters, expected n" - that's exactly what I'm referring too here :-).

And this might come in handy too: some basic testing for empty recordsets - as when your SQL query doesn't return records in the recordset, you'll off into problem land as well.
I've found this one useful to solve this issue:

(0) Comments ·
10 April 2010 - 05:14
08 April 2010 - 06:54

WP for DOS

short cut to WP DOS

I had never thought to still get involved in a Wordperfect for DOS project in the year 2010 !
And once going into it, I soon discovered there's still a good amount of people using this system for all kind of reasons.
I even discovered two very precious resources in setting up and configuring WP for DOS :

browsing in WP DOS

As it concerned a very specific installation on top of being a DOS program (a Dutch language version with both azerty and US international qwerty keyboards) all kind of issues occurred ...
And getting the keyboards to behave with special accents was probably the most difficult task to tackle.

But end well, all well, and here are some specific links if ever it help someone out too:

typing in WP DOS
(0) Comments ·
03 April 2010 - 07:14

Interesting code resources during recent Access Projects

Doing lots of database development in Access brought up all kind of interesting insights and links.
Just a selection of some of these encountered goodies :

(0) Comments ·
02 April 2010 - 16:36

Random values between two figures in Access

Ingenious all those solution maths-people come up with.
Take the problem to find a random value between two integers.

Well you take the interval between the two figures you have in mind, add one, then multiply with a random value and add the minimum of the figures you had in mind. Just rendering it as an integer and you're done ! If that sounds too much like maths.... well ... it is :-)

Given that the random function in Access is rnd() ( you obtain a decimal between 0 and 1) you get something like this to obtain a number between 10 and 100

Int ((100 - 10 + 1) * Rnd + 10)
For a full explanation go to
(0) Comments ·
Page 1 of 9 pages  1 2 3 >  Last »