Monday, August 23, 2010

Capture video frame on Media Player Classic

http://easy-tricks.blogspot.com/2010/02/take-snapshot-window-media-player.html

Note:
After changing Output option, reopen the video

Saturday, August 21, 2010

Error "Table xxx does not exist" when restoring NAV backup

- a table with data common to all companies is missing. When the NAV backup
is created, only one company was selected, and the "data common to all
companies" option was unchecked. The table object is part of the database,
but the underlying physical table is not included.
- a view that a linked table is linked to is missing. When you have a NAV
table object that is linked to a view or table on SQL Server, you will need
to create that view and/or table directly on SQL Server, before restoring
the NAV backup.

Source:
TableData does not exist
www.eggheadcafe.com/software/aspnet/34033226/tabledata-does-not-exist.aspx

Tuesday, August 17, 2010

Find duplicate rows

Locate duplicates by using conditional formatting
http://office.microsoft.com/en-us/excel-help/locate-duplicates-by-using-conditional-formatting-HA001136616.aspx
Section: Sorting the data

Saturday, August 14, 2010

Shadow the Console session of Windows 2003

How to Connect to and Shadow the Console Session with Windows Server 2003 Terminal Services
http://support.microsoft.com/kb/278845

Tuesday, August 10, 2010

Portable software(s)

portable web server: Server2Go

http://xjoss.net/forumdisplay.php/210-X-Tech-Software

www.4shared.com/dir/a9PjWRo8/sharing.html

Tuesday, August 3, 2010

Word 2007: Label Mail Merge with Watermark

How to Add Graphics to Labels in Word 2007
www.dummies.com/how-to/content/how-to-add-graphics-to-labels-in-word-2007.seriesId-77183.html

How to select image that has been sent behind the text?
To select objects that are hidden, stacked, or behind text, do the following:
On the Home tab, in the Editing group, click Select, click Select Objects, and then draw a box over the objects.
Source:
Align or arrange a picture, shape, text box, SmartArt graphic, or WordArt
http://office.microsoft.com/en-au/word-help/align-or-arrange-a-picture-shape-text-box-smartart-graphic-or-wordart-HA010192216.aspx

Note to self:
How to make image transparent:
Increase its brightness

Monday, August 2, 2010

Excel: Removing duplicate rows based on values on a column

DeleteDuplicateRows
www.cpearson.com/excel/deleting.htm