Microsoft Access VBA # 1 | How to enable and disable field

now i will show you how to enable  and disable field using button   okay let's start first i will go to design then i will add text box so this text box i will change to txt let's say name then i will add button here i will see in the option i will put caption enable disable now we will put some code  if we will click this one   automatically this particular text box or field  will disable again just select this one we put   name text txt name for this file in  textbox then we will select enabler i will select this one then go  to event then on click then txt name dot enable equal false look if i click this one this file or this text  box will be disabled log coming disabled however   if i click this one still our text box is  enabled now we will put some code to check   if this particular text box  or film enabled or disabled okay again we'll select this button  then here we'll put some f statement if txt name that enable then txt name equals first so meaning  if this text box or file is enabled   so we will change to disabled else if txt name that enable so again if this text box is enabled  then automatically will change to disable if it is text box is   disabled meaning we will enable that's why we  put txt name equal true so to make it enable okay look if i click this one this text box is disabled now since we  put some code to check if this textbox or   fill this enabler disable that's why  if we will click this one since this is   disabled automatically it will become enabled look if i click this one automatically disable but  since this is disabled if i will click again   automatically it will enable however  this cursor we must put on the focus here after we click this one suppose our cursor  will focus on any text box or fill so now   i will put our cursor after click this one our  cursor must be put in our button here as our focus okay i will select again then  go to one click then here after click this one takes the name of the label  then our cursor must be focus on our cmd action that set   focus so that every time we will click our  cursor will back to our button not here look this one but if you click this one  our course seller will not came here   if we put here our cursor but if  i click again it will back to our   so this is how to enable or disabled  failed thank you and god bless you

Channel: 🅺🅰🅼🅰🆈🅾 🅰🅺🅾

Views: 1,137

Rating: 5 out of 5

Keywords: MsExcel, MsAccess, Ms Access Tutorial, Ms Excel Tutorials, Microsoft Excel Tutorial, Microsoft Access Tutorial, KamayoAko, Kamayo Ako, #KamayoAko, #Kamayo Ako, kamayoako, kamayo ako

Id: jLz7pO0tFKU

Length: 7min 32sec (452 seconds)

Published: Fri Nov 06 2020