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

Amazon S3 Test for Colouring Book Day

Long ago, I set up an Amazon S3 account, to use their low-cost storage for some of my downloadable files. Today I logged in again, to see what was stored there. Apparently my initial enthusiasm wore off quickly, because there was just one lonely file. So, to get started again, I made a test file that you can download – the link is below. And no, it’s not in Excel!

Continue reading

Posted in Computer tips | Leave a comment

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

Posted in Microsoft Office Tips | Leave a comment

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

Posted in Excel Consulting | Leave a comment

Links in Outlook Email Not Working

You probably get lots of email messages, and a good portion of those have links in them. Maybe a co-worker wants you to look at an online article, or a client sends you a link to check.

I get lots of emails like that, so it was alarming to get this message in Outlook recently, when I clicked a link.

Continue reading

Posted in Microsoft Office Tips | Leave a comment

Name That Office Gadget

In my Excel newsletter last week, I posted the picture below. These are 8 gadgets that I found in the drawers and shelves and other dark corners of my office, while decluttering it.

Do you recognize any or all of them? Some might be easy, but I had to do an online search for office gadget number 5, because I couldn’t remember what it was! And even with Google’s help, it was hard to find.

Continue reading

Posted in office gadgets | 2 Comments