Welcome to Access Developer 40. Total running time so far is 123 minutes plus 82 minutes of FREE bonus material.

Lessons

•  00. Introduction (5:54)
•  01. Event Countdown 1 (54:15)
•  02. Event Countdown 2 (28:30)
•  03. Custom Color Editor (21:25)
•  04. Conditional Formatting VBA 1 (24:16)
•  05. Conditional Formatting VBA 2 (16:51)
•  06. User Defined Types(10:57)
•  07. Windows Font Dialog (30:36)
•  08. Custom Font in a Report (11:46)
•  09. What's Next? (1:44)

Database Files

•  Databases For D40

Notes

• The maximum number of conditional formatting items you can have in Microsoft Access is 49. If you try to add more than that, you'll get the error "Run-time error '7966': The format condition number you specified is greater than the number of format conditions."

TechHelp Links

• Default Value: https://599cd.com/Default
• ISO Date Format: https://599cd.com/ISO
• Tab Stop, Order, Cycle: https://599cd.com/TabOrder
• Modal & Popup: https://599cd.com/ModalPopup
• Close Form: https://599cd.com/CloseForm
• Value From a Form: https://599cd.com/FormName
• Don't Delete Data: https://599cd.com/DontDelete
• MsgBox: https://599cd.com/MsgBox
• Conditional Formatting: https://599cd.com/Conditional
• If Then: https://599cd.com/IfThen
• DCount: https://599cd.com/DCount

D40 Links

• Access Developer 16: https://599cd.com/ACD16
• Center Vertically: https://599cd.com/CenterVertically

Resources

• Full Course Description Page
• Topic Outline
•  Handbook PDF - AI Generated
•  Video ZIP File  (661 MB)
• Skills Test Quiz - Under Construction
• Certificate of Completion
• Post-Class Survey

Questions?

Please feel free to post your questions or comments below. If you have questions about a specific lesson, please specify the lesson number and the time index in the lesson where the issue occurs. Thank you!

Subscribe for Updates

If you would like to be notified whenever changes are made to this page, new lessons are posted, or comments are made, click on the subscribe button.