How to Build an On-Screen Calculator in Microsoft Access VBA - Part 6

Опубликовано: 03 Октябрь 2024
на канале: Computer Learning Zone
1,186
61

This is part 6 of my Microsoft Access on-screen calculator tutorial. We are continuing to build the calculator that we started in part 1. In today's video we're going to learn how to make the memory value persistent even if the calculator form closes and is reopened, or even if the database itself is closed and reopened. We'll look at variables and their scope, learn how to set up a public global variable, and then we'll use TempVars to store the persistent memory value. We'll learn how to bind that value to a table field. We'll also talk about tab cycle and we'll make a custom image for the background of our calculator form so it looks super cool.

PREREQUISITES:
Calculator, Part 5:    • How to Build an On-Screen Calculator ...  
Calculator, Part 5: https://599cd.com/Calculator5

NEXT VIDEO:
Calculator, Part 7: COMING SOON
Calculator, Part 7: https://599cd.com/Calculator7

BECOME A MEMBER:
YouTube:    / @599cd  
or My Site: https://599cd.com/THMember

LEARN MORE:
https://599cd.com/Calculator6

LINKS:
Variables: https://599cd.com/Variables
Scope: https://599cd.com/Scope
TempVars: https://599cd.com/TempVars
Tab Stop, Order, Cycle: https://599cd.com/TabOrder
Aesthetics: https://599cd.com/Aesthetics

RECOMMENDED COURSES:
Access Developer Courses: https://599cd.com/Developer

FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates

ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: https://599cd.com/Free1
How to Use Access in 30 Minutes: https://599cd.com/30Minutes
$1 Access Level 2: https://599cd.com/1Dollar
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter:   / learningaccess  
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...

KEYWORDS:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Onscreen calculator, calculator, on-screen calculator, local variables, global variables, public variables, variable scope, persistent values, tempvars, bind field to table, tab cycle, custom form background image

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.