Saturday, July 24, 2010
Friday, July 23, 2010
Some inventive ways to use Excel conditional formatting and this does not even need the latest Excel version.in reference to: Conditional Formatting in Excel | Chandoo.org - Learn Microsoft Excel Online (view on Google Sidewiki)
Wednesday, July 21, 2010
Ryan McMinn and Dick Moffat show off uploading an Access database to Sharepointin reference to: Developing Access 2010 Hybrid Apps with Dick Moffat | The Access Show | Channel 9 (view on Google Sidewiki)
Monday, July 19, 2010
Saturday, July 17, 2010
It's been a while since I used the MSCAL calendar control. It's been dropped in favour of the Date and Time ActiveX pickerin reference to: Using the calendar control in Access - Access - Microsoft Office (view on Google Sidewiki)
Wednesday, July 14, 2010
Here’s a revised reading list for those who want a leg up to the world of web pages.
- The authoritative and definitive source of information for is the World Wide Web Consortium (otherwise known as W3C). They discuss What is HTML, XHTML and CSS and the draft HTML5 specification.
- Head over to W3Schools for tutorials on HTML, XHTML, HTML5, CSS.
- ILoveJackDaniels.COM has moved on to AddedBytes. There, will find cheatsheets for CSS, HTML (as well as regexp, PHP and Python.
- The Web Design Group is still around with .CHM (Windows Help) and HTML format desktop references for HTML4 and CSS
- Discussions of ems vs pixels at the Web Developer Forum and a cited W3C font Tip for Webmasters and Big Baer's CSS Font Size explained - see also Jon Tan's Incredible Em & Elastic Layouts with CSS and About.Com's Using Points, Pixels, Ems or % for CSS Font Sizes
- Why you shouldn't click here and other W3C Quality Tips
- Colours on the web are indexed. See Big Baer's HTML Named Colours Reference.
Friday, July 9, 2010
MSKB article on how to fix the viewing experience on .chm filesin reference to: Certain Web sites and HTML Help features may not work after you install security update 896358 or security update 890175 (view on Google Sidewiki)
- c:\refs is where I put the .chm files
- I used both the C:\ and the file protocol - I think the file protocol was the one that solved it.
Windows Registry Editor Version 5.00[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\HTMLHelp\1.x][HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\HTMLHelp\1.x\HHRestrictions]"UrlAllowList"="E:\\refs;file:///E|/refs""EnableFrameNavigationInSafeMode"=dword:00000001"MaxAllowedZone"=dword:00000003[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\HTMLHelp\1.x\ItssRestrictions]"UrlAllowList"="E:\\refs;file:///E|/refs""EnableFrameNavigationInSafeMode"=dword:00000001"MaxAllowedZone"=dword:00000003
Wednesday, July 7, 2010
Friday, July 2, 2010
There is a difference. VBA uses Banker'sin reference to: PRB: Round Function different in VBA 6 and Excel Spreadsheet (view on Google Sidewiki)
Microsoft Office Video on how to insert Sparklines in Excel 2010in reference to: Video: Insert sparklines to show data trends - Microsoft Office (view on Google Sidewiki)