Better Microsoft Outlook Searches

Is it easy for you to find an old email in Microsoft Outlook? I always click in the Instant Search box, type a word or two, and hope for the best. That doesn’t always work too well  Fortunately, Alex B showed me a few tricks for better Microsoft Outlook searches, and they might help you too. There’s also a big problem with one of these tricks, and Microsoft won’t be fixing it.

Continue reading

Posted in Microsoft Office Tips | Leave a comment

YouTube Not Eligible for Monetization Problem

On my Contextures YouTube channel, I’ve posted almost 500 Excel videos, since starting way back in 2008. There’s a bit of advertising revenue from the videos, and I usually just check the grand total each month, and put that amount into my records. Today I took a closer look at the revenue for each video, and was surprised to find that one was flagged as “not eligible for monetization”. After some troubleshooting, I think that I’ve figured out what the YouTube “not eligible for monetization” problem was – see if you can spot it.

Continue reading

Posted in Computer tips | Leave a comment

Access Query Date Criteria Examples

On my Contextures website, the focus in on Excel tips and tutorials. Behind the scenes, I use Microsoft Access too, for time tracking, website statistics and a few other key tasks. This week, I wanted to find files that hadn’t been updated for a long time, so I created a query that selects records older than X – Access asks what X is each time the query runs. Here’s what I built, and a few other Access query date criteria examples.

Continue reading

Posted in Microsoft Office Tips | Leave a comment

SamCart or E-junkie for Digital Product Sales

Last week I signed up for a trial subscription to SamCart, to see how it worked for digital product sales. I’ve been happy with E-junkie, but SamCart had a few shiny features that looked appealing. Things got off to a great start, but one key feature is missing, so I’ll be staying with E-junkie. Should you choose SamCart or E-junkie?

Continue reading

Posted in product sales | Leave a comment

Can You Give Yourself a Vacation?

When you work for somebody else, you get vacation time every year. It’s nice to have lazy time away from the office, and think about something other than work for a while. But, when you work for yourself, do you remember to go on vacation? Or do you just take a long weekend now and then, and then get right back to work?

Continue reading

Posted in Productivity | Leave a comment

Missing Months in Access Report Headings

Today I made a simple report in my Access database, with a list of articles that I’ve written in the past 60 days. I tried to group the articles by month, and that’s when the trouble started. My Access report headings didn’t show all the months, and it took me a while to solve the problem. Maybe this fix will help you too.

Continue reading

Posted in Microsoft Office Tips | Leave a comment