Author: Debra Dalgleish

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 “YouTube Not Eligible for Monetization Problem”

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 “Access Query Date Criteria Examples”

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 “SamCart or E-junkie for Digital Product Sales”

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 “Can You Give Yourself a Vacation?”

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 “Missing Months in Access Report Headings”

Access Expression On Click Error for Form Button

I use a couple of Access databases to run my business, and things usually go smoothly. Recently though, an error appeared when I clicked a button on the Main Menu form. The button was supposed to open a data entry form, and had worked perfectly for years. This time though, the other form didn’t open, and an Access Expression On Click Error appeared.

Continue reading “Access Expression On Click Error for Form Button”

Fun at MVP Canada Day 2017

Yesterday, I went to the MVP Community Connection 2017 event at Microsoft Canada. It’s certainly in a convenient location – about a 5 minute drive from my house!

There are about 200 MVPs in Canada, and it looked like about 100 people at the event. They opened up the walls between three adjacent meeting rooms, and we were able to clearly see the presentations on the screen in each section.

Continue reading “Fun at MVP Canada Day 2017”