Access Solutions

How to Create Your Own Split Form in Access using VBA

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

Read more »

How to Export Your Access Report to a PDF File via VBA

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 is: Open the report. Go to the Access Ribbon: External Data > PDF or XPS. Select the filename and folder path where you would like it to be saved. Click Publish and you’re done. Easy, right? However, if there is a need for you to...

Read more »