Recently in tips & tricks Category

It may sound very stupid but it comes handy and it is not obvious.

This lists all packages from the default channel : pear list
This lists all availables packages (including the ones installed locally) from the default channel : pearl list-all

And... This lists all installed packages locally : pear list -a

Après pas mal de recherche, des essais, beaucoup de prise de tête et de grands moments de solitude, voici le pilote pour les clavier français mac (testé sous macBook, macBook Air, macBook Pro et les nouveaux clavier Apple). Pour ceux qui ne peuvent pas se passer de Microsoft Windows XP...

After much net scouring, trial and error, a lot of hair pulling, etc. Here is the Mac French keyboard driver (tested under macBook, macBook Air, macBook Pro and the new sleek Apple keyboards). For those who cannot live without Microsoft Windows XP...

Alt (Mac OS X) correspond à Crtl+Alt ou Alt de gauche (Windows)

Alt (Mac OS X) maps to Ctrl+Alt or left Alt button (Windows)

Alt+Shift (Mac OS X) correspond à Crtl+Shift (Windows)

Alt+Shift (Mac OS X) maps to Ctrl+Shift (Windows)

Pour ceux qui se sentiraient éternellement reconnaissants ...

For those of you who might feel inclined to ...

MK_FR_fr_1-2.zip - language input set to French (France)

Thing is, Access does not behave as MS SQL Server. I had to update recently a dBaseIV database with another (don't ask...) and the easiest way I could think of was Access.

I am no SQL Guru, but I remembered that in SQL Server you could do that:

UPDATE target SET target.column = source.column FROM table1 target INNER JOIN table 2 source ON target.rel = source.rel

I think this is a MS SQL Server specific syntax though...

However, in Access, you have to do that (I did not guess, I want through hope, denial, despair and finally to microsoft and had a look at the code generated):

UPDATE target INNER JOIN table 2 source ON target.rel = source.rel SET target.column = source.column FROM table1 target

Where source column was actually written as [source]![column].

I haven't tried to see what you got if you removed the brackets.