How to Build a CRUD App in Microsoft Access - Modern Web UI + VBA (Real Source Code)
Imranosoft
0:00 / 0:00
How to Build a CRUD App in Microsoft Access - Modern Web UI + VBA (Real Source Code)
151 просмотр · 2 нед. назад
Imranosoft
72 подписчика
151 просмотр · 2 нед. назад
Download the Customer Desk demo:
https://www.imranosoft.com/products/l...
How do you build a CRUD app in Microsoft Access that looks modern? This video shows a complete one: Customer Desk, with 25,000 fictional accounts that you can search, filter, create, edit, archive and delete. Access keeps the data, the business rules and the transactions; the screen is a modern web page inside the form, joined to your VBA with LiteView2. The real VBA source code is shown step by step.
Get the Customer Desk package (free, nothing to install) and the 30-day LiteView2 trial: https://www.imranosoft.com/products/l...
WHAT YOU WILL LEARN
Read: how a list of 25,000 rows, with search and filters, loads fast from Access into the page
Create and update: saving a whole account and its contacts in one transaction
Delete and archive: letting Access enforce the rules and show a clear message
How to put a browser on an Access form and let the page call your VBA with one line of JavaScript
How to start it all registration-free, with no installer
CHAPTERS
0:00 Introduction
1:06 The result
1:44 How the pieces fit
2:44 The package
3:23 Starting LiteView2
4:26 A browser on the form
5:46 Behaving inside Access
6:33 The page calls Access
7:48 Access sends data
9:06 Create and update
10:29 Rules and errors
11:25 Lessons learned
12:24 Recap
REQUIREMENTS
Windows 10 or 11, Microsoft Access 2016 or later (or Microsoft 365), 32-bit or 64-bit, and the Microsoft Edge WebView2 Runtime (already part of current Windows).
MORE
Cookbook: https://www.imranosoft.com/products/l...
5-minute quickstart: https://www.imranosoft.com/quickstart...
HTML forms for Access tutorial: https://www.imranosoft.com/vba-javasc...
The narration is a synthetic (text-to-speech) voice. Harbor Point Supply and every company name, person and number in this video are fictional.
#MicrosoftAccess #CRUD #VBA