Access Queries: Date Criteria May Not Always Work with MS Access Query

Learning about ms access query  is the key to a good database management system as it is the heart of any database application.

There are many ways and questions to ask a database using queries and mastering the special conventions and criteria will pay dividend and avoid silly mistakes, illogical record set results and even errors.

One of the more commonly used criteria and prone to errors (if misunderstood) is the date/time data type and it’s conventions.

Take a look at the ms access query below showing orders before the year 2016 and the design of the

query which suggested a date range from 1st January 2016 to 31st December 2016.https://www.accessdatabasetutorial.com/https://www.accessdatabasetutorial.com/

The criteria for the above shows >=#01/01/2016 < #31/12/2016# which will not actually return the correct range and instead show what’s known as logical errors (dates outside the range). Continue reading “Access Queries: Date Criteria May Not Always Work with MS Access Query”

How to create an embedded macro?

image13An embedded macro is a macro that is not displayed in the Navigation Pane under Macros; it is stored in the event properties of forms, reports, or controls. This can make your access database easier to manage because you don’t need to monitor separate macro objects that contain macros for a form or a report. To create an embedded macro, follow the steps below:

  1. Open the form or report that will contain the macro in Design view or Layout view. To open a form or report, right-click it in the Navigation Pane, and then click Design View or Layout View.image7
  2. If the property sheet is not yet displayed, press F4 to display it. Continue reading “How to create an embedded macro?”

What’s the new Macro Features from the release of Access database 2010?

image2

In previous versions of Access database, many usually used functions could not be executed without writing VBA code. With the release of Access database 2010, new features and macro actions have been added to help remove the need for code. This makes it less demanding to add functionality to your database and helps make it more secure.

  • Embedded macros: You can now embed macros in any of the events given by a form, report, or control. An embedded macro is not displayed in the Navigation Pane; it becomes part of the form, report, or control in which it was created. If you make a duplicate of a form, report, or control that has embedded macros, the macros are also present in the duplicate.

Continue reading “What’s the new Macro Features from the release of Access database 2010?”

Microsoft Access Database Blog – Six Years On

Microsoft Access Database Blog – Six Years On

Wow! It’s been nearly six years of providing you with MS Access database blogs and I wanted to say a big thank you to all you, the subscribers and of course those who entrusted me by purchasing one of my e-products and e-books.

If this is your first visit to my blog then welcome 🙂 Take a look at this blog site and browse the history by selecting the Archive ‘drop-down’ box by month.

microsoft-access-database-blog-site

There are over 300 posts and several ways to navigate through the archives by clicking a category, selecting a month or using the recent posts feature.

MS Access Database Blog – Six Years On

Remember, to sign up for your free weekly tips and e-book. 

If you want to know more detail or like some of my e-product utilities, why not take a chance and purchase them? In fact, there’s no risk at all as I provide a full money back guarantee plus a 30-day email support to help you through the learning curve (which is not really too steep!).

Once again, a big thank you to all for visiting my MS Access database blog 🙂