|Windows + Shift + S|
Everything was kicked off officially on June 5th with the opening ceremonies over at the PNE Forum, where teams from every province and territory paraded in with their flags, cheering wildly. There are even some teams from abroad that are here to practice for the upcoming WorldSkills competition in Germany. We were also lucky to be joined by special visitors Mag Ruffman, Mike Holmes, and Mike Holmes Jr., who have stuck around to experience the entire competition.
The competitors were busy at work yesterday and today at BC Place, with all of the excitement and intensity of the Olympics. One of the neatest things about the event is the ability to walk around and visit the different contest areas. You can check out the projects that everyone is working on, and talk with industry experts. This is my seventh year attending, and I continue to be amazed at how much I learn in such a short period of time.
|A view of the floor. The Jumbotron was showing live images from the various contests around the stadium. As you can see, there was a lot going on.|
From left to right: Stacy DuBois, David Boivin, and Caitlin Mayo - Team Canada 2009 Alumni at the Skills Canada National Competition in Vancouver, BC.
|Hunter Engineering Company's alignment system demo - a company representative was explaining to me how their software works with information gathered from devices attached to each wheel and high resolution cameras. Matched against the specific model of the car from an extensive database, technicians can align the wheels with a very intuitive computer interface.|
|The robotics contest area is a treat for spectators. A crowd gathers to watch as teams compete head-to-head. Here you can see a robot moving a pallet into place, knocking out one of their opponents' pallets.|
- Click on the 'File' tab on the ribbon, and then choose 'Options'.
- In the 'OneNote Options' window that will appear, choose 'Advanced' from the menu on the left.
- Scroll down to the bottom. The second-last option is 'Insert long printouts on multiple pages'. Clear the checkmark from this box.
Someone from a training company wanted to send out summary data about in-progress courses to every student by e-mail. As every message would require a number of different records, it seemed logical to use the 'Directory' option. That wasn't a good solution, however, as the sender wanted to be able to use the e-mail integration features of the 'Letter' option. Here's how to use some 'Directory' features using 'Letters'.
1- Start a mail merge document using the 'Letters' option, and set up everything in your letter (including the data source).
2 - Go to the Insert Field dialog box (not a mail merge field, but just the regular fields) and choose 'Database' from the categories. Click on the 'Insert Database' button.
3 - Click on the 'Get Data' button, and choose the same data source that you used for your mail merge.
4 - Click on the 'Query Options...' button. Go to the Select Fields tab and make sure the right-hand list contains only those fields that you want to see in the table.
5 - Click on the 'Filter Records' button, and set up a criteria for the UserID field to be 'Equal to' arealuserid (choose any existing UserID and put it here - you will change this later, so it doesn't matter which one you pick). Click the 'OK' button.
6 - Click on the 'Insert Data...' button, and place a checkmark in the 'Insert data as field' checkbox. Click the 'OK' button.
7 - Now you should be back in your document, and you'll see a table there that shows the records for the UserID you chose. Press Alt+F9, and you'll be able to see the field codes. It will probably look like a mess. That's a good thing.
8 - Look right near the bottom of all of that code, and you will see a SELECT statement. In this statement, highlight where you had entered a random UserID, and now go up to your toolbar and insert the UserID mail merge field. What you're doing is setting the criteria to be equal to whichever UserID is currently being used for the mail merge. Make sure you keep the single quotes around the mail merge field and are only replacing the actual UserID.
9 - At this point, you might want to hit Alt+F9 again to stop seeing all of that code. Try to finish your mail merge, and you should see separate tables for each individual letter.
By default, you can use the 'Undo' button up to 20 times in a row in Microsoft Visio. After that, you're out of luck. If you're like me though, and enjoy being able to time travel a bit more, you're going to want to change that setting to the highest number possible.
To change the setting, go to the 'File' tab, and then click 'Options'. In the 'Visio Options' window that will appear, choose 'Advanced' from the menu on the left. Now, in the first section, 'Editing Options', the 11th option from the top is 'Maximum number of undos'. Go ahead and change the number in the listbox to any number that is equal to or less than 99.
You could also reduce the number of times that you can undo actions, but why would you want to do that? The only real advantage is that it reduces the amount of extra data sitting in memory... but that shouldn't be too much of an issue unless you're using an ancient computer.
In any case, it's up to you - and you're free to change it any time you feel like it. Happy drawing!