Microsoft Access A to Z: Creating custom functions with VBA
ฝัง
- เผยแพร่เมื่อ 14 ต.ค. 2024
- This short screencast covers how to create calculated fields using built-in Access functions such as Date and Int to calculate a person's age in years, as well as how to create custom functions using VBA. In this process the Expression Builder is used to reveal/find the existing built-in functions within Access and the Visual Basic Editor (VBE) is used to create a new custom function that is used to make a calculation in a query.
All of my TH-cams can be found at: learncs.w3spac...
The very best of cheat sheets. Wish I knew this months ago.
You're very welcome. See all of my TH-cams organized at learncs.w3spaces.com
I always find myself back here! Thanks Lisa
You're very welcome. See all of my TH-cams organized at learncs.w3spaces.com
Excellent video. I hope you’ll do more on Vba functions, especially custom ones.
This book might be old, but I thought it was one of the best ones for VBA programming: www.amazon.com/Microsoft-Office-Access-2007-VBA/dp/0789737310/ref=sr_1_20?keywords=vba+access+programming&qid=1668112735&sprefix=vba+access%2Caps%2C264&sr=8-20
VBA really hasn't changed a whole lot for a very long time given Microsoft's strategy has been to push C# vs. Visual Basic so old books still work pretty well for this.
thanks
Ty! See all of my youtubes organized at learncs.w3spaces.com