🔔 For next video timeline see News Board at skillheader.com/ 📚 Download Files by Subscription skillheader.com/master-business-accounting-project-subscription/ 🌍 Complete Overview of the Project skillheader.com/building-master-business-financial-accounting-in-ms-access/ 📣 Join and Visit our Forum for Questions and Discussions skillheader.com/community/master-business-accounting-project-forum/ ☕ Support Us with a Cup of Coffee skillheader.com/support-us/
I have no words to thank you. I have been working in Access for the last 15 years but after watching your video I realized that actually I have learned the real work from you today. Honestly today I am very happy and a new enthusiasm and passion has arisen within me that I will watch all your videos and write a diary. One most important thing is that I have never liked or subscribed to any video till date but you made me do it as if I had found a precious treasure
Very good…this is my first run through and already my excitement meter is pegging out. Many improvements coming for my current project, as well completing this endeavor!
Sir, you are a superb developer. I have never seen it before. Your videos are more informative and valuable. Thank God I got your chhanel, Sir, I completely watched your video Part-1, and I did the same, but when I login through user1 (not admin) the first time all menu is enabled, when close the file and reopen the Main Dashboard through user login, then it work properly., that means every first time not working properly (enabled all menu), please suggest how to solve this issue.
Nice content, well explained and video developed to suit all of my needs as far as company accounting and finance. Been trying to keep my model updated to your progress. I am eager to see what comes next. Thanks!!
great work, but in a financial project the passwords of the employees have to be stored encrypted. can you add that to your project that would be great
Thanks for the support. What I think is that MS Access Database has no such environment as cookies or any third-party app like browsers on the web, so there is no need to use such encryption in MS Access. However, securing the backend tables and data from the front-end users is the responsibility of the programmer. On the other hand, you are using Access Database mostly amongst local network-attached computers.
very Helpfull, i have question wouldn't be better if we add the profile credential to a table where they can be add updated easily rather that making them column. in case we need to add more buttons probabbly in different form.
Thank you very much, very good engineer, good luck, keep growing like this, and record the same kind of great videos for us, and if you record the second part, leave it for us, and we will also like and subscribe.
Thanks so much for your videos especially this project. It's really helping me a lot with my new project for a company...However the user responsibilities with respect to the Profile is not working well..When i log in as user, it will be given me access to the admin responsibilities, and also when i log in as admin, it will be given me limited responsibilities like you did for the user profile...I have checked all the codes and textbox names which everything is fine, but the profile responsibilities is still not working well.. Sometimes I will have to login twice for both user and admin before it will work. I don't see where the problem is...Please can you help?
Yes, you are doing right. Please join and create a topic in the forum mentioned below so I can answer it for the benefit of all. skillheader.com/community/master-business-accounting-project-forum/
got to the end and found that the value of admin remians and when loged on as user i have the admin setting i have to run through it two times to get the correct results. I try the debug.print on the aProfile and result is 0. Can you check on your end or do we need a routing to reset on exit or log off. V/r Juan
@@skillheader Found the solution user I moved the aProfile DLOOKUP above the main dashboard open from. this way I can set the value of me.txtusername before the main form opens. if below the dashboard open call all .fields will be 0 hope this explains. Overall this is a very nice set up and a graet tutorial thanks for the awsome work.
Hello Skill Header, About a month ago, you mentioned, "Thank you for your patience. We will be back soon to continue our journey." However, it appears that this promise hasn’t been kept. The removal of the previously uploaded video raises concerns about your commitment to sharing your insights. Many subscribers have been eagerly asking for the next part of the video, but it seems their requests have gone unnoticed.
@@skillheaderHello Skillheader, I really want to thank you for your hard work in getting the video back on track! If it's not possible to continue with the "Master of Business Accounting in MS Access," I would greatly appreciate it if you could complete the "Digital Notes Database in MS Access." I feel that having unfinished tasks can lead to some mental discomfort. Thank you in advance for your prompt reply. I’m eager to hear from you!
That's fine. You may proceed from the tables but as we are not creating the forms bound to the table fields, you can consider the forms as the part of the planning tables.
I went back to restart from scratch as I got too big for my britches and started adding stuff I shouldn't have. All is good now except at the end I do not have profile control over the Accounts page when it is set to 0. All other navigation buttons work as presented by you. Looked high and low for differences in settings and/or vba code...cannot find anything. Would you have a suggestion as to why only one navigation button would not follow the OnLoad code for the Main Dashboard, while the others do?
The only issue I seem to be having is once you log in and it opens up the dashboard, the menu items are disabled based on the security. However, closing the window and reopening it then implements the security. Maybe I have some other code in the login or dashboard form interferring?
Awesome tutorial, but there is a glitch in your code acting weird!! Ufound = 0 then.... When i put this, the login page doesn't accept any username or password, even if they are correct!! Ufound = 1 or -1 The loging page accept any username or password even if they are wrong !! Any ideas?
Thanks for liking the video. There is no issue is my code as it is working perfectly. Please make sure the references you are giving in the "dcount" function is correct based on the table fields.
@@skillheader Sorry if my feedback annoy you! The Glitch is still there, i googled it and it turns out that the dcount must be used in another way with certain versions of office Access! Anyway, the tutorial was awesome and the design you provided is clean and beautifull ! Thank you
i have a small issue, it happens in your code aswell, changing user profiles does not impact the state of the Navigation buttons, see at 1:00:53, when i log in as admin, i have to close the form manually and then reopen it to see the change, how do i fix this?
@@skillheader Part 4 is hidded. Playlist shows 4 videos but when we open this playlist, it shows only 3 videos and about 4th video, it says " 1 unavailable video is hidden". anyways, plz provide direct link/url for this 4th video
![[#2024MAMA] BIGBANG (빅뱅) - 뱅뱅뱅 (BANG BANG BANG) + FANTASTIC BABY | Mnet 241123 방송](http://i.ytimg.com/vi/EQsYfiPR9uM/mqdefault.jpg)
🔔 For next video timeline see News Board at skillheader.com/
📚 Download Files by Subscription
skillheader.com/master-business-accounting-project-subscription/
🌍 Complete Overview of the Project
skillheader.com/building-master-business-financial-accounting-in-ms-access/
📣 Join and Visit our Forum for Questions and Discussions
skillheader.com/community/master-business-accounting-project-forum/
☕ Support Us with a Cup of Coffee
skillheader.com/support-us/
Sir please one database like quick book need
How to create
Multiple projects like constructions, logistics.....
I have no words to thank you. I have been working in Access for the last 15 years but after watching your video I realized that actually I have learned the real work from you today. Honestly today I am very happy and a new enthusiasm and passion has arisen within me that I will watch all your videos and write a diary. One most important thing is that I have never liked or subscribed to any video till date but you made me do it as if I had found a precious treasure
Thank you so much! Your support means a lot to me. I'm glad my videos can bring some joy to your day.
Master Business Accounting Part 11 has been launched
th-cam.com/video/8hMb3Lbqhrs/w-d-xo.html
Very good…this is my first run through and already my excitement meter is pegging out. Many improvements coming for my current project, as well completing this endeavor!
This will benefit us a lot , many many thanks
It is great to have your valuable appreciation.
Terimakasih tutorialnya sangat luar biasa, izin download
skillheader.com/download-skillheader-projects-tutorials/
Thanks, your Projects are great and very stylish!👍🎉
Sir, you are a superb developer. I have never seen it before. Your videos are more informative and valuable. Thank God I got your chhanel, Sir, I completely watched your video Part-1, and I did the same, but when I login through user1 (not admin) the first time all menu is enabled, when close the file and reopen the Main Dashboard through user login, then it work properly., that means every first time not working properly (enabled all menu), please suggest how to solve this issue.
Please see the description of the video for the solution. Thanks for your valuable comment, it means a lot to me.
Master Business Accounting Part 11 has been launched
th-cam.com/video/8hMb3Lbqhrs/w-d-xo.html
Great work. Thank sir your best and easiest way teaching.❤
Glad to have your love for my videos. I am trying my best to deliver the knowledge in the best way.
I want to create inventory management app, your vedios very helpful
great work love from India
It is always great to have your valuable appreciation and suggestions.
I want to thank you for ur valuable video
Nice video.
Thankssss.🤝
Hope you make a video for electrotronic attendance 👍
Thank you so much! Your support means a lot to me.
Best place to learn and great efforts. Please nclude product with multiple quantities it will help full to most of the people's
Great work! One of the best tutorials regarding to form-styling und functionality. Thanks a lot!
great job love from Myanmar 🎉🎉🎉
th-cam.com/video/ppxPnQnazOQ/w-d-xo.html
Thank you very much, great work
Thank you man, great video, Master Class Content is very useful, Plz Upload
th-cam.com/video/ppxPnQnazOQ/w-d-xo.html
Thank you man, great video clean design very stylish an polite, useful.
Congrats from Barcelona (Catalonia)
It is great to have your valuable appreciation.
sir, your content is valuable, please notice the unclear text/option bar
Sir Excellent waiting for next video for next step same
th-cam.com/video/ppxPnQnazOQ/w-d-xo.html
Nice content, well explained and video developed to suit all of my needs as far as company accounting and finance. Been trying to keep my model updated to your progress. I am eager to see what comes next. Thanks!!
Thanks for your support. Stay tuned, there is a lot more than you expect.
great work, but in a financial project the passwords of the employees have to be stored encrypted. can you add that to your project that would be great
Thanks for the support. What I think is that MS Access Database has no such environment as cookies or any third-party app like browsers on the web, so there is no need to use such encryption in MS Access. However, securing the backend tables and data from the front-end users is the responsibility of the programmer. On the other hand, you are using Access Database mostly amongst local network-attached computers.
very Helpfull, i have question wouldn't be better if we add the profile credential to a table where they can be add updated easily rather that making them column. in case we need to add more buttons probabbly in different form.
We will make a functional profile form under the preferences navigation in the future of this series. Stay tuned.
Excellent video. ❤❤
Clean work
Awesome tutorial. What version of Access are you using and whats the name of the font used in vba coding
Thanks for your support and liking. I am using Microsoft Office 2019 and the font in VBA coding is "JetBrains Mono SemiBold".
thanks you so much
th-cam.com/video/ppxPnQnazOQ/w-d-xo.html
Thanks for this great explanation, how can we download the samples?
Thanks for the comment and support. You will be able to download it after the completion of the project.
Thank you very much, very good engineer, good luck, keep growing like this, and record the same kind of great videos for us, and if you record the second part, leave it for us, and we will also like and subscribe.
th-cam.com/video/ppxPnQnazOQ/w-d-xo.html
excellent
th-cam.com/video/ppxPnQnazOQ/w-d-xo.html
Thanks so much for your videos especially this project. It's really helping me a lot with my new project for a company...However the user responsibilities with respect to the Profile is not working well..When i log in as user, it will be given me access to the admin responsibilities, and also when i log in as admin, it will be given me limited responsibilities like you did for the user profile...I have checked all the codes and textbox names which everything is fine, but the profile responsibilities is still not working well.. Sometimes I will have to login twice for both user and admin before it will work. I don't see where the problem is...Please can you help?
Yes, you are doing right. Please join and create a topic in the forum mentioned below so I can answer it for the benefit of all.
skillheader.com/community/master-business-accounting-project-forum/
got to the end and found that the value of admin remians and when loged on as user i have the admin setting i have to run through it two times to get the correct results. I try the debug.print on the aProfile and result is 0. Can you check on your end or do we need a routing to reset on exit or log off.
V/r
Juan
I will help you with this. Email me at contact@skillheader.com
@@skillheader Found the solution user I moved the aProfile DLOOKUP above the main dashboard open from. this way I can set the value of me.txtusername before the main form opens. if below the dashboard open call all .fields will be 0 hope this explains. Overall this is a very nice set up and a graet tutorial thanks for the awsome work.
Hello ... Can we see all those parts which were uploaded before. Thanks in advance
We have refined and unlocked all of our videos.
skillheader.com/downloads/
th-cam.com/video/ppxPnQnazOQ/w-d-xo.html
The next two videos are listed as private. When will you make them available again? Thank you.
We are live with refined and unlocked all videos for you
th-cam.com/play/PLO_ZMDiQrSzYd3pTZcfp3UT6_y0wJbE-S.html
th-cam.com/video/ppxPnQnazOQ/w-d-xo.html
Good job my friend
Thank you so much! Your support means a lot to me.
Hello Skill Header,
About a month ago, you mentioned, "Thank you for your patience. We will be back soon to continue our journey." However, it appears that this promise hasn’t been kept. The removal of the previously uploaded video raises concerns about your commitment to sharing your insights. Many subscribers have been eagerly asking for the next part of the video, but it seems their requests have gone unnoticed.
All are available and we are on track now
th-cam.com/play/PLO_ZMDiQrSzYd3pTZcfp3UT6_y0wJbE-S.html
@@skillheaderHello Skillheader,
I really want to thank you for your hard work in getting the video back on track! If it's not possible to continue with the "Master of Business Accounting in MS Access," I would greatly appreciate it if you could complete the "Digital Notes Database in MS Access." I feel that having unfinished tasks can lead to some mental discomfort. Thank you in advance for your prompt reply. I’m eager to hear from you!
th-cam.com/video/ppxPnQnazOQ/w-d-xo.html
Why develop forms before tables? As I’ve been told that’s the “wrong” way around. So I’m curious for the reason!😊
That's fine. You may proceed from the tables but as we are not creating the forms bound to the table fields, you can consider the forms as the part of the planning tables.
I went back to restart from scratch as I got too big for my britches and started adding stuff I shouldn't have. All is good now except at the end I do not have profile control over the Accounts page when it is set to 0. All other navigation buttons work as presented by you. Looked high and low for differences in settings and/or vba code...cannot find anything. Would you have a suggestion as to why only one navigation button would not follow the OnLoad code for the Main Dashboard, while the others do?
nevermind, I am the one with fat fingers. all is good....loving the outcomes....now to start part 2
Glad it worked. Keep it up encouraging and supporting by sharing with others.
Upload Complete Master Class
th-cam.com/play/PLO_ZMDiQrSzYd3pTZcfp3UT6_y0wJbE-S.html
th-cam.com/video/ppxPnQnazOQ/w-d-xo.html
The only issue I seem to be having is once you log in and it opens up the dashboard, the menu items are disabled based on the security. However, closing the window and reopening it then implements the security. Maybe I have some other code in the login or dashboard form interferring?
From the Login Button code Move this Code line:
aprofile = DLookup(".............
Before this:
DoCmd.OpenForm "..........
Awesome tutorial, but there is a glitch in your code acting weird!!
Ufound = 0 then....
When i put this, the login page doesn't accept any username or password, even if they are correct!!
Ufound = 1 or -1
The loging page accept any username or password even if they are wrong !!
Any ideas?
Thanks for liking the video. There is no issue is my code as it is working perfectly. Please make sure the references you are giving in the "dcount" function is correct based on the table fields.
@@skillheader
Sorry if my feedback annoy you!
The Glitch is still there, i googled it and it turns out that the dcount must be used in another way with certain versions of office Access!
Anyway, the tutorial was awesome and the design you provided is clean and beautifull ! Thank you
i have a small issue, it happens in your code aswell, changing user profiles does not impact the state of the Navigation buttons, see at 1:00:53, when i log in as admin, i have to close the form manually and then reopen it to see the change, how do i fix this?
Move the line "aprofile=....." in your LOGIN Form's LOGIN Button before Docmd.Openform....
@@skillheader thank you so much
Iɴ ᴛʜɪs ғᴏʀᴍ ᴄʀᴇᴀᴛᴇ ᴀ ᴄᴏʟʟɢᴇ sᴛᴅᴜᴇɴᴛ ᴅᴀᴛᴀ ғᴇᴇ ʀᴇᴄᴏʀᴅ
I'll definitely consider making a complete project on this topic.
What is part 4 coming out
Thanks for your patience. We are coming back soon to continue the journey.
th-cam.com/video/ppxPnQnazOQ/w-d-xo.html
Next Part is hidden.....
No issue found, all videos in the playlist are fine.
@@skillheader Part 4 is hidded. Playlist shows 4 videos but when we open this playlist, it shows only 3 videos and about 4th video, it says " 1 unavailable video is hidden". anyways, plz provide direct link/url for this 4th video
th-cam.com/video/ppxPnQnazOQ/w-d-xo.html
This website has been deactivated
We are restoring...
We are live now...
Awesome tutorial. What version of Access are you using and whats the name of the font used in vba coding
Thanks for your support and liking. I am using Microsoft Office 2019 and the font in VBA coding is "JetBrains Mono SemiBold".