Behind the Scenes in My Online Business
Yesterday, while I was working on monthly reports in Microsoft Access, I noticed that the standard warning messages weren’t appearing. Here’s how I fixed the problem, with an easy solution. And it’s not one of the 2 suggestions that you’ll see in most places!
Continue reading “How to Fix Microsoft Access Warning Messages Not Working”
To make a Microsoft Access report easy to use, enter date range start and end dates on an Access form. Then, click a button to see all the sales orders in the selected date range.
Continue reading “Microsoft Access Query-Date Range Criteria-Form Boxes”
Microsoft Office 365 got a “New Look” today, so I changed a few settings in Excel and Outlook. That reminded me of a quick way to check email headers in Outlook, without opening the message.
Continue reading “How to Check Email Internet Headers in Microsoft Outlook”
In December, as usual, I did a review of the past year, and made a business plan for the new year. Instead of adding a long list of new tasks and projects, my goal this year is to “Let It Go”. I’ve cut out, or cut back, on old projects, and not planned any new ones.
To keep track of what I’ve posted on my Contextures Excel tips website, I use Microsoft Access. You can’t do everything in Excel! In that database, I enter a bit of information about each page, and there is a query to create RSS feed entries. I paste those into an XML file, and upload it. Here’s how I create the entries, in case it helps you!
Continue reading “Create RSS Feed Entries in Microsoft Access”
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.
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.
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.
