20 Aug

DYNAPDF.DLL – HALF A PAGE PROBLEM

This is either because you need to change to using OutputTo method (see earlier tip) or you need to set scaling on (Auto Resize) in your report, in design mode.

Earlier Tip:

When using DynaPDF.DLL with Access 2007, 2010 and 2013 to print a report, you may only get half a page. To solve, you have to dispense with ConvertReportToPDF function and use Docmd.OutputTo instead:-

numVersioneAccess = CLng(SysCmd(acSysCmdAccessVer))
If numVersioneAccess <= 10 Then ‘ Access 2003

blRet = ConvertReportToPDF(vReport1, vbNullString, FilePath, False, False, 150, “”, “”, 0, 0, 0)

Else ‘ Access 2007 or over

DoCmd.OutputTo acOutputReport, vReport1, acFormatPDF, FilePath

End If

9 Aug

BIG PHARMA FINDS CURES?

I hate to break it to you, but drug companies don’t find medicines for diseases, they find diseases for medicines. Examples of this are everywhere:-

  • AZT – a cancer drug from the 60s, they switched to using it for HIV in the 80s
  • Statins – a drug developed for hypercholesterolemia, they switched to using it for lowering LDL cholesterol
  • Viagra – a drug developed to lower blood pressure, they switched to using it for erectile dysfunction

And hundreds of other cases, no doubt. What’s wrong with that? Well, just look at the first two, AZT wasn’t a cure for HIV, in fact it allegedly killed more people than it cured and it put a whole generation off HIV drugs completely. Statins lower LDL cholesterol which has been shown to be completely irrelevant to heart disease. If you put a 1000 patients on statins for 3 years you *may* prevent 2 heart attack deaths, which is statistically insignificant.

https://www.theguardian.com/healthcare-network/2016/mar/30/new-drugs-development-costs-pharma

28 Jul

BLACK BOX INSURANCE…DON’T DO IT!

You might think it is worth saving a few quid on your insurance by having a black box installed but the consequences of transgressions by speeding or braking too quickly, which are very easy to do, is far too punitive….leading to having a policy cancelled and then having quotes of £8000.

27 Jul

KINGHT RIDER WAS RUBBISH!

I obviously never properly watched Knight Rider as a kid because, having just sat through an episode, the whole plot, storyline and acting is shambolic. Michael Knight just had to “turbo boost” KIT into the air to hit a building so that it would rupture a pipe thus saving a young lady trapped inside a pumping station. However, he pulls her out of the pipe via a near-by inspection hatch, no pipe rupturing necessary. Did we really think this was good? I can’t imagine we’ll be saying the same thing about Game of Thrones in 30 years!

27 Jul

MALWAREBYTES ANTIVIRUS

Exclusive Offer: MalwareBytes Antivirus Premium 1-Year

Click on the button above to purchase a full copy of the fabulous MalwareBytes Antivirus Premium softwarecurrently costing £39.99 (for 2 devices) via the www.malwarebytes.com website, but only £19.99 (for 2 devices) exclusively for my customers. (No PayPal account? Checkout as Guest.) As soon as payment is received I will send you the 1-year subscription key so that you can activate the Free product to make it Premium.

https://www.malwarebytes.com/mwb-download/

27 Jul

OUTLOOK: TURN OFF CONVERSATION VIEW

There is a feature (which I can’t really believe even exists) called “Conversation View” in Outlook (and Gmail) which should be called “Confusion View” because it causes normal emails to be completely missed by grouping them together if it sees the subject and parties involved as part of the same conversation.

Fortunately, you can turn it off in View, Show as Conversations. In Gmail, it’s under Settings, General. Sadly, you can’t turn it off in the Gmail App which is why I use Edison or MyMail App.

21 Jul

THE NO. 1 MOST EFFICACIOUS DRUG IS…VITAMIN D

Some recent studies are revealing that Vitamin D is the most important element in the body to fight cancer and a whole raft of other diseases. Vitamin D, or rather a steroid hormone substrate, is produced on exposure to the UVb light from the sun and circulates through the blood system enabling your immune system to respond where necessary.

Unfortunately, over the last few decades we’ve been told to fear the sun, and worse, to stay indoors or use sunscreen whenever we venture outside. But getting proper levels of Vitamin D helps your body fight cancer, Alzheimer’s, heart disease, ms, diabetes and flu. The common cold is mainly active during winter, when exposure to the sun is at it’s year round lowest, and the more northerly people live, the more likely they are to catch a cold.

https://www.creighton.edu/creightonmagazine/2017smrfeaturevitamind/

18 Jul

GMAIL FOLDERS

There is one important fact about Gmail that is stopping you from understanding it…Gmail doesn’t actually have folders.

All emails are actually in [All Mail] but some have labels, such as Inbox, Drafts, Spam etc. so they appear to be in separate folders. They’re not.

If you access Gmail via Outlook or Thunderbird then those labels are interpreted as folders, and this is where the confusion happens.

Another interesting tidbit is that [All Mail] contains all your sent emails, but it automatically sorts anything sent by you into another special folder called [Sent].

So you see, “There is no spoon”.

16 Jul

DESKTOP ICONS DISAPPEAR OCCASSIONALLY

On your Windows 7 PC, shortcuts that you create on the desktop may go missing.

This can happen if the the System Maintenance troubleshooter detects the shortcuts as broken.
The System Maintenance troubleshooter performs a weekly maintenance of the operating system. The System Maintenance troubleshooter either fixes problems automatically or reports problems through Action Center. When there are more than four broken shortcuts on the desktop, the System Maintenance troubleshooter automatically removes all broken shortcuts from the desktop.

What is a broken link?

A “Broken” shortcut is a shortcut to a file, folder or drive that may not always be available, for example, a desktop shortcut for a USB device may be regarded as broken if the USB device is not connected when the System Maintenance troubleshooter performs its maintenance, or, a network folder that is currently not available due to the network not being available.

Workaround

To work around this issue, use one of the following methods.

Method 1: Remove all but 4 broken shortcuts from your desktop
Keep the number of broken shortcuts on your desktop to four or less. You might accomplish this by removing all but 4 of your most used shortcuts on the Desktop. If have more than 4 shortcuts, you can also create a folder on your desktop and move the shortcuts to that folder. These shortcuts will not be removed since they don’t sit directly on the desktop.

Method 2: Disable the System Maintenance troubleshooter
If you must have more than four broken shortcuts on your desktop, you can disable the System Maintenance troubleshooter. Control Panel, Troubleshooting, Change Settings, Off

3 Jul

SAGE EMAIL VIA OUTLOOK WITH TWO PROFILES

Be careful if you send Sage reports to customers via Outlook with 2 profiles as your precious work might never hit the inbox as expected. I don’t think Sage can cope with this scenario and therefore you end up with nothing happening and your reports dissappear.

2 Jul

AGAIN, WEIRD PRINT SETTINGS WITH KONICA MY TAB

When you set up all your print settings for your Konica Minolta BizHub and click Add (to make a favourite) DON’T FORGET to click “Select All” to override everything with what you just set. I mean, if you selected A4, Tray 2 etc then presumably you want those settings to happen, but by default they won’t unless you choose Select All while saving the settings with a name. Bonkers.

29 Jun

NURSE STUDY FINDS LINK BETWEEN CANCER AND LACK OF SLEEP

A study in China collating 61 studies has found a link between night shift workers and certain types of cancer.

I find this interesting because I recently read Matthew Walker’s book “Why We Sleep” and he mentions 8 hours sleep per night is absolutely necessary for good health.

The increase may come from the lymph system not removing cells that are due for recycling (about every 6 weeks) which occurs at night, instead they fester and can turn cancerous.

Two separate hormones are at play here, 1) Melatonin, released by the pineal gland which builds up gradually as darkness falls to begin the scavenging process and 2) Seratonin which increases with daylight.

Two other major factors in cancer prevalence are Vitamin D and high meat consumption. Vitamin D is a essential to maintain a healthy immune system, and meat is extremely healthy when eaten in the right quantities, but not when out of proportion to vegetables.

Obesity is also a known factor, thought to be the second major cause of cancer in the UK.

https://www.independent.co.uk/news/health/women-night-shifts-cancer-risk-higher-diet-exercise-study-a8147956.html

27 Jun

DIABETES TYPE 3…YES, 3

Type 3 diabetes is a title that has been proposed for Alzheimer’s disease which results from resistance to insulin in the brain.

Studies carried out by the research team at Warren Alpert Medical School at Brown University identified the possibility of a new form of diabetes after finding that insulin resistance can occur in the brain

Lead researcher, Dr Suzanne de la Monte, carried out a further study in 2012 to further investigate the link.

The researchers pinpoint resistance to insulin and insulin-like growth factor as being a key part of the progression of Alzheimer’s disease.

https://www.diabetes.co.uk/type3-diabetes.html

27 Jun

AIRLANDER 10 – THE NEW AIRSHIP

The largest aircraft in the world is the UK’s Airlander 10, a hybrid airship filled with helium. It can take off even in 35 knot winds, carry a 10 ton payload and can stay in the air for up to 5 days.

The shape of the structure-less envelope acts as a wing to provide lift and four propellers powered by diesel make it fast and maneuverable. It weighs a net 1 tonne for additional control and stability.

Here is the Airlander 10, moments before it famously crashed!

24 Jun

CALORIES IN, CALORIES OUT – WRONG!

Any dietary advice you are given that references calories in/calories out as a weight loss method should be immediately ignored because the data supporting this theory is from just ONE study involving 12 PEOPLE. Coca Cola and many other food producers base their entire culture on recommending that you can enjoy their products as long as you watch your calories in/calories out, usually their adverts contain sporty scenarios showing how fit people can chug away on sugary drinks and snacks with impunity.

But, we already know from shows like America’s Biggest Loser all the sad, tragic tales of contestants putting the weight back on in the following weeks because this idea is basically wrong. Hormones play a much bigger part in weight gain/loss than calorie counting, which is why puberty (i.e. hormones) adds so much fat and muscle to kids growing up, why gastric bypasses work, why insulin (a hormone) resistance is such a massive problem worldwide, why there are 1.5 billion overweight people in the world eating the recommended high carbohydrate diet.

22 Jun

INBOX – A DIFFERENT APPROACH TO EMAIL

Available for Android, iPhone this app is similar to Gmail but it displays things rather like a ToDo list. Flights, emails, appointments, meetings show up as cards and allow you to respond and keeps you informed. Quite good.

20 Jun

CONTACTS.CSV IMPORT FAILED TRANSLATOR – GMAIL TO OUTLOOK

If you look at the contacts.csv file generated by Google and compare it to the one Outlook usually exports, you will notice that the Outlook one contains quotes around every field. This gave me the clue that perhaps the data itself was the culprit when the import failed with the “translator failed” message, and indeed I traced the error to a contact that had a photo assigned to him. The contact’s photo was a very long URL beginning with http://…… and after taking this one contact out of the csv file the import worked fine. Suggestion: Google; add quotes around your fields when you generate a CSV file!


14 Jun

Shazams#183

My latest Shazams collected from pubs, clubs, radio and when I’m out & about going places. Includes Foxes, Chemical Brothers, Fragma, Avicci, Bag Raiders, Kungs, Hurts, Billy Ocean and Lykke Li.

13 Jun

EXCEL – THERE WAS A PROBLEM SENDING THE COMMAND

Excel 2007: “There was a problem sending the command to the program”
  • Open Excel 2007.
  • Open the Menu in the top left.
  • Click the “Excel Options” button.
  • Click the advanced tab on the left of the options screen.
  • Under the general options uncheck the box “Ignore other application that use Dynamic Data Exchange (DDE)”

Excel 2007: “There was a problem sending the command … – InterWorks

https://interworks.com/…/excel-2007-there-was-problem-sending-command-program/
12 Jun

RDP SESSION INCORRECT PASSWORD – BUT IS NOT!

I found my own answer to this issue after I got access to the machine physically and was able to view the security logs for the failed login attempts.  For some reason windows seven required that I use the entire computer name \\computer name\account name\ to get to the machine whereas Vista did not require full name.  Problem solved as long as I use the full name convention for the computer as expected behind the ts gateway.  Also don’t pass the ts gateway credentials on to the remote computer as this causes it to want to log on with those credentials at the machine.

6 Jun

CLASSIC SHELL NOT OPENING ON START BUTTON CLICK

Works with Ctrl-Esc but not clicking Start Menu icon.

<?xml version=”1.0″?>
<Settings component=”StartMenu” version=”3.6.5″>
<DefaultMenuStyle value=”Vista”/>
<MouseClick value=”Nothing”/>
<DisableHotCorner value=”DisableAll”/>
<EnableStartButton value=”1″/>
<StartButtonType value=”AeroButton”/>
</Settings>

Ah, there it is – MouseClick is set to “Nothing”. Go to the Controls tab in the settings and change “Left Click opens” to “Classic Start Menu”.

3 Jun

BEFORE YOU REINSTALL WINDOWS

*Here to assume that disk 0 is a booting device.

a) After you boot your computer using Windows 8 DVD or System Repair Disc, a black screen
appears with gray text “Press any key to boot from CD or DVD“. Press any key.
b) Select the correct time and Keyboard type.
c) Click Repair your computer in the lower left corner.
d) Select Troubleshoot from Choose an optionscreen.
e) Click Advanced options in Troubleshootscreen.
f) Click on Command Prompt.
g) Type these following commands and hit enter after each line of command:
“#” is an instruction comment so not to type it 😉

# to execute diskpart program
diskpart
DISKPART> list disk
DISKPART> select disk 0
DISKPART> list volume
# find your system partition with fat32 file system. Here to assume it as volume 2.
DISKPART> select volume 2
# To assign drive letter.
# If you want to remove drive letter, use remove command.
DISKPART> assign letter=b:
# To terminate diskpart command.
DISKPART> exit

# Now, you sould move to b:\EFI\Microsoft\Boot\, as windows stores BCD in this folder.
cd /d b:\EFI\Microsoft\Boot\
# this is not necessary.
ren BCD BCD.bak
# To write a new bootsector on your system partition.
bootrec /fixboot
# If your windows running, you should do from here.
# To create BCD store. “/f ALL” is to update BIOS setting including UEFI firmware/NVRAM.
# Replace “ja-JP” with your language or remove “/l” option if you use English, of course.
# It might be sense only typing “bcdboot c:\Windows“.
bcdboot c:\Windows /l ja-JP /s b: /f ALL

That’s that. Booting information of your PC has been written over.

Let’s reboot and see whether it go fine or not!”
A couple things to note. First, when using command select disk, this is referring to your Windows 10 boot/repair media located in your CD or USB drive. Second, at the final step I was a little confused by the wording when addressing the language. The command I used was bcdboot c:\Windows /l en-US /s b: /f All. That’s about it! I was just about ready to wipe everything out and do a fresh install, so I’m incredibly glad I found this post.

31 May

BOOTREC OPTIONS

The full gamut of options for bootrec, e.g. fixing the boot process of a Windows PC from the CD.

Boot with Windows 7/10 installation DVD, select repair and open a command prompt.

Type diskpart
Type select disk 0
Type list partition then note the partition number where you installed windows 7/10
Type select partition X   (X is the partition number where Windows is installed)
type active
type exit
type bcdboot c:\windows   (if C is your windows partition)

29 May

SYNCTHING – BATCH FILE TO START SERVICE

Simple batch file to start Syncthing without a Dos window running (users could be tempted to close it). Edit the path to match.

============================================================
rem stelss bat
@echo off
rem create work bat
echo dir /s c:\^>log.txt>wait.cmd
rem Script file cooking
echo Set WshShell = CreateObject(“WScript.Shell”) >start.vbs
echo WshShell.Run “C:\syncthing\syncthing.exe”, 0, false>>start.vbs
rem run cooked script, dont wait exit
cscript.exe //b //nologo start.vbs
rem del temped files
del /f /q start.vbs
del /f /q wait.cmd
============================================================

28 May

VOIP APP FOR YOUR MOBILE

Good FREE app for your Android called CSipSimple if you have a geographical phone number and a VOIP service, so you can make and receive calls without needing a dedicated VOIP phone on your desk.

27 May

MP’S EXPENSES

Hello, what’s going on here? Diane Abbott has claimed more expenses than Conservative Jacob Rees-Mogg or LibDems Vince Cable and Ed Davey….tell me again Diane, how does socialism work?

27 May

GOOGLE CHROME PASSWORDS MANAGER – SIMPLES!

If you want to see, change or tidy up your password auto-entries then the best way is this URL:

https://passwords.google.com

Gives you a clear listing of all the username/password entries you have stored and makes it easy to delete or change them. Obviously, this is for people with a Google Mail / Gmail account or other Google-based app like Google Earth, YouTube etc.

26 May

GLARY UTILITIES

Free pack of utilities (you can download from ninite.com) for keeping your PC running smoothly. Includes:-

  • Disk Check
  • Defragment Drive
  • Driver Backup
  • Registry Analyzer
  • File Encrypter
  • Undelete File
  • Startup Analyzer
  • Duplicate File Finder
  • Disk Space Analyzer

24 May

1.1.1.1 – THE FASTEST DNS SERVER, WITH PROTECTION

1.1.1.1

If you access the Internet via a broadband router then you will no doubt be using the built in DNS server provided by your ISP. DNS servers just lookup the ip address of the webpage you are looking for, but it is possible to change your DNS server to different ones around the world that have specfic features like super-fast speed, family filters, DDOS protection and many other things.

Cloudfare’s 1.1.1.1 and a backup of 1.0.0.1 offer very fast lookups and filters from bad websites. You can also use OpenDNS for family filtered lookups using 208.67.222.123 and 208.67.220.123.

“To use FamilyShield, you should set your DNS server entries as: 208.67.222.123 and 208.67.220.123.  On our website, you’ll may notice that OpenDNS’ DNS servers are 208.67.222.222 and 208.67.220.220, but these do not apply to FamilyShield customers.”

24 May

CURRENT ACCOUNT SWITCH GIVES 3 YEARS FORWARDING

Stray payments from old accounts after you’ve switched will continue for 3 years, but that may be extended to 10 under new plans. For example, if you’ve switched from Barclays to Starling and somebody keeps sending you payments to your old Barclays, then it will still be credited to your Starling, even 3 years from now. The new plan is to continue as long as a payment is made within an 18 month period (a keep-alive period) for up to 10 years, otherwise the forwarding will stop.