Thursday, July 23, 2015

Pasting Content Without Weird Looking Results


When we cut from various sources and paste into the destination document, we often end up with a mish mash of our originally formatted content and foreign content.  Here are some techniques to reduce the pain.

When you right click to paste

Right Click to Paste in Word 2013 Screenshot
Left icon - K - Keep Source Formatting
Middle icon - M - Merge Formatting
Right icon - T - Keep Text Only or
Ctrl+Shift+Y  - Paste as Plain Text

After you paste

After you paste screenshot 

Setting your preferences for repeated use

File > Options > Advanced > Cut, Copy,, and Paste

Removing Styles and Direct Formatting long after the Paste

Style Inspector and Style Pane screenshot

Note the virtual entry in the Styles Pane - Clear All - it isn't real Style, it is an menu item to clear styles and direct formatting.

Google Docs Paste Behaviour

Ctrl+V - Pastes with Source Formatting
Ctrl+Shift+V - Pastes plain text

Monday, June 22, 2015

Deleting windows.old

I don't know what method Microsoft will use to deploy free Windows 10 to participating Windows machines.

I just upgraded a Windows 8 machine to Windows 8.1 - by way of the green Windows Store tile. It took a while to download 3+ Gb of Windows 8.1, then took its time to install in-place over Windows 8.

After it all settled down after rebooting, we have a Windows.old folder on C: drive. I'm pretty confident I don't need it anymore but it won't delete using Windows Explorer - it gets to the Windows.old\System folder and stalls because of some access rights / permissions. It does not ask for an admin password so I assume that it is some system folder permissions issue with a dodgy no can do error message. I thought, "ugh! do I have to go permissions hacking?"

Turns out, that's not how to delete Windows.old According to Microsoft article How Do I remove the Windows.old folder, I can use the Disk Cleanup tool.

And then I looked at the Disk Cleanup tool and instead of ignoring the short list of boring things it clears (which often does not do enough when I am desperate), there is actually a list of interesting things it can clear off.

Wednesday, June 17, 2015

The Microsoft Access Tab Control on a Form

Psst. Tab_OnClick event does not trigger when you click on a Tab in the Tab Control. You have to use the OnChange event of the Tab Control. But how do you refer to the current tab or active tab so that you can conditionally execute code?

No point looking at the MSDN article on the Tab Change Event.

Sample code is in an Access 2000 article:  ACC2000: VBA Procedure to Determine Current Page of Tab Control

The current tab name is in TabCtrl.Value - oh, and you don't use the Page Name, you use the Page Index Number.

Monday, March 30, 2015

Microsoft Office 365 is now available to Monash University staff and students free

Monash University is a solid Google Apps user, for both Students and Staff. In 2016, Microsoft Office 365 is now available too. Microsoft Office 365 is
  • Office cloud webapps
  • installable classic Office 2013 desktop programs
  • OneDrive cloud storage (description in restricted webpage - you need to log into portal first before you go to that url.

Sunday, November 16, 2014

You know how Access 2013 won't open the Northwind 2000 .mdb file?

You know how Microsoft Access has been engineered to lack the ability to open Access .mdb files? Brain dead idea by the team. Even if they want to deprecate .mdb files and move onward, you want to be able to open or transfer legacy files from wherever or whomever you got them. That's your  user owned and invested data, not some arbitrary decision to be made by the database vendor. Now, if your organisation has moved on to Office 2013 and abandoned Office 2010, you will have to beg, steal or borrow a machine that can open and convert .mdb files.

It's a really silly situation. Because nobody told the Visual Studio 2013 / .NET framework 4.51 team to abandon this Access '97 .mdb file format as a data source.

Monday, July 28, 2014

Visualising Data

It's really hard to visualise data on-the-spot when it's not data that I live with.

Wednesday, April 30, 2014

Happy 50th Birthday, BASIC

I work almost daily with Microsoft Visual Basic for Applications - the language built into Microsoft Access, Excel, Word, Powerpoint, Project. It could stand improvements in elegance and modernity - that's what Visual Basic.NET was supposed to be. Except that Microsoft Office is written in COM architecture, not .NET - so VB.NET doesn't look like it's going to be embedded into Office-as-we-know-it.

But that's an aside. VBA itself is a descendant of the Microsoft's earliest BASIC, which was patterned after Dartmouth BASIC