MICROSOFT ACCESS 2016 MACROS: SHOW ALL MACRO COMMANDS

The great debate of whether to use Microsoft Access VBA programming macros or the higher level of VBA code will linger on until the end of time (or realistically, Access is discontinued)!
In the meantime, most Access developers will continue to lean towards Access VBA but the majority of power users, self-taught Access designers will still embrace the ease of g using macros to automate their databases.
Microsoft Access 2016 Macros Show All Macro Commands
With the later versions of MS Access (post 2010), macros have become more powerful and flexible and with the added introduction of better web integration and the fact VBA is prohibited when publishing your database objects online, there’s now an even stronger case for macros becoming the first choice tool.

Microsoft Access 2016 Macros: Show All Macro Commands

However, not all macros are deemed safe and certain keywords have also been prohibited which by default are not visible when working in the macro design view mode.
In the design view mode for a new or existing macro (I’m using version 2016) which can be created either via the Navigation pane which makes these macros public or via a typical Access object like a form or report which will make these macros private (note the scope between the two ways macros can be created!), You will see under the ‘Design’ tab in the ‘Show/Hide‘ section, two icons with the first revealing the Action Catalog pane view and the second icon to reveal the non-safe keyword macro commands.
As I already mentioned, by default the second icon is switched off leaving only the safe macro keyword commands knowing full well any published objects will work online. When you switch this to reveal the non-safe keywords, they are very obvious with a little exclamation icon indicator appearing to the left of each no-safe macro keyword.
It confused me when I first used the newer versions as a common macro keyword called ‘SetValue‘ has been demoted to unsafe and thought this was actually been dropped and superseded by another newer keyword – but no, it was hidden!
So, normal service continues for the seasoned macro user but you may want to check out another blog post on Microsoft Access macros which leads to my ever popular eBook on How To Use Microsoft Access Macros & Automate Your Application.   Microsoft Access VBA programming

Comments

Post a Comment

Popular posts from this blog

Microsoft Access Queries: An Action Query

Image
You use this type of query to change data in tables, saving the need to manually edit records or use any of the manual tools namely,  Find  and Replace . Examples for this action could be to reset data, change prices, increase volume and correct data migration and population issues. One of the more commonly used examples is to carry out some sort of calculation and change prices for a range of products. The above example increases all products for UK suppliers by 10% using the  [Unit Price]  field containing the original price value multiplied by 1.1 (an increase by 110%). Just remember, this is an action query which means changes to any data values cannot be reversed once actioned which is why you should normally see a warning first. However, it is always a good idea to take a copy or back up of your data files before running  Microsoft Access VBA programming  of this nature. There are many other types of queries too and the more you know about Access queries, the more f
Read more

How To Run Microsoft Access On A Mac PC Using CrossOver Software – Alternative Options

Image
Firstly, let’s clarify that Microsoft Office for Mac does not include the  microsoft access database  application which is why we have to take such steps. The alternatives and work around could include: 1.  Using the free runtime version for an exectuable file only or a third party web app which is now available for the iPad so you can load Access as a viewer only should you need to just read information. 2.  Installing VMWare (or similar) which is a virtual image software tool that creates a separate instance on your Mac PC and therefore can have several versions as a quick way to restore a default environment. However, it will require you having a licenced copy of Microsoft Windows operating system whereas CrossOver has this already included 3.  Using some sort of remote access software like LogMeIn or SplashTop (which there is a free version. There are others too but the two mentioned I have used are very effective indeed but will require a live internet connection to a
Read more

Microsoft Access Tutorial: Creating A Many-To-Many Relationship

Image
Microsoft access tutorial In a relational database, a many-to-many relationship exists when a record in one table can be referenced by one or more records in another table and vice versa. You need to have two or more tables to create relationships. To link these tables, you will have to create another table (a third) which will be your interceding or junction table. Here are the steps again in creating a third table: 1.  Go to the Create tab. 2.  Click on Table Design. A new table will be opened. 3.  Create two fields (plus any additional supporting fields). NOTE:  The two key fields are going to be the primary keys from the two tables that you have created which are in effect known as secondary or foreign keys (duplicates OK). To identify the primary key from a table: Click on the existing table and select View on the upper left corner of MS Access. You can identify the primary key when you click on one of the fields and see the Primary Key button, right next to the
Read more