Access Solutions

3 Useful Tips to Secure Forms and Codes in MS Access

In this article we look at ways to secure Forms and Code we use in an Ms Access Application There are multiple options available to an Access user for securing the design of their forms, reports, codes, etc. One might attempt to make use of the permissions for securing the two, but it is important to note that Visual Basic is not supported by permissions. You can prevent users by looking at your forms and code designs by not removing the Read Design and The Modify Design permissions. By...

Read more »

How to Add Birthday Reminders in Your Access Database

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...

Read more »

How to Quickly Duplicate Records in Your Access

Learn how you can create a VBA function that allows you to copy certain data from previous records with just a click of a button. No need to repeatedly type the same things. Have you ever had an experience where you need to enter a new record in Access that has exactly the same set of values with a previous record except for one field? It can be tiresome, right? This tutorial will teach you how you can create a function that with a click of a button, you can copy certain values of a...

Read more »