This is exactly what I needed. I have been afraid of Access ever since a few unsuccessful attempts at using it decades ago. After this course, I now love Access and can't wait to learn all of its ins and outs. Thank you so much, Trish! You are an excellent teacher!
As a Microsoft Access fan, I love these lessons so much that I cannot get enough of them. I intend to review them over and over again. These hands-on lessons are very practical. Trish, you do excellent work!
@@LearnitTraining You are welcome. I look forward to supporting your channel. Microsoft Access feels like a favorite application program, slightly above Microsoft Word to me, because I use it a bit more creatively. I began using Microsoft Access 2002 with my first microcomputer in that year. I tried some techniques in Microsoft Office XP Professional, and never looked back ever since. I still use Microsoft Word, but mostly for tasks that would have been done on a typewriter, plus more. Thank you for tapping or typing to me.
Thanks Trish great course again. Had a couple of issues and inconsistencies with trying the VBA modules to what was on screen but other than that, great
I learned so much watching your great tutorials. I would really appreciate if you help me with a problem I faced: The code provided in exercise files to lock a form by password doesn't work properly for me. When I want to open the employee form it requires the password but it opens the form anyway after the error window even if the password is wrong.
A note....your mic sometimes almost blows out my eardrums. It hurts to wear the headphones. I keep turning them down, then end up turning it up when you lean away from the mic. It's very harsh. Do you run an effects rack on your vids...? Doesn't sound like you need Noise Reduction cuz it sounds like you use a Noise Gate. But it doesn't sound like you're using a limiter (in audiobooks, we Normalize to -3dB, and for YT there is a similar limit that can also be done with a Normalizer.) Any extremely loud peaks in the audio waveform can be easily seen and squished manually or with a plugin. It's the mid-tones that are soooooooo loud at times. Happens quite a bit throughout the vids. Just figured I'd give a couple extra tips for your channel stuff, since you're doing these amazing videos.
Thank you! Yes, we have had some audio issues and when we used a limiter previous is just muffled everything too much. We have adjusted since then so hopefully this isn't an issue in any future videos. Thank you again for the great feedback!
Great presentation. Thank you Please i need your help I created two forms from two different tables. i want to enter only the PatientID from the first form so all the remaining patient details will be filled in the second form. How can i do that? i will be grateful if you can help me.
Beautiful tutorial. Im a beginner in ms access. I have a simple question. I have a single table where i want to subtract from two numerical fields with condition. For example Text1 minus text2 where condition ..... And second condition. Need assistance. Regards
To subtract two numerical fields with a condition in Access, you can use the expression builder. Here are the steps: Open the table in Design View. Click on the field where you want to display the result of the subtraction. In the Field Properties pane, click on the “…” button next to the Control Source property. In the Expression Builder, type the following formula: =[Field1] - [Field2] where Field1 and Field2 are the names of the fields you want to subtract. If you want to add a condition, you can use the IIf function. For example, if you want to subtract Field2 from Field1 only when Field3 is greater than 10, you can use the following formula: =IIf([Field3]>10,[Field1]-[Field2],0). I hope this helps!
@@LearnitTraining Thnx Sir. It will be very helpful for me. Another query. My condition looks like ( as mentioned earlier). "Field1 - Field2 Where Field3 Value = 1 Or Field3 Value = 2." But I don't know the proper syntax. Additionally can I use sum function in your illustration Sir. Like " IIF Field3 > 10 then field 2 = sum (Field3). Never seen any such tutorial as to how to use sum function in ms access forms ( not query), which is much easier in Excel.
Regarding the macro to hide the employee field if the checkbox is unselected? Uh...you click it again to add the check and the field doesn't come back. Exit that form and then go back to that entry, and it's back even if the box doesn't have a checkmark. Pretty big bug there.
Within the macro created for the checkbox, add an 'else if' statement checking if Active is true then make employee field visible again. However, the problem you'll still see is from switching record to record. Active users will not show the employee field until clicking the Active box off/on. The fix for that is to do the same 'if else if' statement macro we did for the checkbox but this time on the form itself by selecting 'Form' from the dropdown in the 'Property Sheet'. Add the macro to the event 'On Current'.
Hi, where are the practice files for the beginner, advanced, and expert stages? The practice files posted in the descriptions for the three Access 2021 tutorial videos are all the same and they don't contain sample tables, forms, queries, reports etc like the 2016 practice files did. Please update the 2021 practice files. Thank you.
Umm....the vba code for password-protecting a form isn't complete, cuz if you type in the wrong password you get the message, but the moment you click ok, it goes to the form anyway, lol. And I still kinda feel like Notion is better for smaller biz, lol.
Thanks for the tuts. Some great stuff - btw your VBA code is wrong; there is nothing in the vba code block which closes the form. You need to put DoCmd.Close acForm, "frmEmployees" before each exit Sub statement. ____________________________________________ Private Sub Form_Load() 'Code to Password Protect a Form 'Used on OnLoad Event Dim Passwd Passwd = InputBox("Enter Password", "Restricted Form") 'Check to see if there is any entry made to input box, or if 'cancel button is pressed. If no entry made then exit sub. If Passwd = "" Or Passwd = Empty Then MsgBox "No Input Provided", vbInformation, "Required Data" DoCmd.Close acForm, "frmEmployees" Exit Sub End If 'If correct password is entered open Employees form 'If incorrect password entered give message and exit sub If Passwd = "Learnit!" Then DoCmd.OpenForm "frmEmployees", acNormal Else MsgBox "Sorry, you do not have access to this form", _ vbOKOnly, "Important Information" DoCmd.Close acForm, "frmEmployees" Exit Sub End If End Sub
This is exactly what I needed. I have been afraid of Access ever since a few unsuccessful attempts at using it decades ago. After this course, I now love Access and can't wait to learn all of its ins and outs. Thank you so much, Trish! You are an excellent teacher!
Great to hear!
As a Microsoft Access fan, I love these lessons so much that I cannot get enough of them. I intend to review them over and over again. These hands-on lessons are very practical. Trish, you do excellent work!
Thank so much again Captain Keyboard! We hope we keep making videos you like!
@@LearnitTraining You are welcome. I look forward to supporting your channel. Microsoft Access feels like a favorite application program, slightly above Microsoft Word to me, because I use it a bit more creatively. I began using Microsoft Access 2002 with my first microcomputer in that year. I tried some techniques in Microsoft Office XP Professional, and never looked back ever since. I still use Microsoft Word, but mostly for tasks that would have been done on a typewriter, plus more. Thank you for tapping or typing to me.
You people are more than a gem, May Almighty bless you all...
Thank you!
This is youtube gold. Very helpful tutorial.
Thanks!
Thank you so much for such an inclusive and rich course. I enjoyed watching it and learnt a lot. Highly appreciated.🤘
Glad it was helpful!
Thanks Trish great course again. Had a couple of issues and inconsistencies with trying the VBA modules to what was on screen but other than that, great
Fantastic tutorial. I learned a lot. I really appreciate Trish.
Glad it was helpful!
love it very informative! thank you Trish.
You are so welcome!
Thank you so much!! Good Tutorial.
Glad it was helpful!
I learned so much watching your great tutorials. I would really appreciate if you help me with a problem I faced: The code provided in exercise files to lock a form by password doesn't work properly for me. When I want to open the employee form it requires the password but it opens the form anyway after the error window even if the password is wrong.
This article may help: support.microsoft.com/en-us/office/encrypt-a-database-by-using-a-database-password-12aa0e5c-34c6-4957-af3b-b5f5cfa9a766
A note....your mic sometimes almost blows out my eardrums. It hurts to wear the headphones. I keep turning them down, then end up turning it up when you lean away from the mic. It's very harsh. Do you run an effects rack on your vids...? Doesn't sound like you need Noise Reduction cuz it sounds like you use a Noise Gate. But it doesn't sound like you're using a limiter (in audiobooks, we Normalize to -3dB, and for YT there is a similar limit that can also be done with a Normalizer.) Any extremely loud peaks in the audio waveform can be easily seen and squished manually or with a plugin.
It's the mid-tones that are soooooooo loud at times. Happens quite a bit throughout the vids.
Just figured I'd give a couple extra tips for your channel stuff, since you're doing these amazing videos.
Thank you! Yes, we have had some audio issues and when we used a limiter previous is just muffled everything too much. We have adjusted since then so hopefully this isn't an issue in any future videos. Thank you again for the great feedback!
amazing thank you
You are very welcome!
thanx
You're welcome!
Great presentation. Thank you
Please i need your help
I created two forms from two different tables. i want to enter only the PatientID from the first form so all the remaining patient details will be filled in the second form. How can i do that? i will be grateful if you can help me.
Hello James! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
Beautiful tutorial. Im a beginner in ms access. I have a simple question. I have a single table where i want to subtract from two numerical fields with condition. For example
Text1 minus text2 where condition .....
And second condition. Need assistance. Regards
To subtract two numerical fields with a condition in Access, you can use the expression builder. Here are the steps:
Open the table in Design View.
Click on the field where you want to display the result of the subtraction.
In the Field Properties pane, click on the “…” button next to the Control Source property.
In the Expression Builder, type the following formula: =[Field1] - [Field2] where Field1 and Field2 are the names of the fields you want to subtract.
If you want to add a condition, you can use the IIf function. For example, if you want to subtract Field2 from Field1 only when Field3 is greater than 10, you can use the following formula: =IIf([Field3]>10,[Field1]-[Field2],0).
I hope this helps!
@@LearnitTraining Thnx Sir. It will be very helpful for me. Another query. My condition looks like ( as mentioned earlier). "Field1 - Field2 Where Field3 Value = 1 Or Field3 Value = 2." But I don't know the proper syntax. Additionally can I use sum function in your illustration Sir. Like " IIF Field3 > 10 then field 2 = sum (Field3). Never seen any such tutorial as to how to use sum function in ms access forms ( not query), which is much easier in Excel.
Regarding the macro to hide the employee field if the checkbox is unselected? Uh...you click it again to add the check and the field doesn't come back. Exit that form and then go back to that entry, and it's back even if the box doesn't have a checkmark. Pretty big bug there.
We definitely agree and noted!
Within the macro created for the checkbox, add an 'else if' statement checking if Active is true then make employee field visible again. However, the problem you'll still see is from switching record to record. Active users will not show the employee field until clicking the Active box off/on. The fix for that is to do the same 'if else if' statement macro we did for the checkbox but this time on the form itself by selecting 'Form' from the dropdown in the 'Property Sheet'. Add the macro to the event 'On Current'.
good day. In my form for the active field the check box is displayed as a true / false instead of a check box . how do i fix that
Hello Dajour! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
Hi, where are the practice files for the beginner, advanced, and expert stages? The practice files posted in the descriptions for the three Access 2021 tutorial videos are all the same and they don't contain sample tables, forms, queries, reports etc like the 2016 practice files did. Please update the 2021 practice files. Thank you.
Noted!
41:44
How to create mutil langauge in ms access form?
Hi Pak! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
The frmEmployees password did not work. Hit enter a second time go me into the data.
Thank you for the tip!
Umm....the vba code for password-protecting a form isn't complete, cuz if you type in the wrong password you get the message, but the moment you click ok, it goes to the form anyway, lol. And I still kinda feel like Notion is better for smaller biz, lol.
Thank you for pointing that out! We agree on Notion being better as well!
Hi 👋
Hello!
Thanks for the tuts. Some great stuff - btw your VBA code is wrong; there is nothing in the vba code block which closes the form. You need to put
DoCmd.Close acForm, "frmEmployees"
before each exit Sub statement.
____________________________________________
Private Sub Form_Load()
'Code to Password Protect a Form
'Used on OnLoad Event
Dim Passwd
Passwd = InputBox("Enter Password", "Restricted Form")
'Check to see if there is any entry made to input box, or if
'cancel button is pressed. If no entry made then exit sub.
If Passwd = "" Or Passwd = Empty Then
MsgBox "No Input Provided", vbInformation, "Required Data"
DoCmd.Close acForm, "frmEmployees"
Exit Sub
End If
'If correct password is entered open Employees form
'If incorrect password entered give message and exit sub
If Passwd = "Learnit!" Then
DoCmd.OpenForm "frmEmployees", acNormal
Else
MsgBox "Sorry, you do not have access to this form", _
vbOKOnly, "Important Information"
DoCmd.Close acForm, "frmEmployees"
Exit Sub
End If
End Sub
Thanks for the tip!
Thanks! Makes a lot more sense now.