Access Solutions

How and When to Use Quotation Marks In MS Access

Both users and developers at times use Quotation Marks while working with Access database. In this article we will learn such use case scenarios in detail. MS Access developers have regularly used Quotation marks for several purposes including most notably in SQL statements. Let look at some key situations where you need to use Quotation Marks: When a user wants to specify criteria for any domain aggregate function. When specifying or using criteria for Find method. When the user...

Read more »

How to Link MS Access 2016 with Data from Dynamics 365

In this article we look at linking MS Access with Microsoft’s cutting edge Dynamics 365 ERP platform to allow data synchronization. Microsoft allows users to link their MS Access data with Microsoft Dynamics 365, a powerful business management tool based on an intelligent cloud application that integrates ERP (Enterprise Resource Planning) modules in a single software package. Given the fact that Dynamics 365 spans across several modules like finance, sales, and CRM (Customer Relationship...

Read more »

How to Avoid Unexpected Blank Forms in MS Access

In this article we will look at chasing down the causes of unexpected blank form and then look at workarounds to resolve such issues. Often MS Access forms present a picture which a user doesn’t want to see when working on a deadline – a blank page with no controls or data in the design view. Sometimes MS Access forms entire detail section disappears, showing nothing but white blank space. An empty form does nothing but confuses and frustrates the users. This puts a pause on their...

Read more »