1. Урок 1. 00:03:09
    Course Overview
  2. Урок 2. 00:03:00
    Setup Tasks
  3. Урок 3. 00:00:59
    How to Contact Me
  4. Урок 4. 00:01:52
    View Database Table and Forms - Review the Goal
  5. Урок 5. 00:07:42
    Create Your First VBA Subroutine!
  6. Урок 6. 00:03:25
    Fix a Syntax Error and Take Over the Keyboard
  7. Урок 7. 00:04:29
    Use an IF Statement and DoCmd
  8. Урок 8. 00:06:14
    Use ElseIf and a Select Statement
  9. Урок 9. 00:10:00
    Runtime Errors, Error Traps and Program Stops
  10. Урок 10. 00:03:49
    Break Into Programs and Infinite Loops
  11. Урок 11. 00:04:07
    Section 2 Conclusion and Review
  12. Урок 12. 00:05:55
    On Open Event, Me Keyword and Orderby
  13. Урок 13. 00:05:26
    Subroutines for Form Controls, VBA Editing Shortcuts
  14. Урок 14. 00:10:25
    Modify Subroutines to Sort DESC, More Error Handling
  15. Урок 15. 00:01:31
    Section 3 Conclusion and Review
  16. Урок 16. 00:06:36
    Expanding the Keydown Subroutine
  17. Урок 17. 00:06:14
    Using Public Variables
  18. Урок 18. 00:06:37
    Building the Search Criteria
  19. Урок 19. 00:08:41
    Field Names and Reserved Words
  20. Урок 20. 00:05:38
    Using a Recordset and Bookmarks
  21. Урок 21. 00:11:07
    Enhancing Our Instant Search
  22. Урок 22. 00:03:13
    Section 4 Conclusion and Review
  23. Урок 23. 00:06:18
    Open Another Form with a Button Click
  24. Урок 24. 00:04:16
    Send Data to the Other Form
  25. Урок 25. 00:06:07
    Modify a Form to Utilize Data Sent to it.
  26. Урок 26. 00:07:10
    Intro to SQL and Using SQL in the Recordsource
  27. Урок 27. 00:05:28
    Locate Same Record When Returning from the Form
  28. Урок 28. 00:06:35
    Modify the Form to Remember the Sort
  29. Урок 29. 00:04:51
    Create a Prompt to Save Changes
  30. Урок 30. 00:04:31
    Activate the Add Customer Button
  31. Урок 31. 00:09:55
    Testing for a Blank Record
  32. Урок 32. 00:06:03
    Activate the Delete Button
  33. Урок 33. 00:02:32
    Section 5 Conclusion and Review
  34. Урок 34. 00:08:30
    Setup Rowsource for Dropdown Filters
  35. Урок 35. 00:07:50
    Enable Editing In the Dropdown Filters
  36. Урок 36. 00:08:26
    Set Dropdown Rowsources on the Fly
  37. Урок 37. 00:07:36
    Create a Subroutine to Build All the Filters
  38. Урок 38. 00:03:30
    Use the AfterUpdate Event to Rebuild the Filter
  39. Урок 39. 00:04:44
    Setup the Clear Filter Buttons
  40. Урок 40. 00:08:31
    Save the Filters when Closing the Form
  41. Урок 41. 00:03:03
    Section 6 Conclusion and Review
  42. Урок 42. 00:03:01
    Inspect the Tables and Review the Goal
  43. Урок 43. 00:06:45
    Creating a Summary Table with a Query
  44. Урок 44. 00:06:17
    Building Our First Function and Saving Queries to VBA
  45. Урок 45. 00:04:31
    Add a Delete Query and Create a Test Macro
  46. Урок 46. 00:06:26
    Restructure Tables and Add a Second Query to our VBA Function
  47. Урок 47. 00:06:07
    Figure Out How to Get the Days Between Orders
  48. Урок 48. 00:10:07
    Doing the Steps With A Recordset
  49. Урок 49. 00:07:05
    Calculate the Average Days Between Orders
  50. Урок 50. 00:10:40
    Plug the Average Days into the Report Table
  51. Урок 51. 00:02:46
    Section 7 Conclusion and Review
  52. Урок 52. 00:01:40
    View the Example of Removing the Nav Pane and Ribbon
  53. Урок 53. 00:07:17
    Create the HideMenu subroutine
  54. Урок 54. 00:04:16
    Call the HideMenu Subroutine from our Form
  55. Урок 55. 00:04:55
    Make the Subroutine Toggle the Menus
  56. Урок 56. 00:04:39
    Create a Startup Subroutine and an Autoexec Macro
  57. Урок 57. 00:05:55
    Prevent Closing the Form and Activate the Exit Button
  58. Урок 58. 00:02:03
    Section 8 Conclusion and Review
  59. Урок 59. 00:01:58
    Overview and Goal
  60. Урок 60. 00:02:58
    Create Delete Subroutine and Make First Changes to SummRpt Function
  61. Урок 61. 00:02:56
    Backup the SummRpt Function and Make the First Changes
  62. Урок 62. 00:04:46
    Pull a Query from VBA Back to Design, Change It and Update VBA
  63. Урок 63. 00:04:51
    Use TableDefs to Add a Field to a Table
  64. Урок 64. 00:04:22
    Use TableDefs to Create a Table and Add FIelds to it.
  65. Урок 65. 00:02:51
    Make Final Changes and Test the Modified Function
  66. Урок 66. 00:03:15
    Overview of the Tables in the Subforms Database
  67. Урок 67. 00:02:19
    Overview of the Forms in the Subforms Database
  68. Урок 68. 00:06:39
    Add OrderList as a Subform to the Customer Form.
  69. Урок 69. 00:04:48
    Using an On Exit Subroutine to Capture the Order Number You Were On
  70. Урок 70. 00:04:38
    Pass the Order Number to the Go To Order Button
  71. Урок 71. 00:05:23
    Open the Orders Form and Move to the Specified Order
  72. Урок 72. 00:05:33
    Create Code to Return to the Customer Form
  73. Урок 73. 00:04:52
    Setup the OrdProdList Subform
  74. Урок 74. 00:04:25
    Create a Total in the Subform
  75. Урок 75. 00:04:21
    Update the Subtotal and Order Total
  76. Урок 76. 00:05:01
    Add a New Product to the Order
  77. Урок 77. 00:09:52
    Create the Add Order Subroutine and Post a New Order
  78. Урок 78. 00:04:50
    Get the New Order Number and Open the Order Form
  79. Урок 79. 00:03:00
    Review, Conclusion and Future Enhancements
  80. Урок 80. 00:03:01
    Import Customer List Form and Rename it as CustPopup
  81. Урок 81. 00:04:59
    Prepare the CustPopup form for use as a popup form.
  82. Урок 82. 00:06:06
    Modify the Customer Form code to Open the Popup
  83. Урок 83. 00:06:02
    Make the Popup Move to the Current Customer On Open
  84. Урок 84. 00:05:42
    Use the TAG Property to send the OrdCust Value Back from the Popup Form
  85. Урок 85. 00:03:11
    Add a Customer From Inside the Popup Form
  86. Урок 86. 00:01:19
    A CLASSIC situation that MUST be handled correctly
  87. Урок 87. 00:04:04
    Database Overview and Why You Want One Table
  88. Урок 88. 00:06:32
    The Code Behind the Recalc Button
  89. Урок 89. 00:05:57
    Doing Total Queries and Making the Subroutine a Function
  90. Урок 90. 00:05:39
    Congratulations and Next Steps