1940 To 2040 EXTENDED CUT MEMBERS ONLY Custom Two-Digit Year Handling in Microsoft Access VBA Computer Learning Zone 2026-09-20 | 1940 To 2040 EXTENDED CUT MEMBERS ONLY Custom Two-Digit Year Handling in Microsoft Access VBA
Using Option Groups in Microsoft Access: Procedure Tracking Computer Learning Zone 2023-10-05 | In this Microsoft Access tutorial, you will learn about using an option group. Option groups have many uses, including selecting an option from a list. In today's example, we're going to use it to track which step we're on in a series of procedures for a medical patient.Emily from Southaven, Mississippi (a Platinum Member) asks: I have a series of forms and procedures that need to be performed for each of my patients, in order. How can I keep track of the current step I'm on? Right now, I use a notes field but it isn't very efficient, especially when I might not see the patient for weeks and need to figure out where I left off. Is there a way to have some sort of indicator or system that will automatically help me keep track of where we're at?Silver Members & up get access to an Extended Cut of this video. Members will learn how to automatically set the option group value when the button is clicked. We'll use just a little bit of VBA code.MEMBERS-ONLY EXTENDED CUT VIDEO: youtu.be/45Hvxki7Vl0BECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: Option Group: 599cd.com/OptionGroupPREREQUISITES:Access Beginner 1: 599cd.com/ACB1Blank Template: 599cd.com/BlankRECOMMENDED COURSES:Access Expert 4: 599cd.com/ACX4FREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, option group, track progress, procedure tracking, option buttons, shipping method, option group wizard, default choice, store value, option group appearance, option group captions, step tracking, step number field, option button copying, option value, option group formatting, option group border, step tracking example, Microsoft Access tutorialQUESTIONS: Please feel free to post your questions or comments below. Thanks. Live long, and prosper.
Using Option Groups in Microsoft Access: Procedure Tracking #msaccess #shorts #database Computer Learning Zone 2023-10-05 | In today's Microsoft Access TechHelp video, you will learn about using an option group. Option groups have many uses, including selecting an option from a list. In today's example, we're going to use it to track which step we're on in a series of procedures for a medical patient.FULL VIDEO: youtu.be/l38PoVhjnsQLEARN MORE:599cd.com/OptionGroupKEYWORDS#shorts, access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, option group, track progress, procedure tracking, option buttons, shipping method, option group wizard, default choice, store value, option group appearance, option group captions, step tracking, step number field, option button copying, option value, option group formatting, option group border, step tracking example, Microsoft Access tutorialQUESTIONS:Please feel free to post your questions or comments below. Thanks.NOTE TO YOUTUBE:One minute is WAY too short, even for #shorts. Consider increasing the time to even 2 or 3 minutes. One minute? No way.
Controlling Opening Form Position in Microsoft Access with MoveSize VBA Command #shorts #msaccess Computer Learning Zone 2023-10-04 | In today's Access Learning Zone TechHelp video, you will learn how to use the MoveSize command in VBA to program and control the coordinates of forms when opening them. You will explore properties like Left, Top, Width, and Height to read and set the desired location and size of forms. This tutorial is aimed at those with prior VBA knowledge who need to maintain consistent form placement in their Access projects.FULL VIDEO: youtu.be/0lX2eAzRAjoLEARN MORE:599cd.com/MoveSizeKEYWORDS#shorts, access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, MoveSize, WindowTop, WindowLeft, WindowHeight, WindowWidth, VBA command, form coordinates, form placement, consistent form placement, Microsoft Access tutorial, form location, form size, MoveSize in Access, form properties, Left property, Top property, Width property, Height property, reading window properties, setting form location, setting form size, control form opening, VBA programming, form design, design changes, Access form opening, programming form coordinates, Access form coordinates, Access form location, Access form sizeQUESTIONS:Please feel free to post your questions or comments below. Thanks.NOTE TO YOUTUBE:One minute is WAY too short, even for #shorts. Consider increasing the time to even 2 or 3 minutes. One minute? No way.
Controlling Opening Form Position in Microsoft Access with the MoveSize VBA Command Computer Learning Zone 2023-10-04 | In this Microsoft Access tutorial, you will learn how to use the MoveSize command in VBA to program and control the coordinates of forms when opening them. You will explore properties like Left, Top, Width, and Height to read and set the desired location and size of forms. This tutorial is aimed at those with prior VBA knowledge who need to maintain consistent form placement in their Access projects.Natalie from Carmel, Indiana (a Platinum Member) asks: How can I ensure that my Microsoft Access forms open in the exact location I want them to, even after making design changes? It seems like no matter what I do, Access opens the forms wherever it wants to. Is there a way to use VB code to program the form's coordinates so that it always opens in the specified location?Silver Members & up get access to an Extended Cut of this video. Members will learn how to create user-defined functions for dynamic form positioning. Whenever you save a form, the position is saved. Open it up, the position is loaded. We'll use a system settings table to keep positions for all forms in the database.MEMBERS-ONLY EXTENDED CUT VIDEO: youtu.be/R_TDmaJVwd0BECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: MoveSize: 599cd.com/MoveSizePREREQUISITES:Intro to VBA: 599cd.com/VBAStatus Box: 599cd.com/StatusLINKS:Access Save Position Template: 599cd.com/SavePosMEMBER LINKS:Open Form Right: 599cd.com/OpenFormRightCodeSystem Defaults: 599cd.com/SystemDefaultsSystem Settings: 599cd.com/SystemSettingsCodeForm Positioning: 599cd.com/FormPositionCodeRECOMMENDED COURSES:Access Developer 12: 599cd.com/ACD12Access Developer Courses: 599cd.com/DeveloperFREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, MoveSize, WindowTop, WindowLeft, WindowHeight, WindowWidth, VBA command, form coordinates, form placement, consistent form placement, Microsoft Access tutorial, form location, form size, MoveSize in Access, form properties, Left property, Top property, Width property, Height property, reading window properties, setting form location, setting form size, control form opening, VBA programming, form design, design changes, Access form opening, programming form coordinates, Access form coordinates, Access form location, Access form sizeQUESTIONS: Please feel free to post your questions or comments below. Thanks. Live long, and prosper.
Create a HasValue Function in Microsoft Access VBA to Check Null, Empty Values #database #msaccess Computer Learning Zone 2023-10-03 | In today's Access Learning Zone TechHelp video, you will learn how to create a custom HasValue function using VBA. This function is specifically designed to check for empty and null values in short and long text fields. This function is great for when you don't know what type of field you're dealing with, and you're tired of always checking for both.FULL VIDEO: youtu.be/2WFB_Xq0_wkLEARN MORE:599cd.com/HasValueKEYWORDS#shorts, access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, HasValue function, Microsoft Access tutorial, VBA, custom function, check null values, check empty values, short text field, long text field, checking field types, deleting values, button demonstration, step-by-step walkthrough, developer courses, VariantQUESTIONS:Please feel free to post your questions or comments below. Thanks.NOTE TO YOUTUBE:One minute is WAY too short, even for #shorts. Consider increasing the time to even 2 or 3 minutes. One minute? No way.
Create a HasValue Function in Microsoft Access VBA to Check Null, Empty Values Computer Learning Zone 2023-10-03 | Create a HasValue Function in Microsoft Access VBA to Check Null, Empty ValuesIn this Microsoft Access tutorial, you will learn how to create a custom HasValue function using VBA. This function is specifically designed to check for empty and null values in short and long text fields. This function is great for when you don't know what type of field you're dealing with, and you're tired of always checking for both.Mason from Schaumburg, Illinois (a Platinum Member) asks: How can I understand the difference between an empty value and a null value in Microsoft Access? I have a button on a form to check if a field is blank, but when a user deletes a value in a record, I noticed that the behavior differs for short text fields (which become null) and long text fields (which become empty). Can you explain what's going on?BECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: HasValue: 599cd.com/HasValuePREREQUISITES:Intro to VBA: 599cd.com/VBANull: 599cd.com/NullZero Length: 599cd.com/ZLSIf Then: 599cd.com/IfThenCreate Function: 599cd.com/CreateFunctionCODE VAULT::HasValue Function: 599cd.com/HasValueCodeRECOMMENDED COURSES:Access Developer Courses: 599cd.com/DeveloperFREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, HasValue function, Microsoft Access tutorial, VBA, custom function, check null values, check empty values, short text field, long text field, checking field types, deleting values, button demonstration, step-by-step walkthrough, developer courses, VariantQUESTIONS: Please feel free to post your questions or comments below. Thanks. Live long, and prosper.
Microsoft Access VBA Loops: A Comprehensive Overview & Summary Computer Learning Zone 2023-10-02 | In this Microsoft Access tutorial, we are going to review all of the different VBA loop types that we learned throughout the rest of the Loops series. We are going to go over the pros and cons and deliver a quick summary of each Loop.BECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: VBA Loops: 599cd.com/VBALoopsVBA LOOPS SERIES:For Next: 599cd.com/ForNextWhile Wend: 599cd.com/WhileDo While: 599cd.com/DoWhileDo Until: 599cd.com/DoUntilFor Each: 599cd.com/ForEachNested Loops: 599cd.com/NestedLoopsSummary: 599cd.com/LoopsRECOMMENDED COURSES:Access Developer Courses: 599cd.com/DeveloperFREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, microsoft access, access tutorial, access VBA loops, VBA loops in access, loops in access VBA, access programming, access loop types, loop types in access, for next loop in access, while wend loop in access, do while loop in access, do until loop in access, for each next loop in access, access VBA, microsoft access VBA, access database, access programming tutorial, access loop examples, access loop tutorial, access loop concept, access loop pros and cons, access loop best practices, access loop explained, access loop overview, access loop summary, access loop tips, access loop tricks, access loop techniques, access loop implementation, access loop demonstration, access loop usage, access loop scenario, access loop decision making, access loop control, access loop efficiency, access loop examplesQUESTIONS: Please feel free to post your questions or comments below. Thanks. Live long, and prosper.
Nested Loops in Microsoft Access VBA: Build Multiplication Tables & Simulate D&D Dice Rolls Computer Learning Zone 2023-09-29 | In this Microsoft Access tutorial, you will learn how to effectively use nested loops. We will start by introducing what nested loops are and why they are useful in Microsoft Access. Then, we will look at the structure of nested loops, understanding the interaction between the inner and outer loop. We will build some multiplication tables and simulate dice rolls with a D&D character stat generator. Fun stuff!BECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: Nested Loops: 599cd.com/NestedLoopsPREREQUISITES:Intro to VBA: 599cd.com/VBAFor Next: 599cd.com/ForNextWhile Wend: 599cd.com/WhileRandom: 599cd.com/RandomLINKS:DieRoll Function: 599cd.com/DieRollCodeFormat: 599cd.com/FormatString Functions: 599cd.com/StringArrays: 599cd.com/ArraysVBA LOOPS SERIES:For Next: 599cd.com/ForNextWhile Wend: 599cd.com/WhileDo While: 599cd.com/DoWhileDo Until: 599cd.com/DoUntilFor Each: 599cd.com/ForEachNested Loops: 599cd.com/NestedLoopsSummary: 599cd.com/LoopsRECOMMENDED COURSES:Developer Courses: 599cd.com/DeveloperSYNTAX:For X = 1 to 10 For Y = 1 to 5 ' Your Code Here Next YNext XFREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, nested loops, Microsoft Access VBA, loops in Access, nested loop structure, inner loop, outer loop, loop interaction, multiplication tables, dice rolls, D&D character stat generator, loop examples, Loop database, for loop, while loop, D&D Dice Roller, simulating dice rolls, total rolls, individual dice, ability scores, display results, Run-time error '9', subscript out of rangeQUESTIONS:Please feel free to post your questions or comments below. Thanks.
For Each Next Loops in Microsoft Access VBA. Loop Thru Controls on a Form. Computer Learning Zone 2023-09-28 | In this Microsoft Access tutorial, I'm going to teach you how to use a For Each Next Loop in VBA. We'll discuss the pros and cons. We'll see how to loop through all of the controls on a form, and then we'll limit that to just the text boxes with the ControlType property.Members will learn how to loop thru the elements of a dynamic array, and also learn how to clear all of the values in the text boxes on a form which requires some additional coding.MEMBERS-ONLY EXTENDED CUT VIDEO: youtu.be/klN5xEFhWq8BECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: For Each Loop: 599cd.com/ForEachPREREQUISITES:Intro to VBA: 599cd.com/IntroVBAStatus Box: 599cd.com/StatusLINKS:MS List of ControlTypes: tinyurl.com/23nrfcawVBA LOOPS SERIES:For Next: 599cd.com/ForNextWhile Wend: 599cd.com/WhileDo While: 599cd.com/DoWhileDo Until: 599cd.com/DoUntilFor Each: 599cd.com/ForEachNested Loops: 599cd.com/NestedLoopsSummary: 599cd.com/LoopsRECOMMENDED COURSES:For Each Next Loops in Developer 15: 599cd.com/ACD15Developer Courses: 599cd.com/DeveloperSYNTAX:For Each Object In (Collection or Array) ' Your Code HereNextFREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, For each next loop, collections, control object, controls collection, typeof, controltype property, textbox, acTextBoxQUESTIONS:Please feel free to post your questions or comments below. Thanks.
Mastering Static Arrays in Microsoft Access VBA with a Dice Roll Simulator Computer Learning Zone 2023-09-27 | In this Microsoft Access tutorial, I'm going to teach you how to use static arrays and the Randomize function to simulate die rolls for a Dungeons & Dragons character. We'll define an array to hold six ability scores and another to label these scores with their corresponding stat names like STR, INT, and WIS. This lesson is a perfect blend of learning VBA array basics while having a bit of fun with random number generation.Members are going to learn how to load the array of stat names more easily using the Array function. There are some additional changes we'll need to make to the code, but it's an overall better solution.MEMBERS-ONLY EXTENDED CUT VIDEO: youtu.be/EpRZSFfQ4FwBECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: Arrays: 599cd.com/ArraysPREREQUISITES:Intro to VBA: 599cd.com/IntroVBAVariables: 599cd.com/VariablesStatus Box: 599cd.com/StatusRandom: 599cd.com/RandomFor Next Loop: 599cd.com/ForNextRECOMMENDED COURSES:Access Developer 21: 599cd.com/ACD21Developer Courses: 599cd.com/DeveloperFREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Static array, array function, variant, load array with values, array loop, breadcrumbs, die roll, dice rollQUESTIONS:Please feel free to post your questions or comments below. Thanks.
How to Generate Random Numbers in Microsoft Access VBA. Rolling Dice! Computer Learning Zone 2023-09-26 | In this Microsoft Access tutorial, I'm going to teach you how to generate random numbers with the Rnd function. We're going to learn about the Randomize statement, then see how to roll a 6-sided die to generate a random number from 1 to 6. As a fun example, we'll generate ability scores for a Dungeons and Dragons character by rolling three six-sided dice.BECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: Random: 599cd.com/RandomPREREQUISITES:Intro to VBA: 599cd.com/IntroVBAStatus Box: 599cd.com/StatusInt Function: 599cd.com/RoundCreate Function: 599cd.com/CreateFunctionLINKS:Random Records: 599cd.com/RandomRecordsSYNTAX:DieRoll = Int((Rnd * 6) + 1)CODE VAULT:DieRoll Function: 599cd.com/DieRollRECOMMENDED COURSES:Access Developer 3: 599cd.com/ACD3FREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Random, rnd, randomize, dice roller, roll a die, D&D character generator, D&D ability score generator, generate random numbers, Random number generator, dice simulation, tabletop RPG, ability score calculation, six-sided dice, D20 system, pseudo-random numbers, random seed, dice mechanics, random distribution, VBA random numbers, dice-rolling algorithm, custom RNG, D&D stats, D&D dice roller, roll 1d6QUESTIONS:Please feel free to post your questions or comments below. Thanks.
Do Until Loops in Microsoft Access VBA Computer Learning Zone 2023-09-25 | In this Microsoft Access tutorial, I'm going to teach you how to use a Do Until Loop in VBA. We'll discuss the pros and cons. We'll see how you can test for a condition at either the top or the bottom of the loop. We'll learn about the Exit Do command. We'll discuss how Do Until is very similar to yet different from Do While.Members will learn how to perform goal seeking for a savings account balance using a Do Until loop. They will specify a starting balance and an end goal balance, as well as the interest rate. Then we'll use a loop to calculate the compounding monthly interest until our goal balance is met.MEMBERS-ONLY EXTENDED CUT VIDEO: youtu.be/z9cpMZTnUbMBECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: Do Until Loop: 599cd.com/DoUntilPREREQUISITES:Intro to VBA: 599cd.com/IntroVBAVariables: 599cd.com/VariablesStatus Box: 599cd.com/StatusVBA LOOPS SERIES:For Next: 599cd.com/ForNextWhile Wend: 599cd.com/WhileDo While: 599cd.com/DoWhileDo Until: 599cd.com/DoUntilFor Each: 599cd.com/ForEachNested Loops: 599cd.com/NestedLoopsSummary: 599cd.com/LoopsRECOMMENDED COURSES:Developer Courses: 599cd.com/DeveloperSYNTAX:Do Until Condition ' Your Code Here [If OtherCondition Then Exit Do]LoopDo ' Your Code Here [If OtherCondition Then Exit Do]Loop Until ConditionFREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Do-until Loop, do until loop, do/until loop, do until loop, VBA, exit do, Loop Counter, Conditional Exit, Loop Termination, exit out of do until loop , goal seek, monthly compounded interest, compounding interestQUESTIONS:Please feel free to post your questions or comments below. Thanks.
Do While Loops in Microsoft Access VBA Computer Learning Zone 2023-09-22 | In this Microsoft Access tutorial, I'm going to teach you how to use a Do While Loop in VBA. We'll discuss the pros and cons. We'll see how you can test for a condition at either the top or the bottom of the loop. We'll learn about the Exit Do command. BECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: Do While Loop: 599cd.com/DoWhilePREREQUISITES:Intro to VBA: 599cd.com/IntroVBAVariables: 599cd.com/VariablesStatus Box: 599cd.com/StatusVBA LOOPS SERIES:For Next: 599cd.com/ForNextWhile Wend: 599cd.com/WhileDo While: 599cd.com/DoWhileDo Until: 599cd.com/DoUntilFor Each: 599cd.com/ForEachNested Loops: 599cd.com/NestedLoopsSummary: 599cd.com/LoopsRECOMMENDED COURSES:Developer Courses: 599cd.com/DeveloperSYNTAX:Do While Condition ' Your Code Here [If OtherCondition Then Exit Do]LoopDo ' Your Code Here [If OtherCondition Then Exit Do]Loop While ConditionFREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Do-While Loop, do while loop, do/while loop, do while loop, VBA, exit do, Loop Counter, Conditional Exit, Loop Termination, exit out of do while loopQUESTIONS:Please feel free to post your questions or comments below. Thanks.
While Wend Loops in Microsoft Access VBA Computer Learning Zone 2023-09-21 | In this Microsoft Access tutorial, I'm going to teach you how to use a While Wend Loop in VBA. We'll discuss the pros and cons, and I'll show you how to simulate an Exit While even though this type of loop doesn't support that feature. Then I'll show you how to use a While loop to cycle through all of the records in the Customer table and display everyone's names using a recordset. BECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: While Wend Loop: 599cd.com/WhilePREREQUISITES:Intro to VBA: 599cd.com/IntroVBAVariables: 599cd.com/VariablesStatus Box: 599cd.com/StatusLINKS:Using Recordsets: 599cd.com/RecordsetVBA LOOPS SERIES:For Next: 599cd.com/ForNextWhile Wend: 599cd.com/WhileDo While: 599cd.com/DoWhileDo Until: 599cd.com/DoUntilFor Each: 599cd.com/ForEachNested Loops: 599cd.com/NestedLoopsSummary: 599cd.com/LoopsRECOMMENDED COURSES:Developer Courses: 599cd.com/DeveloperWhile Wend Loops in Developer 12: 599cd.com/ACD12Recordsets in Developer 16: 599cd.com/ACD16SYNTAX:While Condition ' Your Code HereWendFREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, While-Wend Loop, while wend loop, while/wend loop, while loop, VBA, exit while, Loop Counter, Conditional Exit, Loop Termination, recordset, loop through customers, exit out of while loopQUESTIONS:Please feel free to post your questions or comments below. Thanks.
For Next Loops in Microsoft Access VBA Computer Learning Zone 2023-09-20 | In this Microsoft Access tutorial, I'm going to teach you how to use a For Next Loop in VBA. We'll also see how to use the Step Increment option, and the Exit For command.BECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: For Next Loop: 599cd.com/ForNextPREREQUISITES:Intro to VBA: 599cd.com/IntroVBAVariables: 599cd.com/VariablesStatus Box: 599cd.com/StatusLINKS:Concatenation: 599cd.com/ConcatOdd or Even: 599cd.com/ModVBA LOOPS SERIES:For Next: 599cd.com/ForNextWhile Wend: 599cd.com/WhileDo While: 599cd.com/DoWhileDo Until: 599cd.com/DoUntilFor Each: 599cd.com/ForEachNested Loops: 599cd.com/NestedLoopsSummary: 599cd.com/LoopsRECOMMENDED COURSES:Developer Courses: 599cd.com/DeveloperFor Next Loops in Developer 3: 599cd.com/ACD3SYNTAX: For Counter = Start to End [Step Increment] ' Your Code Here [If Condition Then Exit For] Next [Counter]FREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, For-Next Loop, for next loop, for/next loop, for loop, VBA, Step Increment, Exit For, Loop Counter,Total Accumulation, Conditional Exit, Loop TerminationQUESTIONS:Please feel free to post your questions or comments below. Thanks.
Resize Images in Microsoft Access: Using FFmpeg & Paint with VBA - Advanced Developer Tutorial Computer Learning Zone 2023-09-19 | In this Microsoft Access tutorial, I'm going to teach you how to resize images directly from your Access database. We'll cover two distinct methods for achieving this. First, we'll explore how to use the Shell function in VBA to run FFmpeg, an open-source multimedia handling utility. Next, for those who prefer an approach that doesn't require 3rd-party software, I'll guide you through a technique using SendKeys and Microsoft Paint. This tutorial is designed for both Advanced users and Developers, offering a practical way to manipulate images within Access.Maya from Eagan, Minnesota (a Silver Member) asks: How can I resize large, high-resolution JPEG files from my photographers to a more manageable size, like 500 pixels across, so that I can easily link them to my Microsoft Access database?BECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: Resize Images: 599cd.com/ResizeImagesPREREQUISITES:Images: 599cd.com/ImageIntro to VBA: 599cd.com/IntroVBAError Handling: 599cd.com/ErrorHandlingLINKS:Shell Command: 599cd.com/ShellSleep: 599cd.com/SleepSendKeys: 599cd.com/SendKeysFFMPEG:FFmpeg Project: ffmpeg.orgSpecific Build: https://www.gyan.dev/ffmpeg/buildsRECOMMENDED COURSES:Access Developer Courses: 599cd.com/DeveloperFREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, resize images in access, resize pictures, ffmpeg, shell, sendkeys, Access VBA Image Resize, Image Manipulation Access, Scale Images Access Database, Access Image Control, VBA Code Image Resize, Batch Resize Access, MS Access Image Optimization, VBA Picture ResizeQUESTIONS:Please feel free to post your questions or comments below. Thanks.
Microsoft Access Account Balances Template - Release Update 3 Computer Learning Zone 2023-09-18 | Get the Account Balances Template at 599cd.com/BalancesHi folks, this is Richard Rost with AccessLearningZone.com. I just released Update 3 of my Account Balances Template. If you're not familiar, this is a database you can use to track all of your account balances, like your credit cards, your bank statements, and the recurring payments that go with them. In Update 3, we're going to parse pending payments. I'll explain what that means in a minute. I designed a script editor so you can load up a webpage from your bank or credit card, and it will automatically get the information you need off the text of that page with one click. It's really cool; I'll show it to you in a second. And I added an Auto Filter feature so that it'll only show you the transactions and stuff for the account that you're working on.So what does "parse pending payments" mean? Well, some websites—and I'm not going to name names, Amazon—if you have the Amazon credit card, for example, you'll see this. They don't total up the pending activity for you, right? They'll give you a balance and they'll tell you what your credit available is, but they don't add up the pending activity. So you've got to come and type this all in. That's why we made it in the Account Balances Template, so you can type in 125 plus 6 plus 100 plus 30—whatever—and then the database adds it all up for you, just like an Excel spreadsheet would. Well, now, this little feature here, "parse pending payments," allows you to copy and paste that text and drop it right in. So, come over to your web browser, just copy all this text, Ctrl+C, come back here, paste it in, and then hit Parse and it does that work for you. There they are. There's an option to ignore negative values because they put payments in there too, which they shouldn't, but they do. Okay, hit Save Pending, and it puts it right up in there for you. You don't have to sit here and do any typing.Now, speaking of not doing any typing, I also created this feature called the Script Editor. This has a bunch of actions in it. The first thing you're going to do is go "Get Text from Window." Now, you've got to log in manually; I don't have that automated yet. But this will save you some typing. So, you log on to whatever your bank or credit card statement is. The name of the window up here will be in the tab. This one is "Amazon Billing Activity." It doesn't have to be exact; just any part of it, as long as it's unique, right? Once you've got the window picked, the next step is to look at the text and copy it to the clipboard, then analyze it to find that current balance. Each bank, credit card, or website is different, but the information is always there in the text. Now, I've been using this for a couple of weeks and it's working great for me. I've also added an Auto Filter feature; when you click on it, it shows only the transactions related to the selected account, another time saver.Remember, every time I add features, the price goes up because the database is doing more. If you've already purchased it, you're grandfathered in. So, if you're interested, don't wait; get in on the ground floor. Check it out on the website, and if you have any questions or comments, post them down below.Live long and prosper, my friends. I'll see you next time.Get the Account Balances Template at 599cd.com/Balances
Computer Learning Zone Video Rewind for 2023-09-18 #windows #msaccess #msexcel #tutorials Computer Learning Zone 2023-09-18 | It's time for another Video Rewind, which is a quick recap of all the videos I released recently. If you are interested in any of the topics listed, just head on over to my website at 599cd.comKEYWORDS#shorts, #windows, #mswindows, #msaccess, #msexcel, microsoft windows, access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #videorewindQUESTIONS:Please feel free to post your questions or comments below. Thanks.NOTE TO YOUTUBE:One minute is WAY too short, even for #shorts. Consider increasing the time to even 2 or 3 minutes. One minute? No way.
Creating Excels EOMONTH Function in Microsoft Access VBA: Date Manipulation Made Easy Computer Learning Zone 2023-09-18 | In this Microsoft Access tutorial, I'm going to teach you how to create a replica of Excel's EOMONTH function using VBA. You'll learn how to write a custom function that will allow you to find the end-of-month date based on a given date and the number of months you want to add or subtract. This will offer you a seamless way to extend Excel's capabilities right into your Access databases, giving you more control and flexibility over your date calculations. Stay tuned to discover how to bring this useful Excel feature into your Access toolkit.Ethan from San Marcos, Texas (a Platinum Member) asks: I'm in the process of transitioning numerous Excel spreadsheets to a Microsoft Access database. One function that we frequently use in our spreadsheets is EOMONTH. Is there a way to replicate this functionality within Microsoft Access?BECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: Access EOMONTH: 599cd.com/EOMONTHPREREQUISITES:First Day of Month: 599cd.com/FirstDayOfMonthIntro to VBA: 599cd.com/IntroVBACreate Function: 599cd.com/CreateFunctionRECOMMENDED COURSES:Access Expert 27: 599cd.com/ACX27Developer: 599cd.com/DeveloperFREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Excel EOMONTH Function in Access, Last Day of Month, EOMONTH in Access, DateSerial, End-of-Month Calculations, Access Date Functions, EOMONTH Function, Transitioning to Access, Excel Functions in Access, Date Manipulation in Access, Replicate Excel in AccessQUESTIONS:Please feel free to post your questions or comments below. Thanks.
Extract Text Between Delimiters in Microsoft Access VBA: Advanced FindBetween Function Tutorial Computer Learning Zone 2023-09-15 | In this Microsoft Access tutorial, I will teach you how to extract specific text located between two given delimiters or keywords within a block of text. This is incredibly useful when you're dealing with text data and need to isolate particular information. Whether you're parsing through data retrieved from a Web API, system logs, analyzing text files, or simply want to manipulate text in your Access databases, knowing how to do this can save you a ton of time. We'll use VBA to create a custom function called FindBetween to achieve this.BECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: Find Between: 599cd.com/FindBetweenPREREQUISITES:Intro to VBA: 599cd.com/VBAWeb API: 599cd.com/WebAPILINKS:If Then: 599cd.com/IfThenString Functions: 599cd.com/StringInStr Function: 599cd.com/InStrCreate Function: 599cd.com/CreateFunctionStatus Box: 599cd.com/StatusNZ Function: 599cd.com/NZAlex's JSON Page: github.com/VBA-tools/VBA-JSONCODE VAULT:Find Between Code: 599cd.com/FindBetweenCodeRECOMMENDED COURSES:Access Developer 32: 599cd.com/ACD32FREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, FindBetween, find text between two other bits of text, Text Parsing, VBA Function, String Manipulation, Extract Text, Text Delimiters, Custom Function, FindBetween, Data Isolation, Text Analysis, Web API Parsing, System Log Parsing, Text Field Manipulation, Advanced Developer Techniques, VBA String Functions, Block of Text, Access VBA, Keyword Search, Text Between Keywords, Textual Data Analysis, VBA Text Functions, Level Up Access Skills, JSON, XMLQUESTIONS:Please feel free to post your questions or comments below. Thanks.
Optimizing Microsoft Access Performance: How to Adjust Task Priority in Windows Computer Learning Zone 2023-09-14 | In this Microsoft Access tutorial, I'm going to teach you how to optimize your database performance by adjusting task priority levels in Windows. Understanding task priority can make a significant difference in how quickly your queries run, forms load, or reports generate, especially when working with large and complex databases. But remember, with great power comes great responsibility and tweaking these settings can improve performance but can also lead to system instability if not done carefully.Raj from Denver, Colorado (a Gold Member) asks: I've been building an Access database that involves a lot of mathematical calculations and it has been really slow. I've optimized my queries and made sure my tables are properly structured like you show in your classes, but some operations like running detailed reports still take ages to complete. Is there a way to speed things up without upgrading my hardware. Thanks!Silver members and up get access to an Extended Cut of this video. Members will learn how to create a batch file to automatically run your database at whatever set priority you decide, so you don't have to manually change it every time you run Access.BECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: Task Priority: 599cd.com/TaskPriorityPREREQUISITES:Intro to VBA: 599cd.com/IntroVBARECOMMENDED COURSES:Access Developer Courses: 599cd.com/DeveloperFREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, task, priority, end task, high, Realtime, above normal, normal, below normal, low, processes, CPU, Improved Performance, Responsiveness, Faster Completion Time, Resource Allocation, System Instability, Resource Hogging, Resource-Intensive, calculations, speed up searchQUESTIONS:Please feel free to post your questions or comments below. Thanks.
Retrieving Real-Time Data Using a Web API in Microsoft Access Computer Learning Zone 2023-09-12 | In this Microsoft Access tutorial, I'm going to teach you how to use a little VBA code to go out to the web and retrieve data using something called a web API. The example we're going to use today involves going out to an internet time server and getting the exact time, but this technique can be used for tons of different things, including interacting with ChatGPT.BECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: Web API: 599cd.com/WebAPIPREREQUISITES:Intro to VBA: 599cd.com/IntroVBALINKS:World Time API: https://WorldTimeAPI.orgText Messages: 599cd.com/SMSDaylight Saving Time UTC: 599cd.com/UTCRECOMMENDED COURSES:Access Developer 32: 599cd.com/ACD32FREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Retrieving Real-Time Data, Web API, Data Retrieval with VBA, Real-Time Data Access, Web API in Access, Microsoft Access Web API Tutorial, Access VBA Web API Example, Web Data Integration, Access Data from Internet, Microsoft Access Time Retrieval, Internet Time Using VBA, Access Web Data with VBA, ChatGPT Integration, Real-Time Data Access with Access, Access VBA Web API Fetch, Web API Data Retrieval in Access, VBA Code for Web Data Retrieval, Access External Data, Microsoft Access Data Integration, Internet Time Retrieval Tutorial, Access Web Data Fetching.QUESTIONS:Please feel free to post your questions or comments below. Thanks.
Automated Import of Data to Microsoft Access from Excel with Just One Click Computer Learning Zone 2023-09-11 | In this Microsoft Access tutorial, I'm going to teach you how to automate the import of data to Access from Excel with a little VBA and just one click. We're going to use the TransferSpreadsheet command and update existing records in our database.BECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: Automated Import: 599cd.com/AutomatedImportPREREQUISITES:Automated Export: 599cd.com/AutomatedExportUpdate Queries: 599cd.com/UpdateQLINKS:Backup Access: 599cd.com/BackupImport New, Changed Records: 599cd.com/ImportChangesRECOMMENDED COURSES:Access Developer Courses: 599cd.com/DeveloperCODE:DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12Xml, "CustomerTempT", "C:\File.xlsx", TrueFREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Import from excel to access, import updates from excel, DoCmd.TransferSpreadsheet, acImport, unable to append all the data, update queryQUESTIONS:Please feel free to post your questions or comments below. Thanks.
Automated Export of Data from Microsoft Access to Excel with Just One Click Computer Learning Zone 2023-09-08 | In this Microsoft Access tutorial, I'm going to teach you how to automate the export of data from Access to Excel with a little VBA and just one click. We're going to discuss the TransferSpreadsheet and OutputTo commands.BECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: Automated Export: 599cd.com/AutomatedExportPREREQUISITES:Export to Excel: 599cd.com/ExportToExcelIntro to VBA: 599cd.com/IntroVBALINKS:Error Handling: 599cd.com/ErrorHandlingExport to Word: 599cd.com/ExportToWordExport Reports to PDF: 599cd.com/ExportPDFRECOMMENDED COURSES:Access Developer Courses: 599cd.com/DeveloperCODE:DoCmd.OutputTo acOutputForm, "FormNameF", acFormatXLSX, "C:\Folder\File.xlsx", TrueFREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, automated export from Access to excel, automate exporting to excel, TransferSpreadsheet, docmd.OutputTo, acExport, acSpreadsheetTypeExcel12Xml, corrupt XLSX file, acOutputForm, acFormatXLSXQUESTIONS:Please feel free to post your questions or comments below. Thanks.
Exporting Data from Microsoft Access to Excel With Formatting Computer Learning Zone 2023-09-07 | In this Microsoft Access tutorial, you will learn how to export data from Access to Excel. I'll show you a simple export, then I'll show you how to export with filters, sorts, and formatting (colors, date formats, etc.) intact.Sarah from Amarillo, Texas (a Platinum Member) asks: I'm in charge of keeping track of all the product data for the company but I'm the only one with Access and everyone else refuses to use Access. They all have Excel so is there an easy way for me to export a spreadsheet that they can all view and maybe even make changes to and then I can import that back into Access when I need to? It would also be nice if I could keep my formatting (colors, date formats, etc.)BECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: Export to Excel: 599cd.com/ExportToExcelPREREQUISITES:Access Beginner 1: 599cd.com/ACB1Continuous Forms: 599cd.com/ContinuousLINKS:ISO Date Format: 599cd.com/ISOImport Excel: 599cd.com/ImportExcelUpdate Queries: 599cd.com/UpdateQAutomated Export to Excel: 599cd.com/AutomatedExportRECOMMENDED COURSES:Excel Expert 8: 599cd.com/LX8Access Expert 19: 599cd.com/ACX19FREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Access to Excel, How to Export MS Access Table data to Excel, Exporting Tables Queries and Reports from Access to Excel, export access to excel, export access data to excel with formatting, colors, date formatsQUESTIONS:Please feel free to post your questions or comments below. Thanks.
Save & Load Database Objects as Text Files in Microsoft Access Computer Learning Zone 2023-09-06 | In this Microsoft Access tutorial, I will teach you how to utilize the SaveAsText and LoadFromText functions to save and load your database objects as text files. Learn how to easily export forms, reports, and other objects as text files for easy sharing via email or other means. This is an invaluable technique for distributing updates and for circumventing corporate restrictions on sending files. Discover how you can send a custom form as a text file and then have the recipient load it back into their Access database seamlessly.Andrew from Huntsville, Alabama (a Platinum Member) asks: A coworker and I are working on the same (copy of a) Microsoft Access database, but he's in a different location. My company has strict policies that only allow us to send text files from our computers—no attachments, no FTP, and we can't even use thumb drives. I've tried zipping the file and renaming it with a .txt extension, but they still catch it. We're not breaking any corporate rules; my boss even said it's okay. However, it's up to us to figure out a workaround since the IT guys are no help. Is there anything you can think of? We make little changes to forms or reports every now and then, and we'd like to be able to share them.BECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: Save As Text: 599cd.com/SaveAsTextPREREQUISITES:Intro to VBA: 599cd.com/IntroVBALINKS:Status Box: 599cd.com/StatusReport Listbox: 599cd.com/ReportListboxRECOMMENDED COURSES:Access Developer Courses: 599cd.com/DeveloperFREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, SaveAsText, LoadFromText, save as text, load from text, export database objects, save database objects, export forms, export reports, transfer form, send form, send report objectQUESTIONS:Please feel free to post your questions or comments below. Thanks.
List All Open Programs on the PC with Microsoft Access VBA and the EnumWindows Function Computer Learning Zone 2023-09-05 | In this Microsoft Access tutorial, I'm going to teach you how to use the EnumWindows function to list all open and running programs on your PC. This is handy if you want to switch to an application that's open, but you don't know the exact title.Daniel from Greenville, South Carolina (a Platinum Member) asks: I'm using your AppActivate code to switch to my web browser and then copy some data from there into my Access application. Usually, the title stays the same, but once in a while, the website modifies the title just a bit, and it throws my code off. Is there any way to loop through all the open windows and look for a piece of text in the title instead of having to match the entire thing?Silver members and up get access to an Extended Cut of this video. Members will learn how to switch to the application once we've found it, copy all of the text in that application back to Access, which we can then use to do whatever we want. Whether it's parsing some data out, copying it to a table, and so on.MEMBERS-ONLY EXTENDED CUT VIDEO: youtu.be/0zZuWx32_HsBECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: List Open Programs: 599cd.com/ListOpenProgramsPREREQUISITES:AppActivate: 599cd.com/AppActivateLINKS:Status Box: 599cd.com/StatusMEMBER LINKS:Find Window: 599cd.com/2840Num Lock On Off: 599cd.com/CapsLockOnOffSendKeys: 599cd.com/SendKeysRECOMMENDED COURSES:Callback Functions in Developer 44: 599cd.com/ACD44CODE:Declare PtrSafe Function EnumWindows Lib "user32" (ByVal lpEnumFunc As LongPtr, ByVal lParam As LongPtr) As LongDeclare PtrSafe Function GetWindowText Lib "user32" Alias "GetWindowTextA" (ByVal hwnd As Long, ByVal lpString As String, ByVal cch As Long) As LongFREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, list all open windows, callback functions, enumwindows, open programs, running programs, what programs are running, switch to open window, switch to programQUESTIONS:Please feel free to post your questions or comments below. Thanks.
Whats the Difference Between DoCmd.RunSQL and CurrentDb.Execute in Microsoft Access Computer Learning Zone 2023-09-04 | In this Microsoft Access tutorial, I'm going to teach you the difference between DoCmd.RunSQL and CurrentDb.Execute and when you would want to use each.Mike from Newcastle, England (a Platinum Member) asks: I've been following your Microsoft Access videos for years, and you used to always use DoCmd.RunSQL in your code. But recently, I've noticed you using CurrentDb.Execute instead. What's the difference between the two, and what should I use?Silver members and up get access to an Extended Cut of this video. Members will learn how to trap errors in db.Execute commands with the dbFailOnError parameter. We will also learn how to count how many records were affected with any SQL command by using the RecordsAffected property.MEMBERS-ONLY EXTENDED CUT VIDEO: youtu.be/AquWR5gil8cBECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: RunSQL vs Execute: 599cd.com/RunSQLvExecutePREREQUISITES:SQL with Access: 599cd.com/SQLwithAccessAction Queries: 599cd.com/ActionQueryIntro to VBA: 599cd.com/IntroVBALINKS:Turn Off Warnings: 599cd.com/SetWarningsValue From a Form: 599cd.com/FormNameError Handling: 599cd.com/ErrorHandlingRECOMMENDED COURSES:Access SQL Seminars: 599cd.com/SQLAccess Developer Courses: 599cd.com/DeveloperRICK'S PICKS:No Longer Set: http://nolongerset.com/avoid-docmd-runsqlDEVelopers HUT: http://devhut.netAccess Forever: http://accessforever.orgDenver Area Access Users Group: http://daaug.orgAccess User Groups: http://accessusergroups.orgFREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, What is the difference between docmd.runsql and currentdb.execute, Execute vs RunSQL, CurrentDb.Execute vs. docmd.runsql, suppress warnings, handle errors, dbFailOnError, RecordsAffected, run-time error 3061, too few parameters expected 1QUESTIONS:Please feel free to post your questions or comments below. Thanks.
Computer Learning Zone Video Rewind for 2023-09-03 #windows #msaccess #msexcel #tutorials Computer Learning Zone 2023-09-03 | It's time for another Video Rewind, which is a quick recap of all the videos I released recently. If you are interested in any of the topics listed, just head on over to my website at 599cd.comKEYWORDS#shorts, #windows, #mswindows, #msaccess, #msexcel, microsoft windows, access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #videorewindQUESTIONS:Please feel free to post your questions or comments below. Thanks.NOTE TO YOUTUBE:One minute is WAY too short, even for #shorts. Consider increasing the time to even 2 or 3 minutes. One minute? No way.
AutoSave Form Data at Timed Intervals in Microsoft Access Computer Learning Zone 2023-09-01 | Word and Excel have an AutoSave. Why not Access? In this Microsoft Access tutorial, I'm going to teach you how to have your form automatically save data at a timed interval. So, if someone walks away from the computer in the middle of editing a record, it will automatically save after, say, 3 minutes.Declan from San Francisco, California (a Platinum Member) asks: I run a call center and have a problem where my employees will get up and walk away from the computer in the middle of entering a record without saving it. They'll go on a smoke break, or even go out to lunch, or sometimes even go home before saving their work. Of course, if that caller calls back and someone else goes to open the record, they don't see the most up-to-date changes. Is there any way to have the database automatically save changes every minute or two in case this happens?Silver members and up get access to an Extended Cut of this video. Members will learn how to stop the Autosave from kicking in while the user is actively editing the record. This way he won't be interrupted while typing and have the form save and reset. MEMBERS-ONLY EXTENDED CUT VIDEO: youtu.be/c73gXGLigjoBECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: Parse Lines: 599cd.com/AutoSavePREREQUISITES:Timer Event: 599cd.com/TimerDirty: 599cd.com/DirtyIntro to VBA: 599cd.com/VBARECOMMENDED COURSES:Access Developer Course: 599cd.com/DeveloperFREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Autosave records in access, refresh interval, auto save, automatically save, keypress, key press, on mouse over, button press events, Key preview, keypreview, how to automatically save records after a timed interval in microsoft accessQUESTIONS:Please feel free to post your questions or comments below. Thanks.
How to Fix File Already in Use and Already Opened Errors When Compacting in Microsoft Access Computer Learning Zone 2023-08-31 | In this Microsoft Access tutorial, we're going to learn how to deal with experiencing the "File already in use" error message when you try compacting your database. You may also get the error message saying, "You attempted to open a database that's already opened by another user. Try again when the database is available." We'll talk about both of these issues today.Kieran from Miami, Florida (a Platinum Member) asks: I try to compact my database at least once a week, like you told me in your compacting video. But it seems most of the time when I do, I get an error message saying that the database is already in use. I do have a few other people on my network, but I always make sure that everyone's logged out. In fact, no one else is here in the office and all the computers are off, but I still get the error message. What gives?BECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: File In Use: 599cd.com/FileInUsePREREQUISITES:Compact & Repair: 599cd.com/CompactLINKS:Backup Access: 599cd.com/BackupFile Sharing Services: 599cd.com/FileSharingTroubleshooter: 599cd.com/TroubleCHECKLIST:Make sure everyone is out of the database (including you)Delete the LACCDB fileMake sure no MSACCESS.EXE tasks are runningOpen with SHIFT key bypassTry compacting a copy of the database fileDon't use a shortcut (go in thru Access - File - your database)Restart WindowsOffice Update (check bug reports)Create a new blank database, import objectsImport objects one at a timeTurn off File Sharing Services (Google Sync, Dropbox, etc.)Check my TroubleshooterBUG ALERTS:No Longer Set: nolongerset.com (Mike Wolfe)Access Forever: accessforever.org (Karl Donaubauer, et al.)Official Microsoft Access Blog: 599cd.com/AccessBlog (Access Team)ACCESS REPAIR SERVICES:Everything Access: everythingaccess.com (Wayne Phillips)Access Experts: accessexperts.com (Juan Soto, et al.)Winning Solutions, Inc. microsoftaccessexpert.com (Bob Estabrook)RECOMMENDED COURSES:FREE Access Beginner Level 1: 599cd.com/Free1FREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Can't compact database, file already in use, could not use, accdb, you attempted to open a database that is already opened by user x on machine y, try again when the database is available, fix corrupted microsoft access database, How to Recover and Repair Corrupted Access Database Files, ACCDB Recovery Tool, access database repair servicesQUESTIONS:Please feel free to post your questions or comments below. Thanks.
How to Calculate a Merchant Cash Advance (MCA) Loan Repayment in Microsoft Access Computer Learning Zone 2023-08-30 | In this Microsoft Access tutorial, I'm going to teach you how to calculate the completion date of a Merchant Cash Advance (MCA) loan.Zane from Denver, Colorado (a Platinum Member) asks: I recently took out a merchant cash advance loan where the lender takes 30% of my daily sales until the loan is paid off. Can you show me how to calculate what the end payment date would be?BECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: MCA Loan: 599cd.com/MCALoanPREREQUISITES:MCA Loans in Excel: 599cd.com/ExcelMCALoansIntro to VBA: 599cd.com/IntroVBAAccount Balances 1: 599cd.com/AccountBalancesLINKS:On Current: 599cd.com/OnCurrentAfter Update: 599cd.com/AfterUpdateOption Explicit: 599cd.com/OptionExplicitRECOMMENDED COURSES:Account Balances Template: 599cd.com/BalancesAccess Developer Courses: 599cd.com/DeveloperFREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, mca loan calculator, Merchant Cash Advance CalculatorQUESTIONS:Please feel free to post your questions or comments below. Thanks.
How to Calculate a Merchant Cash Advance (MCA) Loan Repayment in Microsoft Excel Computer Learning Zone 2023-08-29 | In this Microsoft Excel tutorial, I'm going to teach you how to calculate the completion date of a Merchant Cash Advance (MCA) loan.Zane from Denver, Colorado (a Platinum Member) asks: I recently took out a merchant cash advance loan where the lender takes 30% of my daily sales until the loan is paid off. Can you show me how to calculate what the end payment date would be?BECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: 599cd.com/ExcelMCALoansPREREQUISITES:Free Excel Beginner 1: 599cd.com/LB1LLINKS:ISO Date Format: 599cd.com/ISODatesXConditional Formatting: 599cd.com/ExcelCFMCA Loans in Access: 599cd.com/MCALoansRECOMMENDED COURSES:Excel Beginner, Expert Courses: 599cd.com/ExcelPMT Function in Excel Expert Level 6: 599cd.com/LX6WANT MORE EXCEL?Most of what I do is Microsoft Access, so if if you want to see me post more Excel videos, make sure to comment below: "I want more Excel!"ADDITIONAL RESOURCES:Donate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningExcelen.wikipedia.org/wiki/Microsoft_Excelproducts.office.com/en-us/excelmicrosoft.com/en-us/microsoft-365/blog/excelKEYWORDSexcel 2021, excel 2016, excel 2019, excel 365, microsoft excel, ms excel, ms excel tutorial, #msexcel, #microsoftexcel, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #techhelp, excel mca loan calculator, Merchant Cash Advance (MCA) Calculator, QUESTIONS:Please feel free to post your questions or comments below. Thanks.
Computer Learning Zone Video Rewind for 2023-08-28 #windows #msaccess #computerhardware #tutorials Computer Learning Zone 2023-08-28 | It's time for another Video Rewind, which is a quick recap of all the videos I released recently. If you are interested in any of the topics listed, just head on over to my website at 599cd.comKEYWORDS#shorts, #windows, #mswindows, microsoft windows, access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #videorewindQUESTIONS:Please feel free to post your questions or comments below. Thanks.NOTE TO YOUTUBE:One minute is WAY too short, even for #shorts. Consider increasing the time to even 2 or 3 minutes. One minute? No way.
How to Use the On Paint Event in Microsoft Access Forms to Supplement Conditional Formatting Computer Learning Zone 2023-08-28 | In this Microsoft Access tutorial, we're going to talk about the On Paint event. Now, while you can use it to do the same thing that conditional formatting does, and in fact, it even has more flexibility than conditional formatting, it's got some problems and some drawbacks. So, we're going to talk about that, and I'm going to show you one way to use the On Paint event to supplement conditional formatting, which is really pretty cool.BECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: On Paint Event: 599cd.com/OnPaintPREREQUISITES:Intro to VBA: 599cd.com/IntroVBAConditional Formatting: 599cd.com/ConditionalLINKS:Reddit Post: 599cd.com/OnPaintRedditOuter Joins: 599cd.com/OuterJoinRECOMMENDED COURSES:Access Developer Courses: 599cd.com/DeveloperAccess Developer 40: 599cd.com/ACD40USAGE:Form Level Variable: Dim StartColor As LongOn Load Event: StartColor = Me.Detail.BackColorOn Activate Event: Me.Detail.BackColor = vbYellowOn Deactivate Event: Me.Detail.BackColor = StartColorFREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, on paint event, section paint event, section.paint, conditional formattingQUESTIONS:Please feel free to post your questions or comments below. Thanks.
Whats the Difference Between On Activate and On Got Focus in Microsoft Access Computer Learning Zone 2023-08-25 | In this Microsoft Access tutorial, we're going to learn the difference between the On Activate and On Got Focus events, as well as the On Deactivate and On Lost Focus events.BECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: Activate vs. Got Focus: 599cd.com/ActivateGotFocusPREREQUISITES:Intro to VBA: 599cd.com/IntroVBALINKS:On Got Focus: 599cd.com/OnGotFocusOn Activate: 599cd.com/OnActivateRECOMMENDED COURSES:Access Developer Courses: 599cd.com/DeveloperUSAGE:Form Level Variable: Dim StartColor As LongOn Load Event: StartColor = Me.Detail.BackColorOn Activate Event: Me.Detail.BackColor = vbYellowOn Deactivate Event: Me.Detail.BackColor = StartColorFREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, on activate, on got focus, what is the difference between activate and got focusQUESTIONS:Please feel free to post your questions or comments below. Thanks.
Use the On Activate Event to Highlight Active Form in Microsoft Access Computer Learning Zone 2023-08-24 | In this Microsoft Access tutorial, I'm going to teach you how to use the On Activate event to highlight the active form and turn it yellow when you click on it, to make it more easily visible to the user.Harper from Seattle, Washington (a Platinum Member) asks: Is there any way to highlight the current form that has focus? Our database uses a bunch of different forms, and sometimes it's hard to keep track of which one you're on. I know how to use conditional formatting to highlight the field you're on, but it would be nice if the whole form turned yellow too. I tried using the On Got Focus event for the form, but that doesn't seem to do anything.BECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: On Activate Event: 599cd.com/OnActivatePREREQUISITES:Intro to VBA: 599cd.com/IntroVBAVariables: 599cd.com/VariablesScope: 599cd.com/ScopeLINKS:VBA Colors: 599cd.com/VBAColorRECOMMENDED COURSES:Access Advanced 1: 599cd.com/ACA1Access Developer 41: 599cd.com/ACD41USAGE:Form Level Variable: Dim StartColor As LongOn Load Event: StartColor = Me.Detail.BackColorOn Activate Event: Me.Detail.BackColor = vbYellowOn Deactivate Event: Me.Detail.BackColor = StartColorFREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, On Activate Event, Form Highlighting, Form Focus, Active Form, User Experience, Form Navigation, Form ActivationQUESTIONS:Please feel free to post your questions or comments below. Thanks.
Use the Force New Page Property to Insert a Page Break after Each Group in a Microsoft Access Report Computer Learning Zone 2023-08-23 | In this Microsoft Access tutorial, I'm going to teach you how to use the Force New Page property in a report group footer to insert a page break after every group.Jack from Manchester, England (a Platinum Member) asks: I just watched your video on report grouping levels, and I've designed a report to give each of my sales reps their list of calls for the day. It's basically the same thing you designed, but instead of the report being grouped on customers, it's grouped on the sales rep, and the customers that they have to call are in the detail section. Is there any way I can generate this so that each sales rep starts on their own page, so they're not all together?BECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: Force New Page: 599cd.com/ForceNewPagePREREQUISITES:Grouping: 599cd.com/GroupingLINKS:Print Multiple Invoices: 599cd.com/PrintMultipleInvoicesRECOMMENDED COURSES:Access Expert 6: 599cd.com/ACX6FREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Page break, new page, force a new page, separate page, after section, before section, report page break, report group force new pageQUESTIONS:Please feel free to post your questions or comments below. Thanks.
Using the On Unload Event to Perform Data Validation When a Form Closes in Microsoft Access Computer Learning Zone 2023-08-22 | In this Microsoft Access tutorial, I'm going to teach you how to use the On Unload event to perform data validation across multiple records and provide a friendly error message when you go to close a form in Microsoft Access.Freya from Oslo, Norway (a Platinum Member) asks: I have a form where my employees enter a number of job codes for a particular project. Each job code is on a separate record. They have to enter at least five job codes but no more than eight. Is there any way I can check that before they're allowed to close the form?BECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: On Unload: 599cd.com/OnUnloadPREREQUISITES:Intro to VBA: 599cd.com/IntroVBABefore Update: 599cd.com/BeforeUpdateDCount: 599cd.com/DCountLINKS:Double Double Quotes: 599cd.com/DoubleDoubleRECOMMENDED COURSES:Access Developer Courses: 599cd.com/DeveloperFREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, On Unload Event, Data Validation, Form Closing, Error Messages, Multiple Records, Validation Rules, Friendly Error Message, Form Controls, Records Validation, form close, on close, on unload, Form.UnloadQUESTIONS:Please feel free to post your questions or comments below. Thanks.
How to Copy & Paste Data to/from the Clipboard in Microsoft Access Computer Learning Zone 2023-08-21 | In this Microsoft Access tutorial, I'm going to teach you how to use the clipboard to copy and paste data in Microsoft Access.Mei Ling from Palo Alto, California (a Platinum Member) asks: I spend a lot of time copying and pasting customer name and address information from my Access database to either a spreadsheet, an email, a Word document, or my label writer. Is there any way you can set it up so that with one click, I can copy their entire name and address?BECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: Copy To Clipboard: 599cd.com/ClipboardPREREQUISITES:Intro to VBA: 599cd.com/IntroVBAConcatenation: 599cd.com/ConcatRECOMMENDED COURSES:Access Developer Courses: 599cd.com/DeveloperFREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Setfocus, DoCmd.RunCommand, acCmdCopy, acCmdPaste, how to use the clipboard in microsoft access, copy to clipboard, cut to clipboard, paste from clipboard, selstart, len, echo off, hide screen writesQUESTIONS:Please feel free to post your questions or comments below. Thanks.
How to Parse Lines in a Textbox and Create Individual Records in Microsoft Access Computer Learning Zone 2023-08-18 | In this Microsoft Access tutorial, I'm going to teach you how to copy a block of text from something like a document or an email, paste it into your Access database in a text box, and then parse it out line by line and save those as individual records. This is a great technique for pulling email addresses, for example, out of a list of emails you were sent.Aisha from Evanston, Illinois (a Platinum Member) asks: A couple of times a week, I get an email containing a list of other email addresses from my sales reps that we need to add to our lead generation database. Right now, I'm copying and pasting them individually into their own records, but is there a way I can just select them all and add them all with one shot?Silver members and up get access to an Extended Cut of this video. Members will learn how to parse a line that includes more information, for example, first name and last name. Then, we will add a record to the contact table for each new record, indicating a follow-up is needed.MEMBERS-ONLY EXTENDED CUT VIDEO: youtu.be/K9Q32TZEzQoBECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: Parse Lines: 599cd.com/ParseLinesPREREQUISITES:Split Part Numbers: 599cd.com/SplitPartNumbersSQL with Access: 599cd.com/SQLwithAccessLINKS:Followups: 599cd.com/FollowupsRECOMMENDED COURSES:Arrays in Access Developer 21: 599cd.com/ACD21FREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, split text into multiple records, multiple rows, parsing text in Access with VBA, Microsoft Access, parse lines, text box, create individual records, copy text, block of text, paste, database, email, save records, technique, email addresses, list of emails, lead generation, sales reps, one shot, contact table, follow-up, Access database, tutorialQUESTIONS:Please feel free to post your questions or comments below. Thanks.
How to Split a Field into Multiple Individual Child Records in Microsoft Access Computer Learning Zone 2023-08-17 | In this Microsoft Access tutorial, I'm going to teach you how to take a single field that has multiple part numbers in it and split that up into individual records in a child table. This is an advanced Developer tutorial, and we will use nested recordset loops and the split function with a string array.Lucas from Minneapolis, Minnesota (a Gold Member) asks: Estimators fill out a spreadsheet while they're on the road with a list of job IDs and part numbers. When they send me the spreadsheet, it's got the job number on a row, but then the part numbers are all listed in one field, comma separated. Of course, I have to type these in manually into my database because I've got proper table relationships set up. So, how can I go about taking those part numbers and splitting them up into individual records in a child table?BECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: Split Part Numbers: 599cd.com/SplitPartNumbersPREREQUISITES:Intro to VBA: 599cd.com/IntroVBASplit Function: 599cd.com/SplitFunctionUsing Recordsets: 599cd.com/RecordsetLINKS:Many-to-Many: 599cd.com/M2MStatus Box: 599cd.com/StatusRECOMMENDED COURSES:Recordsets in Access Developer 16: 599cd.com/ACD16Arrays in Access Developer 21: 599cd.com/ACD21FREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Recordsets, recordset loop, nested recordsets, split function, string array, nested recordset loop, break items in field up into individual recordsQUESTIONS:Please feel free to post your questions or comments below. Thanks.
How to Count the Number of Records in a Continuous Form with Criteria in Microsoft Access Computer Learning Zone 2023-08-16 | In this Microsoft Access tutorial, I'm going to teach you how to count the number of records in a continuous form and also apply criteria. For example, if you want to count the number of customers from Florida, you can obtain that count in the form footer using the Count function.Daniel from Burbank, California (a Gold Member) asks: I'm trying to get a count of customers from my home state of California on my customer list. I've attempted several different formulas following your Form Footer Totals video, but I just can't seem to get it to work. For example, I've tried: =Count([State]="NY") and it doesn't work. Please help. Silver members and up get access to an Extended Cut of this video. Members will learn how to create a combo box to select the state from a list of states that exist in the customer table. They can then filter the count results based on that state, allowing for on-the-fly changes. We will use one line of Visual Basic code.MEMBERS-ONLY EXTENDED CUT VIDEO: youtu.be/_QbUke6qLEcBECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: Count Records: 599cd.com/CountRecordsPREREQUISITES:Form Footer Totals: 599cd.com/FormFooterTotalsLINKS:DCount: 599cd.com/DCountIIF Function: 599cd.com/IIFRECOMMENDED COURSES:Footer Totals in Access Expert 3: 599cd.com/ACX3USAGE:=Sum([State]="NY")*-1=Count(IIf([State]="NY",1,Null))FREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, ms access count records in continuous form with criteria, Count Records in a Continuous Form, count function with criteria, count functionQUESTIONS:Please feel free to post your questions or comments below. Thanks.
Fixing the #Deleted Error in Microsoft Access Computer Learning Zone 2023-08-15 | In this Microsoft Access tutorial, we're going to discuss the #Deleted error message. I'll provide one specific example of when this message can appear. Following that, we'll talk about various scenarios where you might encounter this error message and what steps you can take to resolve it.Musoke from Kampala, Uganda (a Gold Member) asks: I have a continuous form where I use a delete query to remove all data at once. Then I utilize an append query to add data back to the same form. However, the new data doesn't load instantly on the form. Instead, I immediately see #Deleted all over the form. How can I modify this so that the data loads instantly and the #Deleted text doesn't appear in the continuous form?BECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: #Deleted: 599cd.com/DeletedPREREQUISITES:Import Text: 599cd.com/ImportTextLINKS:Is Form Loaded: 599cd.com/IsLoadedRefresh v Requery: 599cd.com/RefreshVRequeryTroubleshooter: 599cd.com/TroubleRECOMMENDED COURSES:Access Developer Courses: 599cd.com/DeveloperCAUSES:Data deleted by delete queryData deleted by another userNetwork / Internet connectivity issuesConflicts in updating a recordCorrupted databaseIncompatible data typesHOW TO FIX:Refresh (Me.Requery) data – F5Check network / Internet connectionClose & reopen the databaseRestart WindowsCompact & RepairVerify data typesAccess Learning Zone Database TroubleshooterFREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, deleted error, records deleted, #deleted, network problems, conflicts in updates, corrupted data source, check network connection, check data source integrityQUESTIONS:Please feel free to post your questions or comments below. Thanks.
How to Determine if a Form is Loaded (Open) in Microsoft Access Computer Learning Zone 2023-08-14 | In this Microsoft Access tutorial, I will show you how to determine whether a form is currently open (loaded) in Microsoft Access. We will use this to determine if a specific form is open so that if it is, we can update a value on it if needed.Jeremy from Bethesda, Maryland (a Gold Member) asks: I have two forms in my database: one for a technician and another for the job that's assigned to him. On the technician form, I like to keep a count of how many jobs they have assigned. If I try to update this count from the job form and the technician form is closed, I get an error message. Is there any way to check if the technician form is open before I try to update that value?BECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: Is Form Loaded: 599cd.com/IsLoadedPREREQUISITES:Intro to VBA: 599cd.com/IntroVBACreate Function: 599cd.com/CreateFunctionLINKS:DCount: 599cd.com/DCountNz: 599cd.com/NzIs Form Loaded Code: 599cd.com/IsLoadedCodeError Handling: 599cd.com/ErrorHandlingRECOMMENDED COURSES:Access Developer Courses: 599cd.com/DeveloperCustom Functions: 599cd.com/acd2FREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Is loaded, isloaded, is form loaded, isformloaded, isopen, isformopen, is form open, how to tell if a form is loaded, how to tell if a form is open, Check if Form is open, close one form if another is closed, run-time error 2450, cannot find the referenced formQUESTIONS:Please feel free to post your questions or comments below. Thanks.
Data Sharing Simplified: Importing Text into a Microsoft Access Table Computer Learning Zone 2023-08-11 | In this Microsoft Access tutorial, I'm going to teach you how to import data from a text file into your database. We will use the file that we exported in yesterday's video. For the advanced VBA users, I'll demonstrate how to accomplish this with a single-click solution. We will also work with a delete query and an append query, and include a 'Are you sure?' message box for user confirmation.Silver members and up get access to an Extended Cut of this video. Members will once again see how to use TransferText to import the data with more advanced options in VBA.MEMBERS-ONLY EXTENDED CUT VIDEO: youtu.be/MWCQ5pedzLcBECOME A MEMBER:YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/joinor My Site: 599cd.com/THMemberLEARN MORE: Import Text: 599cd.com/ImportTextPREREQUISITES:Import Excel: 599cd.com/ImportExcelExport Text: 599cd.com/ExportTextIntro to VBA: 599cd.com/IntroVBADelete Query: 599cd.com/DeleteAppend Query: 599cd.com/AppendAre You Sure MsgBox: 599cd.com/MsgBoxLINKS:Access Runtime: 599cd.com/RuntimeBackup Access: 599cd.com/BackupImport Related: 599cd.com/ImportRelatedSuppress Warnings: 599cd.com/SuppressWarningsReferential Integrity: 599cd.com/ReferentialRECOMMENDED COURSES:Access Developer Courses: 599cd.com/DeveloperFREE TEMPLATE DOWNLOADS:TechHelp Free Templates: 599cd.com/THFreeBlank Template: 599cd.com/BlankContact Management: 599cd.com/ContactsOrder Entry & Invoicing: 599cd.com/InvoicingMore Access Templates: 599cd.com/AccessTemplatesADDITIONAL RESOURCES:FREE Access Beginner Level 1: 599cd.com/Free1How to Use Access in 30 Minutes: 599cd.com/30Minutes$1 Access Level 2: 599cd.com/1DollarDonate to my Tip Jar: 599cd.com/TipJarGet on my Mailing List: 599cd.com/YTMLContact Me: 599cd.com/ContactTechHelp: 599cd.com/TechHelpConsulting Help: 599cd.com/DevNetTwitter: twitter.com/LearningAccessen.wikipedia.org/wiki/Microsoft_Accessproducts.office.com/en-us/accessmicrosoft.com/en-us/microsoft-365/blog/accessKEYWORDS:access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Import Text, TransferText, run-time error 3127, the insert into statement contains the following unknown fieldQUESTIONS:Please feel free to post your questions or comments below. Thanks.
Introduction to Personal Computers, Lesson 06 of 06: Whats Next Computer Learning Zone 2023-08-10 | In this video, we'll discuss what topics come next in the series.FULL FREE COURSE:Introduction to Personal Computers: 599cd.com/IPCPLAYLIST:youtube.com/playlist?list=PLhKFRV3-UgpdpgYqMsaPmoxJsIMfsO4_NADDITIONAL RESOURCES:Get on my Mailing List: 599cd.com/YTMLTwitter: twitter.com/599CDKEYWORDS:pc basics, computer basics, intro to pcs, computer hardware, system components, basic definitions, PC vs Mac, data storage, peripherals, power protection, using the keyboard, keyboard keys, using the mouse, ergonomics, computer caveats, tips for beginners, turning on a computer, internal components, keyboard usage, mouse navigation, tips for new usersQUESTIONS:Please feel free to post your questions or comments below. Thanks.
Introduction to Personal Computers, Lesson 01 of 06: Computer Hardware, Part 1 Computer Learning Zone 2023-08-10 | In Lesson 1, we're going to delve into computer hardware. Initially, we'll explore the importance of understanding this aspect. You might wonder, why bother with computer hardware? After all, you simply turn on the computer and it functions, correct? The necessity of comprehending its internal workings will be our starting point. We'll then proceed to cover fundamental definitions, the comparison between PC and Mac, and an examination of the various system components housed within your computer.FULL FREE COURSE:Introduction to Personal Computers: 599cd.com/IPCPLAYLIST:youtube.com/playlist?list=PLhKFRV3-UgpdpgYqMsaPmoxJsIMfsO4_NADDITIONAL RESOURCES:Get on my Mailing List: 599cd.com/YTMLTwitter: twitter.com/599CDKEYWORDS:pc basics, computer basics, intro to pcs, computer hardware, system components, basic definitions, PC vs Mac, data storage, peripherals, power protection, using the keyboard, keyboard keys, using the mouse, ergonomics, computer caveats, tips for beginners, turning on a computer, internal components, keyboard usage, mouse navigation, tips for new usersQUESTIONS:Please feel free to post your questions or comments below. Thanks.
Introduction to Personal Computers, Lesson 05 of 06: Ricks Tips Computer Learning Zone 2023-08-10 | In Lesson 5, we'll dive into what I've coined "Rick's Tips." This segment is dedicated to exploring essential aspects such as ergonomics, potential computer caveats, and crucial points to keep in mind. Whether you're a seasoned user or just starting out, these insights will prove invaluable in ensuring your computing experience remains comfortable, efficient, and trouble-free. Additionally, we'll provide helpful tips tailored for newcomers, affectionately known as "noobs." This term is used endearingly and is meant to provide guidance to those taking their first steps in the digital world.FULL FREE COURSE:Introduction to Personal Computers: 599cd.com/IPCPLAYLIST:youtube.com/playlist?list=PLhKFRV3-UgpdpgYqMsaPmoxJsIMfsO4_NADDITIONAL RESOURCES:Get on my Mailing List: 599cd.com/YTMLTwitter: twitter.com/599CDKEYWORDS:pc basics, computer basics, intro to pcs, computer hardware, system components, basic definitions, PC vs Mac, data storage, peripherals, power protection, using the keyboard, keyboard keys, using the mouse, ergonomics, computer caveats, tips for beginners, turning on a computer, internal components, keyboard usage, mouse navigation, tips for new usersQUESTIONS:Please feel free to post your questions or comments below. Thanks.
Introduction to Personal Computers, Lesson 04 of 06: Using the Mouse Computer Learning Zone 2023-08-10 | In Lesson 4, we're going to delve into the world of mouse usage and navigation. We'll cover the fundamental techniques for effectively maneuvering the mouse across the screen. From basic clicking and scrolling to more advanced functions, you'll gain the skills needed to navigate seamlessly through various tasks and applications.FULL FREE COURSE:Introduction to Personal Computers: 599cd.com/IPCPLAYLIST:youtube.com/playlist?list=PLhKFRV3-UgpdpgYqMsaPmoxJsIMfsO4_NADDITIONAL RESOURCES:Get on my Mailing List: 599cd.com/YTMLTwitter: twitter.com/599CDKEYWORDS:pc basics, computer basics, intro to pcs, computer hardware, system components, basic definitions, PC vs Mac, data storage, peripherals, power protection, using the keyboard, keyboard keys, using the mouse, ergonomics, computer caveats, tips for beginners, turning on a computer, internal components, keyboard usage, mouse navigation, tips for new usersQUESTIONS:Please feel free to post your questions or comments below. Thanks.
