Microsoft Access · Microsoft Word

Microsoft Access – Merge Many-To-One Records to Microsoft Word

I’ve got to give all props to Graham Mayor. His add-on was brilliant and did the job! If you need to have more than one record put on a Word document, based on a field’s value, Graham’s add-on is your solution. If you have several items that need billed to one account, for example, you… Continue reading Microsoft Access – Merge Many-To-One Records to Microsoft Word

Microsoft Excel

PERSONAL.XLSB is locked for editing

How to disable this message: PERSONAL.XLSB is locked for editing Open ‘Read-Only’ or click ‘Notify’ to open read-only and receive notification when the document is no longer in use. In Excel, go to the View tab and choose Unhide in the Ribbon under the Windows group. When the dialog box appears, choose “PERSONAL” and click OK. Go… Continue reading PERSONAL.XLSB is locked for editing

iPhone · Phones

A Setting On Your Phone That Will Help Give You A Better Night Sleep?

There are many adjustments you can make that can really improve your quality of sleep. Getting up at the same time every day, going to bed around the same time, eating healthy, avoid caffeine, alcohol, nicotine, keep naps short if you take them, exercise, etc. I’m sure one thing you’ve also heard of is to… Continue reading A Setting On Your Phone That Will Help Give You A Better Night Sleep?

Browsers

Stop Internet Explorer 11 Scroll Bar from Disappearing

If you’re annoyed with your scroll bar disappearing every time you take a pause, here’s a fix. I have to start by saying I have Windows 10 and it worked perfectly for me. It may not work for all Windows versions. Click START on your computer and type “Notepad”. Paste the following code in Notepad. @-ms-viewport{width:auto!important}… Continue reading Stop Internet Explorer 11 Scroll Bar from Disappearing

iPhone

How To Cancel a Auto-Renew Subscription For An iPhone App

Whether you did it on purpose or by accident, it can be very confusing on where to turn when you need to stop an auto-renewal subscription on an iPhone app. The good news is, it’s really easy! Here’s how: Go to Settings on your iPhone. Scroll down and select “iTunes & App Store”. Click on… Continue reading How To Cancel a Auto-Renew Subscription For An iPhone App

iPhone

Apple ID Account Disabled on iPhone- Old Email Still Showing

You want to change your email on your Apple ID on your iPhone. The problem is, your iCloud is still showing your old email address and now your account has been disabled! You’re getting more and more frustrated because it’s having you reset your password, only to then make you login. So you go back… Continue reading Apple ID Account Disabled on iPhone- Old Email Still Showing

Microsoft Access

How to Add a HotKey to Combo Box Drop-Down

  This feature is used in a Microsoft Access form. You will create a hotkey, such as Alt+D, and no matter what field on the form you are in, it will drop-down the combo you set this up on so you can do a quick search/selection. Open the form you have created the combo box… Continue reading How to Add a HotKey to Combo Box Drop-Down

Microsoft Word

Suppressing Blank Lines in Address

Microsoft Word – Suppressing Blank Address Lines   On your Word document, put your cursor where you’re inserting your first field. Then go to the MAILINGS tab and click “Insert Field”. To Toggle back and forth to see this formula, highlight all of the section you want to see (it’s ok if you highlight more)… Continue reading Suppressing Blank Lines in Address