BIOS Settings

Reboot and keep hitting ESC, F2, F8, F10 or whatever the computer requires… But, there is another way, which I found out trying this for an old ASUS Transformer T100.
According to Asus: Press and hold the F2 button, then click the power button. DO NOT RELEASE the F2 button until the BIOS screen display.

Of course this does not work, why else would I write about it?

Continue reading BIOS Settings

Word 2019 Save as PDF shows ‘title’, not ‘filename’

Using a new (to me) version of Word 2019 brings new challenges.
I create invoices in Microsoft Word and save them as a PDF file to send by e-mail. In Acrobat it started showing the Word document property for document title, and no longer the filename, like I was used to in Word 2013.

The answer is a simple option… you just have to know where to find it:

Continue reading Word 2019 Save as PDF shows ‘title’, not ‘filename’

Reset the Excel Worksheet “Last” Cell

You can tell when the “used range” excel is using is too big and is going to add extra blank rows when you use the scroll bar to the right and it goes beyond the last row of actual data when you scroll to the bottom. Terrible when trying to print your data. I’ve found something, and corrected the procedure, so it consistently works to delete those blank rows.

Do this to get rid of them:

Continue reading Reset the Excel Worksheet “Last” Cell

Excel CSV with comma’s

You want a CSV, a comma-separated file, to actually have comma’s as separators and NOT semi-colons as your field delimiter!
However, in countries where the comma is used as decimal separator, this is not by default for Excel. Various sources hint to the solution, but none are really complete. You need to do this:

1. Change the system – region settings – additional settings – to use a , as list separator.
2. Change Excel – options – advanced – to not “Use system separators”, but manually set a . as Decimal separator and , as Thousands separator.
3. Then with Excel, save your file as “CSV (Comma Delimited)”
4. Change your Excel setting back to what it was (Use system separators), so you can continue your work like you’re used to.

Continue reading Excel CSV with comma’s

Mouse drag and drop fails

Fix problem with drag and drop not working in Windows. Have you encountered the problem in which you can no longer drag and drop files and folders in Windows Explorer (if you are using Windows 7) or File Explorer (if you are using Windows 10 or Windows 8.1)?

You can click and right click on files and folders, you can select files and folders, but you can’t drag and drop them anymore. We’ve encountered this issue ourselves and after searching for many possible solutions, we’ve found one which should work in most cases. Here’s how to restore the drag and drop feature in a couple of seconds:

Continue reading Mouse drag and drop fails

Descending Sort Order Thunderbird

I prefer my most recent emails at the top of the list. Unfortunately Thunderbird (and many other mail clients) do this different.
So how do I change the default sort order?
Change the advanced options!

If you want to sort all mail by DateDescending (newest at top), change the preferences in the config editor to:

mailnews.default_sort_order:    default     integer      2
mailnews.default_sort_type:     default     integer     18

So, what does that 2 stand for? And why 18?

Continue reading Descending Sort Order Thunderbird

Teamviewer Connect greyed-out and disabled

What a week… sometimes things just keep going wrong for no reason. Today it was Teamviewer not giving me the option to connect to a remote PC to simply view their desktop and help the person with an issue they were facing. The option ‘Connect’ was just greyed out, not being able to enter an ID. Even the box on the top ‘insert partner ID’ did allow me to enter a number, but expecting that number to be added to the list, the ‘Connect’ option there did not do anything either.

The “Ready to connect (secure connection)” you see at the bottom of the window is also a little misleading there, because it does not want to connect at all!
So… what is the solution?

Continue reading Teamviewer Connect greyed-out and disabled

WordPress 404 errors

How To Fix Broken Permalinks In WordPress.
WordPress is a powerful CMS. Sometimes a slight tweak can make your website inaccessible. Another common problem that most WordPress users face at some point is WordPress posts returning a 404 Error. In this article we will show you how to fix WordPress posts returning 404 error.

Usually in this scenario a user can access their WordPress admin area, their blog’s main page, but when accessing a single posts they get a 404 Not found error. First of all, don’t panic most of the time your posts are still there and completely safe. This usually happens if your .htaccess file got deleted or something went wrong with the rewrite rules. What you need to do is fix your permalinks settings. There are several sites describing this, below is the summary of what you actually need to do.

UPDATE JULY 2021: “Still haven’t found what I’m looking for”… so I wrote my own htaccess_keeper plugin. It runs on the normal homepage of the website to save the htaccess to a backup file (when changed), and restores it when a zero bytes file has been detected. It also shoots of an e-mail to the admin that it had to jump to the rescue again!
Interested in this plugin? It is for sale, just contact My Brain.

Continue reading WordPress 404 errors