Hi, Deborah I would like to extend my heartfelt gratitude for your exceptional lecture Form of MS Access 2019. Your thorough and insightful presentation has significantly enhanced my understanding of how to use Form efficiently. Your dedication and expertise are truly commendable, and I deeply appreciate the effort you put into making the material accessible and engaging. Thank you for your invaluable contribution to my learning journey. --- Feel free to personalize it further if you'd like!
Thank you so much for your kind words! I'm thrilled to hear that the lecture helped enhance your understanding of MS Access 2019. Your feedback means a lot! 🤩
can i remove that status column on the left of the form? you don't see that in the design view of the form, but when you are in the form view you will see that vertical black line from top to bottom.
Really like this tutorial -- Two suggestions: Would like it if you zoomed in more when talking about a certain area. Everything is so small it's too hard to see. Also, captioning would be helpful. I also have a comment: I always hide my ID field by making the field, border and text the same color as my background. I don't see that it's necessary for my users to see this field.
Thanks a bunch for the positive feedback! We're stoked that you found the course awesome! 😊 We have additional free tutorials for MS Access tutorials here 👉 th-cam.com/play/PLzj7TwUeMQ3g7dabQhzlqljY-bnxv1YFA.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! TH-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► th-cam.com/users/simonsezittraining ♥️ We appreciate your support!
I have a tabular form where there is a column called ABScore which has 5 rows each row against each row, which means there are 5 records under ABScore Col. Now I want to row number 1 will loop through other 9 records and compare with other rows. If row number 1 carries highest value, then it will put 1 to the column next to it since it secured highest point. Similarly, the second row will compare value with other 4 rows i. e. Rows 1, 3, 4 and 5 and make appropriate ranking against it's corresponding rank row. But I don't know the way how to do it. I'm from India where scope to learn is very small. Therefore request you to please make a tutorial on updating records by looping. Thnx and regards.
Thank you so much for the video. I have a question. I use my access database daily, but today when I close my form that has subforms, I get the message "No current record". I don't know what has happened, it was not doing till yesterday. The first form has 2 subform. I used to get two of the message "No Current Record". when I deleted the first subform, I only got one message but when I deleted the second one, I did not get none. I have been working with database for 15 years, I never got this message until yesterday. one more thing, I also get it when I hit add new record. did microsoft access change the coding? Will you please, help solve this problem? Thanks in advance
Another comment: On the subforms part 2 it looked like she was going to explain how to use one form for two functions; 1) to add/edit and 2) to display for users. It's confusing because she just modifies the subform to be viewed by users, but then how would the staff edit it if it's the same form? Very confusing.
Thank you Kou Naren! We recently uploaded a 7-hour beginner and advanced course, if you need additional MS Access training -> th-cam.com/video/jCG2MTH9Ftw/w-d-xo.html
Sorry, we've noticed that the link sometimes doesn't load recently but one workaround that I found helpful was to open the download link in a new private/incognito browser. Hope that helps!
Deborah is wonderful instructor. I love the way she explains things. Thank you.
Thank you for sharing your knowledge via this video. Deborah has a nice tone of voice and good pace of explaining MS Access.
Hi, Deborah
I would like to extend my heartfelt gratitude for your exceptional lecture Form of MS Access 2019. Your thorough and insightful presentation has significantly enhanced my understanding of how to use Form efficiently. Your dedication and expertise are truly commendable, and I deeply appreciate the effort you put into making the material accessible and engaging. Thank you for your invaluable contribution to my learning journey.
---
Feel free to personalize it further if you'd like!
Thank you so much for your kind words! I'm thrilled to hear that the lecture helped enhance your understanding of MS Access 2019. Your feedback means a lot! 🤩
Thank you so much ,Deborah. The way you present is quite interesting!
I learned many things from this video , many thanks
Wow, thanks! Glad it was helpful. 🤩
@SimonSezIT - Not exercise files are included in download link, please update the download zip to include the missing exercise files. Thank you.
can i remove that status column on the left of the form? you don't see that in the design view of the form, but when you are in the form view you will see that vertical black line from top to bottom.
Really like this tutorial -- Two suggestions: Would like it if you zoomed in more when talking about a certain area. Everything is so small it's too hard to see. Also, captioning would be helpful. I also have a comment: I always hide my ID field by making the field, border and text the same color as my background. I don't see that it's necessary for my users to see this field.
Thanks for the great effort and I hope you keep streaming the Access videos
More to come!
I did not find what I was looking for here, but it was a decent tutorial nonetheless, picked up a few new things.
Thank you. Only this way I'm able to understand the access
That is really amazing!
This is a really well done tutorial that answered all the questions I was trying (and failing) to figure out with other resources.
Glad to hear!
great course ! Thank you so much
Thanks a bunch for the positive feedback! We're stoked that you found the course awesome! 😊
We have additional free tutorials for MS Access tutorials here 👉
th-cam.com/play/PLzj7TwUeMQ3g7dabQhzlqljY-bnxv1YFA.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
TH-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► th-cam.com/users/simonsezittraining
♥️ We appreciate your support!
Excellent Tutorial, very well articulated.
Glad you think so!
Last exercise is too much of a rush, so many tasks given in such a short time I don't really know what I'm supposed to be producing.
VERY USEFUL, THANKS SO MUCH!!!
You're welcome!
I have a tabular form where there is a column called ABScore which has 5 rows each row against each row, which means there are 5 records under ABScore Col. Now I want to row number 1 will loop through other 9 records and compare with other rows. If row number 1 carries highest value, then it will put 1 to the column next to it since it secured highest point. Similarly, the second row will compare value with other 4 rows i. e. Rows 1, 3, 4 and 5 and make appropriate ranking against it's corresponding rank row. But I don't know the way how to do it. I'm from India where scope to learn is very small. Therefore request you to please make a tutorial on updating records by looping. Thnx and regards.
Thank you so much for the video. I have a question. I use my access database daily, but today when I close my form that has subforms, I get the message "No current record". I don't know what has happened, it was not doing till yesterday.
The first form has 2 subform. I used to get two of the message "No Current Record". when I deleted the first subform, I only got one message but when I deleted the second one, I did not get none.
I have been working with database for 15 years, I never got this message until yesterday. one more thing, I also get it when I hit add new record. did microsoft access change the coding? Will you please, help solve this problem? Thanks in advance
Quite guiding. Thanks a lot dear tutor
Very good presentation.
Thanks for watching Kumaran!
Great video!!! Thanks!!
Glad you enjoyed it. Thanks for watching! 🙂
The files I got when I signed up was not the same as in the tutorial. I got some files about movies.
Lol, I never even got any files so....
Another comment: On the subforms part 2 it looked like she was going to explain how to use one form for two functions; 1) to add/edit and 2) to display for users. It's confusing because she just modifies the subform to be viewed by users, but then how would the staff edit it if it's the same form? Very confusing.
I cannot get these files to send
Thanks :) (Made me laugh when you said "recorded in Nov-2019", because at this time you still could travel)
The exercise files provided are not the correct files for this tutorial.
Nice
it is helpful
Thank you Kou Naren! We recently uploaded a 7-hour beginner and advanced course, if you need additional MS Access training -> th-cam.com/video/jCG2MTH9Ftw/w-d-xo.html
Excellent
Thank you so much 😀
Superb 👌
Thanks 🤗
Screen is fuzzy.
Why do you make it impossible to get your files?
Sorry, we've noticed that the link sometimes doesn't load recently but one workaround that I found helpful was to open the download link in a new private/incognito browser. Hope that helps!
I found that I could not download them directly, but if you save them to a dropbox account first, you can then download them from the account.
Magnificent
design view looks nothing like its end result ...
ms 🙄
Exemplary
Thanks Dominic, i appreciate that.
i think u said same things over and over again but thx
Thanks for your feedback. Hope you’ve enjoyed the tutorial
👌👌👌👌👌
🥰
fake
Wish it was in American accent, I find this accent very annoying and distracting, thumbs down