Kent's Repository A Compilation of Life's Problems and Solutions and other things…

Disable ipad/iphone screen and buttons for children and businesses

April 24

Do you have kids who love their iPads but always end up pressing buttons and getting into things they shouldn’t?

Do you own a business and have an app that you want to lock people in to?

Wouldn’t you love to be able to disable the screen and buttons!

Although you can do with Mobile Device Management (MDM), there is an easier way! It’s called “Guided Access” and it can be configured in minutes on any iOS device!

As always, I don’t take credit for discovering these things, we’re just good at the google. All credit for this one goes to WikiHow and Google. Link Below:

http://www.wikihow.com/Use-Guided-Access-to-Disable-Parts-of-an-iPad-Screen

Do you use Office 365 at work? Be mindful of the emails you send

February 20

Long story short, Microsoft is going to make it possible that your deleted e-mails never disappear and can always be recoverable. That being said, all you need to remember is that Work E-Mail is for Work!

Read the rest of this entry »

Microsoft Office Freezing or Lagging?

July 20

If your Microsoft Office products are freezing, lagging or behaving strangely, the issue may be with hardware graphics acceleration. We’ve seen issues involving Windows 8 and Nvidia Graphics chipsets, in all cases, disabling hardware graphics acceleration in the Microsoft application solved the problem. It’s possible that a drive update will be released to fix these issues but in the mean time, here is the solution.

Read the rest of this entry »

Office 365 Hosted Exchange & Distribution Groups (Security Flaw or Feature?)

July 15

Office 365 is the best thing to happen in the Hosted E-Mail business since well….I don’t know, I’m not a writer and I can’t come up with a clever comparison right now, just know that it’s a GREAT THING for many different reasons.

However, depending on your environment, some default features may be considered big security flaws by some. Most recently, we discovered that by default, regular users can create Global Exchange Distribution Groups which not only propagate to the GAL but can also encumber a routable e-mail address.

Read the rest of this entry »

Apple to “Refund for In-App Purchased made by a minor”

April 1

If you or someone you know has been affected by the lack of parental controls in Apple’s App-Store, you may be eligible for a refund.

In what I believe to be in relation to law-suits, Apple is issuing refunds for cases of unauthorized app store or in-app purchases. In my case, a minor who shall rename anonymous, purchased over $100 in in-game currency, whether by mistake or not, the damage was done. I followed the instructions provided by Apple and received a refund in under 20 minutes, GREAT WORK APPLE!

Read the full email below, use these links for additional information

Read the rest of this entry »

Microsoft to offer free Windows XP Migration Software (easy way to move your files)

April 1

With Windows XP support ending on April 8th, 2014, Microsoft is offering free migration tools for those still unfortunate enough to be using Windows XP. Whether by choice, necessity or laziness, those still on XP should consider upgrading. In my experiences, if you have at least 2 GB. of memory, anything that is running Windows XP will support Windows 7, in most cases you will even see some performance improvements. You may experience issues with using legacy (really really old) software/hardware but in typical cases you’ll be just fine.

Visit http://www.windowsxp.com for free migration software and additional migration information

Read the rest of this entry »

Useful Excel Functions: Unhide all hidden worksheets

December 2

This one comes to you compliments of www.extendoffice.com

The following short VBA code also can help you display all of the hidden sheets at the same time.

1. Hold down the Alt + F11 keys in Excel, and it opens the Microsoft Visual Basic for Applications window.

2. Click Insert > Module, and paste the following macro in the Module Window.

Sub UnhideAllSheets()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
ws.Visible = xlSheetVisible
Next ws
End Sub

3. Press the F5 key to run this macro. And the hidden sheets will be displayed at once.

Read the rest of this entry »

Multiple Exchange Accounts in Microsoft Outlook

November 25

With Outlook versions before 2010, you were limited to having 1 Exchange Type Account (mailbox) per profile. In this case, adding additional mailboxes was handled exclusively through the “add additional mailbox” option in the exchange account settings. However, this would only work if both accounts existed on the same exchange organization.

Beginning with Outlook 2010, you are now allowed to add multiple exchange accounts, this solves the problem of having multiple exchange accounts, on different organizations. However, adding multiple delegate email addresses for each exchange account now becomes a problem. Adding additional or delegate mailboxes for the first exchange account that was added in the profile works fine, however the “add” button in the additional exchange accounts is grayed out or disabled.  Here is a solution courtesy of http://www.msoutlook.info and Microsoft

1. http://www.msoutlook.info/question/756

Read the rest of this entry »

Useful Excel Functions: Substitute Multiple Characters

November 5

Normally, the excel substitute() function is limited to finding 1 string and substituting said string for another string. This Excel User Defined Function allows you to substitute multiple sets of strings/characters. I created a sheet with 2 columns (as named ranges), “CleanOLD” and “CleanNew” and used the following formula =SubstituteMultiple(TRIM(CLEAN(A1)),CleanOld,CleanNew)

Excel Multiple Substitute

Read the rest of this entry »

Cell border disappears when using CSS gradient in old versions of IE

October 29

In older versions of IE, mainly versions <=8 and modern versions rendering in a Quirks document mode,  using a gradient fill ignores a border, or rather, it fills over the border. This is very problematic when using a gradient fill to fill the background of a table cell. There are many posts around the net about this but most offer solutions that don’t always work, such as playing with border-collapse and position properties. Thus far, the only solution I’ve found that works across all cases is to simulate a border using the outline property.

Read the rest of this entry »

« Older Entries