Пікірлер
@mosjany
@mosjany 15 сағат бұрын
great stuff , how do i re edit the data base when I need to update the db structure?
@skillheader
@skillheader 13 сағат бұрын
You have 2 options. Either save your Master ACCDB file to a certain location, copy it and apply all the methods of hiding and securing database, convert it to ACCDE. Second option is to keep your file as ACCDB, create a password protected form with buttons to hide/unhide and secure/unsecure database.
@nicemedia1
@nicemedia1 19 сағат бұрын
Thanksssss.. This is perfect tutorial👍 I need to be able to re edit database according to customer order !! How can I do it with this method? Thanks for your help 👏
@skillheader
@skillheader 13 сағат бұрын
You have 2 options. Either save your Master ACCDB file to a certain location, copy it and apply all the methods of hiding and securing database, convert it to ACCDE to publish. Second option is to keep your file as ACCDB, create a password protected form with buttons to hide/unhide and secure/unsecure database.
@nicemedia1
@nicemedia1 10 сағат бұрын
@skillheader Thanks I saved file as accdb with a password protection, but the problem is trust location unhide every things when log in form open for the first time!! I must set trust location manually then everything works perfectly. How to disable trust location or set it automatically? Thank for your help👍 Is there any way
@PatielChikobe
@PatielChikobe Күн бұрын
That's awesome your videos are always great personally i have ranked Skill Header as no.1 so far of all Ms Access tutorial have ever come across. Thanks for that good and great work.
@StetsonMgtSolutions
@StetsonMgtSolutions Күн бұрын
Very interesting indeed!
@yonasgossa4962
@yonasgossa4962 Күн бұрын
This video mainly shows how it functions, but it doesn’t go into detail about the activation key linked to the form. Have you completed this series, or are there more videos planned on this subject? Additionally, when can we expect the next installment of the Master Business Accounting and Digital Note series? We’re really looking forward to it! Thanks for sharing the video tutorial! It has a wealth of ideas to explore.
@skillheader
@skillheader Күн бұрын
You can always monitor the upcoming video or projects from home page skillheader.com/
@sunilpavar6667
@sunilpavar6667 2 күн бұрын
Suparb
@hansasare4078
@hansasare4078 2 күн бұрын
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?
@skillheader
@skillheader 2 күн бұрын
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/
@adrashidkhan8303
@adrashidkhan8303 2 күн бұрын
I am facing issues connecting with MySQL Database.
@skillheader
@skillheader 2 күн бұрын
Please join and raise your concerns in the below forum link. I will personally answer it for the benefits of others. skillheader.com/community/connecting-ms-access-with-sql-or-mysql-for-local-or-online/
@skillheader
@skillheader 2 күн бұрын
🔔 For next video timeline see News Board at skillheader.com/ 📚 Download Files by Subscription skillheader.com/master-business-accounting-project-subscription/ 📣 Join and Visit our Forum for Questions and Discussions skillheader.com/community/master-business-accounting-project-forum/ 🌍 Explore Blog on our Website skillheader.com/ ☕ Support Us with a Cup of Coffee skillheader.com/support-us/
@alaaaswad2122
@alaaaswad2122 3 күн бұрын
Very Good
@yonasgossa4962
@yonasgossa4962 3 күн бұрын
A huge thank you for all your hard work and dedication to enhancing the security features of MS Access! Your efforts have made a real difference in protecting our data and empowering developers to secure their code more effectively. I do have a question, though: the tutorial doesn’t cover how to retrieve the hard drive number, create a system where a user has lifetime access with a single password, or set up access that expires on a specific date. Could you also provide guidance on implementing an activation key?
@skillheader
@skillheader 3 күн бұрын
Thank you so much for the encouragement. Stay tuned, we are on it in upcoming videos of this series.
@raziq300
@raziq300 3 күн бұрын
Amazing Sir.
@vincentchikobe649
@vincentchikobe649 3 күн бұрын
This is really great and worth learning.Thanks a lot God bless you
@999juanrivera1
@999juanrivera1 3 күн бұрын
I love the concept of locking and not make it look like access on opening. thanks for the tutorial
@StetsonMgtSolutions
@StetsonMgtSolutions 3 күн бұрын
Very nice……your video was precise and very easy to follow. It is going to be fun to try it all out on my computer, after I have my coffee first of course! 😅
@arseyguy
@arseyguy 3 күн бұрын
Signed Up Today ....
@skillheader
@skillheader 3 күн бұрын
You have granted the access kzbin.info/www/bejne/hJfZYo2Fe72jg9k
@akokohjoel9854
@akokohjoel9854 4 күн бұрын
Thanks so much for your video. Pls Show us how to copy bulk data from one table to another table using VBA
@skillheader
@skillheader 4 күн бұрын
That is a great suggestion. I will try in furnish in future videos.
@arseyguy
@arseyguy 10 күн бұрын
I'm trying to open a records while double clicking a phone number. Below code was opening a form where customerID matches MemberID. DoCmd.OpenForm "CustomerMain", , , "CustomerID=" & Me.MemberID, , acDialog But while i linked it into Navigation Form It opens seperately not within that MainDashboard1. and i tried below code. DoCmd.OpenForm "Forms!MainDashBoard1!NavigationSubform!CustomerMain", , , "CustomerID=" & Me.MemberID, , acDialog But it give me error and doesn't open form now. What will be the code for this. Please Help
@arseyguy
@arseyguy 7 күн бұрын
Please help me if we can open form inside Navigation form or not? If yes then what will be the vba code for that.
@arseyguy
@arseyguy 4 күн бұрын
docmd.BrowseTo acBrowseToForm "CustomerMain","MainDashBoard.NavigationSubform" above code works fine it opens "Customain" form, But doesn't allow criteria like "CustomerID=" & Me.MemberID. I want the form to be open along with specific records. Please help
@StetsonMgtSolutions
@StetsonMgtSolutions 10 күн бұрын
Had a clue 🕵️ on some of these methods, but seeing what is coming is blowing my mind 😮. Signed up….
@skillheader
@skillheader 10 күн бұрын
It is great to see you on board.
@raziq300
@raziq300 9 күн бұрын
Sir free itni possible.... cannot afford.
@skillheader
@skillheader 10 күн бұрын
📚 Download skillheader.com/secure-and-lock-your-access-database/ 🌍 Explore Blog on our Website skillheader.com/ ☕ Support Us with a Cup of Coffee skillheader.com/support-us/
@khadimhussainmomin1315
@khadimhussainmomin1315 13 күн бұрын
hello Sir im you big fan from india AK if Same date have multiple entries how can it store in table and if fetch information on date how can we do that pl do Sir
@skillheader
@skillheader 12 күн бұрын
Good to see you. Hence, every table has a Primary Key ID field, so it doesn't matter how many or same date entries in a table.
@khadimhussainmomin1315
@khadimhussainmomin1315 12 күн бұрын
Do you have such video, if so kindly give me link. Thank you for your kindness and excellent content on you tube
@999juanrivera1
@999juanrivera1 15 күн бұрын
WOW I am into this project. Always learning new way to do things. I have a request can we add a date criteria lets say I have to do monthly or quaterly report. I lke to provide a start date and end date. can you show how to do this? I appriciate the work you put into the videos clear instructions and easy to follow. Than You.
@skillheader
@skillheader 15 күн бұрын
Date to Date, Weekly, Monthly, Quarterly reports will be included in upcoming videos with the Sales Invoices, Purchase Orders, and Salaries of Employees etc.
@999juanrivera1
@999juanrivera1 15 күн бұрын
@@skillheader You and your team are the best!
@skillheader
@skillheader Күн бұрын
For next video timeline see News Board at skillheader.com/
@MaazullahFarooq
@MaazullahFarooq 15 күн бұрын
Thank you very much, great work
@danishwahab3796
@danishwahab3796 16 күн бұрын
its great i love this channel😄😄😍😍
@arturkolakowski
@arturkolakowski 16 күн бұрын
Thanks for this video, good job, I learned a lot. I think the code fragment if myfileExt = "JPG" or myfileExt ="JPEG" then could be skipped because there is a .Filters property in the filedialog. By adding .Filters.Add "JPG images", "*.jpg", we only allow jpg files to be selected. Am I right?
@StetsonMgtSolutions
@StetsonMgtSolutions 17 күн бұрын
While creating the query I ran into the one thing that always causes me trouble and that is Access 365 does not recognize IF statements, has to be entered as IIF. Old habits...haha! If anyone has trouble and forgot as well...hope this helps.
@skillheader
@skillheader 16 күн бұрын
You are right. Perhaps, some Excel users can make this mistake.
@StetsonMgtSolutions
@StetsonMgtSolutions 17 күн бұрын
Super job! I like how this is coming together step by step. I am saving some of these vba techniques in my MZTools app…going to come in handy. I have many ideas, but I will wait until the final video is released to discuss with everyone. I am racking my brain to predict how you will continue to tie this together. Keep on keeping on folks!
@yonasgossa4962
@yonasgossa4962 17 күн бұрын
Waiting… For what is next. I cannot find the words to convey my appreciation to you.
@skillheader
@skillheader Күн бұрын
For next video timeline see News Board at skillheader.com/
@danishwahab3796
@danishwahab3796 17 күн бұрын
Dashboard video is missing
@skillheader
@skillheader 17 күн бұрын
kzbin.info/www/bejne/p5DYe3-phLt-jc0
@skillheader
@skillheader 17 күн бұрын
Please access the playlist of the project: kzbin.info/aero/PLO_ZMDiQrSzYd3pTZcfp3UT6_y0wJbE-S
@danishwahab3796
@danishwahab3796 17 күн бұрын
Thanks bro its awesome
@skillheader
@skillheader Күн бұрын
For next video timeline see News Board at skillheader.com/
@Koepinski
@Koepinski 19 күн бұрын
Great work! One of the best tutorials regarding to form-styling und functionality. Thanks a lot!
@yifrugizachew5249
@yifrugizachew5249 20 күн бұрын
Thank you i wait the next part7
@akmuneri
@akmuneri 21 күн бұрын
Awesome!
@MDBMIT
@MDBMIT 22 күн бұрын
Hey Skillheader! I just wanted to say how much I appreciate your work-your tutorials are always so insightful and helpful. I’m really looking forward to the next part of the project development video! Any idea when we might see it? Thanks for all you do!
@StetsonMgtSolutions
@StetsonMgtSolutions 22 күн бұрын
Will subscribers to this project automatically get source files?
@skillheader
@skillheader 22 күн бұрын
skillheader.com/master-business-accounting-project-subscription/
@PatielChikobe
@PatielChikobe 22 күн бұрын
Great video and thanks. But the blinking issue when filtering can it be solved?
@IbrahimMohamedJalloh-ie3sq
@IbrahimMohamedJalloh-ie3sq 23 күн бұрын
Thank you very much for the great work you are doing. it really very educative. But you are going to fast during formatting and doing the VBA coding. Could you please go slower a bit so that we can catch up as learners.
@Reijer59
@Reijer59 23 күн бұрын
I love your tutorials, they work and are a great way of education.
@Reijer59
@Reijer59 23 күн бұрын
At the end of the submit routine for the ForgotPassword Form I have added a textbox before closing the screen after update. Set recf = Nothing MsgBox "The new password has been set.", , "| Forgoten Password |" DoCmd.Close acForm, "frmForgotPassword", acSavePrompt Nowr the user is informed that the password is set again.
@horatiurotar6257
@horatiurotar6257 23 күн бұрын
You are the best!
@jeroenjong9802
@jeroenjong9802 23 күн бұрын
Very nice! Suggest to use table for item type for easier maintenance in future
@skillheader
@skillheader 24 күн бұрын
📚 Download Files by Subscription skillheader.com/master-business-accounting-project-subscription/ 📣 Join and Visit our Forum for Questions and Discussions skillheader.com/community/master-business-accounting-project-forum/ 🌍 Explore Blog on our Website skillheader.com/ ☕ Support Us with a Cup of Coffee skillheader.com/support-us/
@yasserelbighily6983
@yasserelbighily6983 24 күн бұрын
Well done,
@luigischiavone6460
@luigischiavone6460 24 күн бұрын
Beautiful
@HammaD.K
@HammaD.K 24 күн бұрын
Best video in youtube channel 👍
@yonasgossa4962
@yonasgossa4962 24 күн бұрын
Participating in the learning journey with you has significantly enhanced my knowledge. I sincerely appreciate all your efforts, Skill Header! I genuinely hope you continue to produce videos like this one on a regular basis.
@sahcida
@sahcida 25 күн бұрын
How do i get the logout option to go back to the login page upon closing?- I also want to tie in other function on the welcome page such as ( Logout, update records, new records, run query or reports)
@skillheader
@skillheader 24 күн бұрын
It is recommended to watch other playlists where a comprehensive dashboard opens after log in. The links of recommended projects are here: Budget and Expense Tracking System kzbin.info/aero/PLO_ZMDiQrSzZs1Feux-CSNhE3IZBCs5VA Expense Approval System kzbin.info/aero/PLO_ZMDiQrSzY1YyXDLro2idIY8jUTZ9E9 Task Management System kzbin.info/aero/PLO_ZMDiQrSzapIo7TFJO-T6c8znGePpAp Master Business Accounting kzbin.info/aero/PLO_ZMDiQrSzYd3pTZcfp3UT6_y0wJbE-S
@akmuneri
@akmuneri 25 күн бұрын
I'm excited!
@akokohjoel9854
@akokohjoel9854 26 күн бұрын
I also observe, you didn't use MySQL workbench. Again you use unbound form, I don't understand the vba code set rst what it means. Can you explain better, or do you have another video that explains it?
@skillheader
@skillheader 26 күн бұрын
rst is just a variable to define the table recordset. You can use this MySQL statement rather than to use rst. DoCmd.RunSQL "INSERT INTO first_tbl (name, amount, detail) VALUES (txt_name, txt_amount, txt_detail)" and if you got a popup message, bypass it by set warnings false like this DoCmd.SetWarnings False
@akokohjoel9854
@akokohjoel9854 26 күн бұрын
Pls I have a challenge, I observe that my form in ms access load slowly when Link to MySQL online. How can I increase the speed?
@skillheader
@skillheader 18 күн бұрын
The suggestion is to avoid unnecessary code with OnLoad event and use SQL statements to insert data into the table.
@akokohjoel9854
@akokohjoel9854 26 күн бұрын
Wahoo, I have been waiting for this, after you post for MS SQL with access. Thanks 🙏