Courtney Owen | Author at Microsoft 365 Blog Microsoft 365 brings together Office 365, Windows 10, and Enterprise Mobility + Security. It delivers a complete, intelligent, and secure solution to empower people. Tue, 16 Aug 2022 21:05:33 +0000 en-US hourly 1 https://wordpress.org/?v=6.6.2 http://approjects.co.za/?big=en-us/microsoft-365/blog/wp-content/uploads/sites/2/2018/03/cropped-microsoft-favicon-new-32x32.png Courtney Owen | Author at Microsoft 365 Blog 32 32 Tricks for creating dropdown lists that let you select multiple items http://approjects.co.za/?big=en-us/microsoft-365/blog/2012/08/21/tricks-for-creating-dropdown-lists-that-let-you-select-multiple-items/ Tue, 21 Aug 2012 06:47:00 +0000 Our guest blogger and Excel MVP award winner, Debra Dagleish, makes it easy to create an Excel dropdown list that lets you select multiple names in one cell. The magic to her method is adding a few lines of VBA code--a trick just about anyone can learn, even if you don't know programming.

The post Tricks for creating dropdown lists that let you select multiple items appeared first on Microsoft 365 Blog.

]]>
Plug into your data: Connecting Excel to an Access database http://approjects.co.za/?big=en-us/microsoft-365/blog/2012/08/14/plug-into-your-data-connecting-excel-to-an-access-database/ Tue, 14 Aug 2012 15:59:00 +0000 Northwind Trading Company is a growing online wholesale food business. Orders from retail merchants are coming in from across the country and are being stored in an Access database. Now the marketing team needs a better way to view the mounds of data. Luckily, the same features that Excel provides for viewing and organizing information in a spreadsheet, can be used to view and organize information in an Access database. But first you need to create the connection.

The post Plug into your data: Connecting Excel to an Access database appeared first on Microsoft 365 Blog.

]]>
Automatically relink Microsoft Access tables http://approjects.co.za/?big=en-us/microsoft-365/blog/2012/08/03/automatically-relink-microsoft-access-tables/ Fri, 03 Aug 2012 08:23:00 +0000 Automating the relinking of tables just makes good sense. This is especially true if you are distributing your database to others. It can save you a lot of headaches, trouble, travel, and time. You do not have to be physically present, nor do you need to remotely access another computer. Additionally, you do not have to enter the names of your back end database(s) or your linked tables.
In this post, guest blogger Patrick Wood shows you how you can call a single procedure using just a little code to automatically relink your back-end tables, even when the database files have been moved to a different folder. The procedure will also relink the tables in multiple back-ends. And best of all, you don't have to know much about writing code to make this work.

The post Automatically relink Microsoft Access tables appeared first on Microsoft 365 Blog.

]]>