Sawstem, Gaborone (2026)

Name: Sawstem
Address: Gaborone, BW
Telephone: +26777657925

10/04/2025

New Video on YouTube:Part 2 - How to Open a Record from a Subform in Microsoft Access Using VBA | Edit Student Form. !
Learn how to open a specific student record from a subform and display it in a separate edit form using VBA in Microsoft Access. In this tutorial, I’ll walk you step-by-step through the process of creating the button, writing the VBA code, linking forms by StudentID, and making your database more user-friendly.

We’ll cover:
• How to create a button in a subform
• Writing VBA to open a record in another form
• Filtering records using DoCmd.OpenForm
• Handling null values and showing error messages
• Building the Edit_Student_frm from scratch in Form Design
• Testing and verifying the functionality

Perfect for beginners and intermediate Access users looking to make their student databases more dynamic and functional.

If this helped you, don’t forget to like, subscribe, and drop your questions in the comments!

Learn how to open a specific student record from a subform and display it in a separate edit form using VBA in Microsoft Access. In this tutorial, I’ll walk ...

08/04/2025

New Video on YouTube:How to Create a Dynamic Search Box in Microsoft Access | Real-Time Search Tutorial !
In this tutorial, I’ll show you how to create a dynamic search box in Microsoft Access that updates search results in real time as you type — no buttons required! This feature helps users quickly find records without waiting for search results to load. I’ll guide you step-by-step through the process and explain the VBA code behind it.

For the full code you can use in your Access database
Message me to send you the code as YouTube doesn’t allow to past code in the video description!

This VBA script allows you to filter student records dynamically by first name, last name, or both in real time. It also includes a result counter that updates as you type.

Don’t forget to like, subscribe, and hit the bell icon for more Access tips and tutorials!

⸻

Hashtags:

Microsoft Access, Access tutorial, VBA, Dynamic search in Access, Real-time search box, Access database tutorial, Learn VBA, VBA tutorial, Access form filtering, Search filter in Access, Real-time filtering in Access, Microsoft Access tutorial, Access search box tutorial, VBA for beginners, Access form tutorial, Database filtering, Access form design, Access development, VBA for Access, Access tips and tricks, How to use VBA in Access, Build a search box in Access, Access dynamic search feature, Access tips, Search box in Access.

In this tutorial, I’ll show you how to create a dynamic search box in Microsoft Access that updates search results in real time as you type — no buttons requ...

Address

Gaborone

Telephone

+26777657925

Website

https://sawstem.org/

Alerts

Be the first to know and let us send you an email when Sawstem posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Contact The Business

Send a message to Sawstem:

Sawstem