Microsoft Access Database Tutorial: Access Combo Boxes Working Dynamically

Microsoft Access Database Tutorial: Access Combo Boxes Working Dynamically

Take a look at this 5 minute video about Access combo boxes in a form which is dynamically linked together so when a value is selected from the first control the second combo box dynamically filters as a sub list.

httpv://www.youtube.com/watch?v=pMiJHhjzC8Y&feature=related

Microsoft Access Database Tutorial: Access Combo Boxes Working Dynamically

The narrator is correct on several fronts when he mentions that Access combo boxes in a form is a highly sought after requirement and is not a standard feature to Microsoft Access!

You can use either VBA code (as demonstrated) or use an Access macro using the ‘Requery’ action command. Either way, there is little programming to cover here.

access combo boxesAlso, you will need to refine it further which could include removing the current value from the second combo box each time a new item is selected from the first (as mentioned) making your Access combo boxes really friendly.

Take the time to learn about good form designs and to help you along, I have an eBook on just the subject: How to build Access forms.

Microsoft Access Database: Customize Access 2010 Ribbon Bar – Part 2

Microsoft Access Database: Customize Access 2010 Ribbon Bar – Part 2

In part 1, I introduced you to how you can easily customise the Access 2010 Ribbon Bar which was a video tutorial showing the simple steps.

In this final part, I’m going to explain very quickly how one can bind a Ribbon bar to either a form or report as opposed to the application (as previously explained).

It requires the following steps:

  1. Creating a special ‘system’ table.
  2. Creating some XML code using an editor.
  3. Setting a property to bind Ribbon Bar.

Each step can be covered in much more detail than this blog and will be available as an EzineArticle in due course but for now, here’s the overview.

Microsoft Access Database: Customize Access 2010 Ribbon Bar – The Steps

Customising the Access 2010 Ribbon bar requires Continue reading “Microsoft Access Database: Customize Access 2010 Ribbon Bar – Part 2”

Microsoft Access Database: Customize Access 2010 Ribbon Bar – Part 1

Microsoft Access Database: Customize Access 2010 Ribbon Bar – Part 1

This is the first part on how to customize Access 2010 ribbon bars which is now built into Microsoft Access (via Options). It’s a quick 1 minute video tutorial covering the simple basics.

httpvh://www.youtube.com/watch?v=I1UXIKorUrg

Microsoft Access Database: Customize Access 2010 Ribbon Bar – Part 1

This utility still generates an XML file which can be opened (once you export the changes) and then edited directly and save the need to download a dedicated editor tool as the case with the previous version (2007).

access 2010 ribbonCustomizing the Access 2010 ribbon bar has other benefits too as it can be bound to a single form or report that will be my own part 2 video coming soon.

7 Reasons Why You Would Use Access Database VBA In Your Application – Part 2

7 Reasons Why You Would Use Access Database VBA In Your Application – Part 2

So here are the remaining 3 (of 7) reasons why you should use Access database VBA in your application.

  1. Manage more powerful procedures that Microsoft Access macros lack or is limited by creating references and links with other proccesses including custom built functions.

  2. Allows you to communicate with other applications and across platforms increasing the seamless power of Access VBA (Visual Basic for Applications).

  3. You can gracefully handle errors (if or when they happen) and will happen from time to time allowing you flow and manage unexpected exceptions (errors) allowing code to continue and flow.

To view the first 4 reasons, take a look at my previous part 1 post.

7 Reasons Why You Would Use Access Database VBA In Your Application – Part 2 of 2

You do not need to be a programmer to learn Access database VBA (but it helps if you have some knowledge).

The more important factor in order to successfully program with Access is to be knowledgeable within the framework of Microsoft Access generally (namely tables, queries, forms, reports and macros) and know its powerful features to identify where VBA should take over and improve the functionality.

I invite you to keep up to date with my articles and eBooks which cover a lot of details and you can find out the basics of Microsoft Access Database VBA Programming here.

7 Reasons Why You Would Use Access Database VBA In Your Application – Part 1 of 2

7 Reasons Why You Would Use Access Database VBA In Your Application – Part 1 of 2

Some of my subscribers send me emails regarding learning about Access database VBA and when they should use it. So I’ve written the first part (of two) given you 7 reasons why.

access database vba


First thing to note and that is it’s not an exclusive component to Microsoft Access and that is also is available and compatible with other Microsoft Office applications including Microsoft Excel, Microsoft Word and Microsoft Outlook.


Access VBA has the power to communicate with other applications beyond the Microsoft Office product range too and can Continue reading “7 Reasons Why You Would Use Access Database VBA In Your Application – Part 1 of 2”

Microsoft Access Security Warning – How To Disable This Warning (Access 2007 / 2010)

Microsoft Access Security Warning – How To Disable This Warning (Access 2007 / 2010)

This quick 2 minute video tutorial shows you how to handle Access security warning for version 2007 (which is the similar for Microsoft Access 2010).

Take a look…

Disable Microsoft Access Security Warning

httpv://www.youtube.com/watch?v=hvxR4xdL7xc&feature=related

Microsoft Access Security Warning – How To Disable This Warning (Access 2007 / 2010)

In this tutorial, handling Access security warning is a simple on and off switch via the trusted locations setting  (Access options). This practice is fine if you are the author or you know who the author is and therefore safe to run.

access security warningBut you are open to a potential macro virus threat if you lower this setting (to the lowest) that clearly states that is ‘not recommended‘. Consider instead learning to store Access database files in a trusted located folder (which is also available in Access options) and this will keep your current macro settings enforced but allow the folder location as the exception folder and allow instant access and bypass the Access security warning.

Want more help? why not get in contact with for a 30 minute personal consultation on anything Microsoft Access.

Microsoft Access Database – 5 Useful Tips When Building Access Forms

Microsoft Access Database: 5 Useful Tips When Building Access Forms

Microsoft Access Database - Microsoft Access FormsBuilding Access forms is a fun part of the Microsoft Access database build plan but it’s also the most challenging and can be time consuming too especially when you lose track of time getting carried away with all the fun

yes, it’s fun for me anyway!

Here are my 5 useful tips when building Access forms which are designed to help speed up your Access database application as this is one of the biggest areas which can slow that database system down.

  1. What type of Microsoft Access form are your building? Will it be a data entry form or a read only form? If you are going to create Continue reading “Microsoft Access Database – 5 Useful Tips When Building Access Forms”

Microsoft Access Joins – The Benefits Of Using The Outer Join

Microsoft Access Joins – The Benefits Of Using The Outer Join

One of the strengths to running reports is the ability to control Microsoft Access joins and in this case using an ‘Outer Join’ or a Left or Right join you now have the extra scope to find non matching records across two or more tables in an Access database.

Here’s a a three minute demonstration of how to set an Access join (Outer join).

httpvh://www.youtube.com/watch?v=87b2w-i1i7c

Microsoft Access Joins – The Benefits Of Using The Outer Join

access joinsIn this video, a useful mention for Access joins is to apply the ‘Is Null‘ criteria to filter out matching records and leaving you with non-matching records as the case with customers to order relationship yet to place their first order.

 

To learn more about the different types of Access joins and their properties, I have written an eBook called Understanding Access Database Relationships and is a must read for your database knowledge and design plans.