Hello Sir and thanks for your nice videos. I have a big problem in first time open my database in other computer. Because bypass security automatically disable duo to trust location, so as result option meno and every things are visible..!! So I can't send my db to any one online, and I must go there and set the trust location manually and then everything works well. I want to the program works in any location without warning. Thanks.
Good morning sir, Your videos tutorial are very good and understandable. In your video, you created a developer master control, can you help with a full tutorial on how to create a developer master control form
Good evening sir, Your videos are very informative. In your video, you created a developer master control, can you help with a video on how to create a developer master control form.
@@EdcelleJohnGulfan hi sir, hope you are well, can you let me know the video of the form of developer master control pls because I need it in necessary
Hi Ed , Thank you for your helpful videos. I have a question regarding the login file mentioned in one of your videos. After entering the username and password, the ribbon is hidden as expected. However, the 'File' tab in the ribbon remains accessible, allowing users to open the options menu. Could you please advise on how to hide the 'File' tab both before and after the login file is opened?
First of all, i would like to thank you for watching my video. Please check this short video to address your concern. ua-cam.com/users/shorts_p1Ddn6DsjU?feature=share
@@EdcelleJohnGulfan Dear ED, Thank you for your Quick response; it is greatly appreciated. I am able to hide the toolbar ribbon successfully. However, upon login, Access displays the custom ribbon created by me, and the File tab appears, This allows users to open the Options menu from the File tab. I would like to prevent users from accessing or opening the Privacy Options. Best regards,
Good day sir Ed! I followed your tutorial and it helped me alot and also its user friendly. By the way, I want to open the access options via decelopers settings just like yours but i dont know how. Is there a code needed for it?
@@EdcelleJohnGulfan I also watched the login part 1 and another video which gave me an idea of redoing my login on my database. Now my Director Loves it. Thanks.
i have been watching your video on how to protect my access but i keep on getting on about my currentDb on the disabling and enabling the shift key. please can you help me fix that error. besides i don't know how to open the access option when i click on the open command option
Please, can you teach me how to open the login form when I open the system, but when I enter my name and password, the form opens for me, but the system does not open, so please, can you teach me how to configure my login form automatically to open the system. Please do not open the form for me, I am waiting for your answer
i did convert to 2 files = accde as FE & BE. However, users can only enter, modify data in the FE only if the read, write, modify access granted. And if this is granted, they can also view and modify codes. Thanks for your quick reply. @@EdcelleJohnGulfan
@@EdcelleJohnGulfan Thank you very much Bro. ED. I truly appreciate all your help. May God bless you and your family. I hope that I can personally thank you someday. Mag Bisaya sana ako pero jama-jama Bisaya ko Bro.
hi. one question. I have a database that is used by several users in the network at the same time. I have a problem during updating the database and I have to ask all users to close the file. Is there a way to solve this problem so that users don't have to close the database anymore when i want change codes or forms or other things?
I have a password for my MS Access database, however, for it's size almost reach 2 GB, I have to split it. Unfortunately, seems that splitting the database also make an easy way for some else to Access my database. Is there a way to protect both files.
Splitting the database is not a solution for 2gb limit. You can reduce the size by clicking the COMPACT & REPAIR. And the best way is to export your tables in SQL. Either MSSQL or MySQL SERVER. For reference, try this. ua-cam.com/video/6T1TvSoD_UE/v-deo.html
Hi i run your code but receive the message runtime error 3367 "cannot append. An object with that name already exists in the collection". I clicked debug and it hilite to the last line of code "CurrentDb.Properties.Append CurrentDb.CreateProperty("allowbypasskey", 1, false). How to fix this? Thanks a lot
Hello, at my work place we have a project for students grades, it is not working anymore, is there any way to fix it? Do you have an email or instagram so can contact you through it please Thank you so much
thumbs up to the great teacher. thanks a lot for the valuable tutorial
Thanks for watching.
Hi , Its Very Elegant and smart solution , works great
Thanks for watching.
bravo you are the best
Hello Sir and thanks for your nice videos.
I have a big problem in first time open my database in other computer. Because bypass security automatically disable duo to trust location, so as result option meno and every things are visible..!!
So I can't send my db to any one online, and I must go there and set the trust location manually and then everything works well.
I want to the program works in any location without warning.
Thanks.
Thanks
You are welcome. By the way thanks for watching.
Good morning sir, Your videos tutorial are very good and understandable. In your video, you created a developer master control, can you help with a full tutorial on how to create a developer master control form
As of now, try this short video. ua-cam.com/users/shortsR492MuN4Bt0?feature=share
Hi Sir Edcelle, is it possible to show the code behind your button to open the "File-Option" to open the "Access Option" Dialog.. Thank you so much..
Watch this...
ua-cam.com/users/shortsR492MuN4Bt0?si=fC-iUDb6VKGWUOOO
Good evening sir, Your videos are very informative. In your video, you created a developer master control, can you help with a video on how to create a developer master control form.
Yes. I will create a video for that.
@@EdcelleJohnGulfan hi sir, hope you are well, can you let me know the video of the form of developer master control pls because I need it in necessary
@@EdcelleJohnGulfan Hello Dear Bro. we'll be waiting. Thanks
Hi Ed , Thank you for your helpful videos. I have a question regarding the login file mentioned in one of your videos. After entering the username and password, the ribbon is hidden as expected. However, the 'File' tab in the ribbon remains accessible, allowing users to open the options menu. Could you please advise on how to hide the 'File' tab both before and after the login file is opened?
First of all, i would like to thank you for watching my video.
Please check this short video to address your concern.
ua-cam.com/users/shorts_p1Ddn6DsjU?feature=share
@@EdcelleJohnGulfan Dear ED,
Thank you for your Quick response; it is greatly appreciated.
I am able to hide the toolbar ribbon successfully. However, upon login, Access displays the custom ribbon created by me, and the File tab appears, This allows users to open the Options menu from the File tab.
I would like to prevent users from accessing or opening the Privacy Options.
Best regards,
Good day sir Ed! I followed your tutorial and it helped me alot and also its user friendly. By the way, I want to open the access options via decelopers settings just like yours but i dont know how. Is there a code needed for it?
Docmd.RunCommand acCmdOptions
Thanks for watching.
Hi Edcelle, I'm Mark and I am wondering if you have a video on how you made your Developers login form? thanks.
Hi Mark, thanks for watching my videos.
You can watch some parts of my Developer Control in my UA-cam Shorts videos.
@@EdcelleJohnGulfan I also watched the login part 1 and another video which gave me an idea of redoing my login on my database. Now my Director Loves it. Thanks.
Its most useful can you share this template
i have been watching your video on how to protect my access but i keep on getting on about my currentDb on the disabling and enabling the shift key. please can you help me fix that error. besides i don't know how to open the access option when i click on the open command option
I'll create a separate video about my master control. Soon i will upload.
By the Way, thanks a lot for watching.
1st Buddy, Hey I wanted to ask you something
Yup?
Sir, Customer want to see report from another office , how can i do ? i don't have idea, Could you help me Sir?
save the database in a shared local connection .
Please, can you teach me how to open the login form when I open the system, but when I enter my name and password, the form opens for me, but the system does not open, so please, can you teach me how to configure my login form automatically to open the system. Please do not open the form for me, I am waiting for your answer
Try this link. It's all about login form. ua-cam.com/play/PLxBRM3hoV3nPnbZUiW92Kgw-gPCeFlp48.html
I have a database that I splitted and put it in shared drive. Is there a way to protect the code? thanks a lot
Convert it to ACCDE format.
i did convert to 2 files = accde as FE & BE. However, users can only enter, modify data in the FE only if the read, write, modify access granted. And if this is granted, they can also view and modify codes. Thanks for your quick reply. @@EdcelleJohnGulfan
Once converted to accde format, vba codes are no longer visible.
Good Day Bro. Ed! How did you hide and unhide your MS Access Options Dialog Box the same as you have shown in this video?
Check this time 03:55
@@EdcelleJohnGulfan Bro. Ed Paano mo nagawa yung Open Command Option Button mo nag open sa DB Option?
On click event:
Docmd.RunCommand acCmdOptions
@@EdcelleJohnGulfan Thank you very much Bro. ED. I truly appreciate all your help. May God bless you and your family. I hope that I can personally thank you someday. Mag Bisaya sana ako pero jama-jama Bisaya ko Bro.
Salamat din sa pnonood Sir.
Hello Sir Edcelle Baka Pwede rin ba gumawa kayo ng water refilling System
Yes po. Nice idea. Parang POS lang din yan. Salamat
how to prevent MS Access Database file from copying? deleting and etc?
I have the same question too. I hope sbd could help us
How to create developer login like this
Hiding Ms Access Option: ua-cam.com/users/shortsR492MuN4Bt0?feature=share
@@EdcelleJohnGulfan thankyou
You're welcome
hi. one question. I have a database that is used by several users in the network at the same time. I have a problem during updating the database and I have to ask all users to close the file. Is there a way to solve this problem so that users don't have to close the database anymore when i want change codes or forms or other things?
open the design view of your form and go to form property, DATA, below is Record Locks. Check if it is NO LOCKS.
Paano ung pg open kusang log in ang lalabas
Ito po ang link. ua-cam.com/video/3DZVrPolX5w/v-deo.html
How to create form Developer Master control?
Nice question.
I will create a video for that Pak.
Thanks for watching.
@@EdcelleJohnGulfan
Same here waiting for it
Still waiting
I have a password for my MS Access database, however, for it's size almost reach 2 GB, I have to split it.
Unfortunately, seems that splitting the database also make an easy way for some else to Access my database.
Is there a way to protect both files.
Splitting the database is not a solution for 2gb limit.
You can reduce the size by clicking the COMPACT & REPAIR.
And the best way is to export your tables in SQL. Either MSSQL or MySQL SERVER.
For reference, try this. ua-cam.com/video/6T1TvSoD_UE/v-deo.html
how can i make open command option please
Type in your command button. OnClick()
DoCmd.RunCommand acCmdOptions
Thanks for the question.
@@EdcelleJohnGulfan Thank U very much
hellow Sir, how are you? , i want Open Command Option code
Docmd.RunCommand acCmdOptions
Thanks for watching Mamun
@@EdcelleJohnGulfan Thank you sir, i m following your all video
how to protect ms access from HxD
Sir how can i share my access database?
To me?😄
@@EdcelleJohnGulfan example is the person who I'll share my access doesn't have a functional access account what should i do
You are referring about User's Authority Rights
Check this ua-cam.com/video/8OKX3fY4-g4/v-deo.html
Hi i run your code but receive the message runtime error 3367 "cannot append. An object with that name already exists in the collection". I clicked debug and it hilite to the last line of code "CurrentDb.Properties.Append CurrentDb.CreateProperty("allowbypasskey", 1, false). How to fix this? Thanks a lot
Can I get in touch with you through email
Hi.
Email me at eduardogulfan@gmail.com
Hello, at my work place we have a project for students grades, it is not working anymore, is there any way to fix it? Do you have an email or instagram so can contact you through it please
Thank you so much
contact me at eduardogulfan@gmail.com or in whatsapp +63 933 655 6846.
Thanks