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...
Read more »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...
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...
Read more »Learn how you can create a VBA function that will allow you to save your Access Report as PDF with just a click of a button. No need to go to the Access Ribbon every time! Access Reports can be manually saved as PDF file. All you have to do...
Read more »A login form is a must for databases that contain sensitive information. Follow the steps below so you can create your own login form to protect your database from invalid access. Download Now If you want to start to use the feature as soon as...
Read more »“Cleaning” information before you import it into your database is pretty standard – after all, one of the reasons you’ve started to use a database is so that you can predictably query that database for set criteria right…right? So how you handle...
Read more »Exporting information from Microsoft Access is incredibly easy – assuming you only want to produce a single export file. But what do you do when you need to split a query (or table) into multiple export files? For example, if you need to export a...
Read more »We’ve said it before, but it’s worth repeating - linked tables can be really useful in your databases for a number of reasons. But one big drawback of linked tables is performance – running queries against them, especially if they aren’t Microsoft...
Read more »If you’ve ever needed to produce a delimited list of field/query values alongside other information from your database you’ll know it can be challenging at best – and a task most people think isn’t going to be possible. If, for example, you’ve been...
Read more »Linked tables can be fantastically useful (although not all the time of course) – particularly when you're dealing with external info that regularly changes. A typical example might be when a supplier gives you access to their current monthly price...
Read more »