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 »
Learn how you can add birthday reminders to your Access database. Be informed if your client or employee’s birthday is coming up so you can send them your warm greeting.
Sending birthday greetings can be a great way to connect and strengthen relationship with a client or employee. If you're handling an Access database containing customer/employee records, it can be great to be notified from time to time if a client's or employee's birthday is coming up. In this tutorial, you will learn how...
Read more »
Split forms in Access are extremely useful. Unfortunately, they do not work when you place them inside a navigation form. Learn how you can create a VBA function that will simulate Access’ split form functionalities and make it work even inside a navigation form.
Split form allows you to have two views of your records at the same time – form view and datasheet view. It allows you to have an overview of all your records while at the same time giving you an option to view and edit them one by...
Read more »
