AnalogDuck.com

Nested tables in MS Access are referred to as SubDatasheetsSubDatasheets. There is an excellent article introducing the matter here and something more advanced here.

Microsoft has some documentation on the matter here.

For some time now I have been gathering a collection of applications which can be run without installation. I have considered publishing the list of my collection, but it looks as though somebody has already dones so. This is quite likely the most useful collection of software for the the Windows platform:

• The Portable Freeware collection

You are the sweetest little Bee:
tu eres la pequeña abeja más dulce

I am a small dog for you:
soy un perrito para tú

You are as pretty as a pumpkin
tu eres tan bonito como una calabaza

And some not so sweet, but all too entertaining nothings...

espero ano y felicidad
I wait for anus and happiness
(an accidental mis-translation of Feliz Navidad)

I am often confounded by Microsoft’s very specific and somewhat foreign lexicon. So here I document some items I hope not to forget:

• In Access, the expressions in advanced filters are sometimes called “expressions” and sometimes called “formulas”. The beginners reference for these is entitled “Examples of filter criteria”.

Yup, now you can vandalize church signs from the safety of your keyboard.

The only way to *really* flush DNS without rebooting Windows. First determine the funky name (not sure what the proper label would be) for your network adapter. It may take some guesswork unless you're smarter than me. On some systems there are obvious labels next to the funky names, on others not. It seems to depend on the driver. Here's the command you type:

devcon listclass net

Once you've got the funky name, edit the following script to your needs and save it as a .bat file. This is the script I use on my own system:

As all Windows users often find, the only reasonable solution to the building quirkiness of a Windows session is the eventual reboot of the machine. As a systems admin, I often find myself in situations where this is less than practical and so I have come up with the following, ultra-cheezy technique which actually usually brings a system back into (apparent) stability. (It's always hard to be certain what's going on under the hood though).

1. Close all non-critical applications and stop and any non-critical services (if you're not certain which services aren't critical for your current situation, skip this step).
2. Open the Task Manager by one of the following methods (because, depending on the state of your system, often many of these will fail to function properly):
• Press CTRL-SHIFT-ESC
• Press CTRL-ALT-DEL (and, if necessary, select Task Manager
• Right-click the taskbar and select Task Manager
• Open Start => Run... and type either taskmgr or c:\windows\system32\taskmgr.exe
• Go to C:\WINDOWS\system32\ and double click on
  taskmgr.exe
• Open a command prompt and type either taskmgr or c:\windows\system32\taskmgr.exe
3. WARNING: Do *not* exit the Task Manager after performing the following step. If you do, you may have to reboot your system. The following step will close the Start menu, taskbar and all Explorer windows without and thequite probably will not restart automatically. You will use the Task Manager to restart them.
   
   Once you have the Task Manager up, select the Processes tab and then click on the Image Name column to sort the processes alphabetically. Locate each instance of explorer.exe, right click and select End Process.
4. Open the File menu of the Task Manager and select New Task (Run...)
5. Type explorer in the Run... dialog. With a lot of luck, your Start menu, taskbar and tooltray should return, and Windows should be acting somewhat normal again.
6. Restart all your necessary but non-critical applications and services which were started earlier.
   

I’ve been totally cracked out on a shlew of Nintendo music that is really durn good music. The two albums I must pimp to everyone:

• Legend of Zelda: Ocarina of Time Hyrule Symphony
• Mario & Zelda Big Band Live CD (while you're there, also note the (Mario & Zelda Big Band Live DVD)
  

That these two albums are of exceptional quality is an understatement. The first of the two is symply phenomenal. Top-notch symphonic performance as good as any you would listen to. The second album is just plain fun, my only complaint being that the recording style was to include the live audience instead of isolating the sound of this incredibal band in studio fashion.

This is our new favorite charity. You can donate toys, games, books, and/or money to sick kids at children's hospitals, and all of it goes directly to the kids.

 Just choose a hospital from the map on their website, and you will be taken to an Amazon wishlist for the hospital.  Choose whatever you want to give them from the list.  The shipping address is already in the system.  All items must be new and unwrapped.

Happy shopping!