Edcelle John Gulfan

Edcelle John Gulfan

I'm here to help you learn from BASIC to ADVANCE MS Access programming.

In my 12+ years of solid experience in ACCESS and VBA, I'm glad to share with you some techniques, tips and tricks to level up your database.

You can download here some FREE SOURCE CODE / FREE TEMPLATE for your reference.

Before you leave, please don't forget to subscribe this channel.

Thanks for visiting and watching my videos.

For business, you can contact me at the following:
Email address: [email protected]

Whatsapp: +63 933 655 6846

Facebook:
Ed Perez Matugas Gulfan
#microsoftaccesstutorial #microsoftaccess #mstutorial #msaccess #mysqldb #mysqltutorials #mysql

App Password in Gmail

App Password in Gmail

Пікірлер

  • @ekponoabasiakwaowo6236
    @ekponoabasiakwaowo623610 сағат бұрын

    Found this really helpful, thanks!

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan8 сағат бұрын

    You're welcome and thanks for watching this video.

  • @RashidJaved
    @RashidJaved15 сағат бұрын

    Hello sir

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan8 сағат бұрын

    Hi Sir.

  • @devonfernando1254
    @devonfernando1254Күн бұрын

    Very useful. Thank you

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan22 сағат бұрын

    You're welcome

  • @raedajailat9958
    @raedajailat9958Күн бұрын

    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?

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfanКүн бұрын

    First of all, i would like to thank you for watching my video. Please check this short video to address your concern. kzread.info_p1Ddn6DsjU?feature=share

  • @niranjanreddy3620
    @niranjanreddy36203 күн бұрын

    How to edit in sql after import

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan2 күн бұрын

    Check this video. kzread.info/dash/bejne/nYCAydOkhtmXeKg.html

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan2 күн бұрын

    By the way, thanks for watching!

  • @shabrinaalifah446
    @shabrinaalifah4464 күн бұрын

    Mohon bantuannya cara bikin pasword di form data barang dan form transaksi

  • @jopaz3780
    @jopaz37804 күн бұрын

    Bakit mo delete yung tut sa coding ng send email sir?

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfanКүн бұрын

    Check mo ulit sir.

  • @user-ry6us4ry9v
    @user-ry6us4ry9v4 күн бұрын

    Very helpful vedio still on 2024.

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan4 күн бұрын

    Thanks for watching.

  • @RungeCarl
    @RungeCarl4 күн бұрын

    Brilliant!!!

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan4 күн бұрын

    Thanks for watching carl.

  • @IanRoySegovia
    @IanRoySegovia5 күн бұрын

    Pangmalakasan sir, sir ask po sana ako if paano po if around 5000 na po yung id at yung ibang tab po is ibang table na connected po via relationship sa employeeID at yung ibang tab ay many to many relationship po sa employeeID po. Patulong po sana sir.

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan4 күн бұрын

    Same concept parin sir. Dapat may common ground sila like ID number para sa parent and child link.

  • @IanRoySegovia
    @IanRoySegovia4 күн бұрын

    @@EdcelleJohnGulfan thank you po sir. may video ka po ba for parent and child link? normalized nmn po yung tables with foreign key from employeeID table. at yung ibang table may foreign key din sa ibang table. if may video ka po sana para sa mga functions nato. 1. pwede po ba mag add ng search box at list box with view record functions para pwede po ma view lahat ng related records kasama sa tabs (katulad this video na instead employee id dropdown searchbox at list box po para sa result) 2. list box per tab para po sa records for add/edit delete/ na related po sa For. Ex. SalaryTable. . Please po. ito po kasi yung main functions na hinahanap ko sir edcelle

  • @mohamedwado8363
    @mohamedwado83636 күн бұрын

    thanks

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan5 күн бұрын

    Welcome

  • @bisyrim1030
    @bisyrim10306 күн бұрын

    thanks

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan5 күн бұрын

    Welcome

  • @terakuma1977
    @terakuma19776 күн бұрын

    I needed this for work, I've never used access before and never created a database, I need to make a whole FAQ for the call centre. Any other of your videos would you recommend that would help?

  • @Rishighosh007
    @Rishighosh0077 күн бұрын

    can u get ur contact number ? i have some doubts it will be great if i could talk to you in person over call

  • @hauwaahmedy
    @hauwaahmedy8 күн бұрын

    Hello and good day, my question here is when will you post the full video on how to create the Loan Database?

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan7 күн бұрын

    Maybe this year. From scratch until deployment to Sql server.

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan7 күн бұрын

    By the way, thank you for your interest.

  • @salihedris4183
    @salihedris41838 күн бұрын

    thank you for the video really helpfull, is there any possibility to have the copy of this project please! thank you!!

  • @CaptCaveman-nn3cn
    @CaptCaveman-nn3cn9 күн бұрын

    Good video but please lose the music ffs I turned it off after 30 seconds, but then came back and turned OFF the sound. So really didnt hear any narration if you did any so I really didnt learn much.

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan9 күн бұрын

    I feel you that's why I created this new version. kzread.info/dash/bejne/oYWIxa6Jhs3RiZc.html

  • @mrmir8279
    @mrmir82799 күн бұрын

    Are you registered on freelance sites? Share me your account

  • @renevanloon7726
    @renevanloon772610 күн бұрын

    Good day Thanks for the tutorial, it helped me a lot,👍 but I have a question: is it possible to make it so that you can also add and display PDF files?

  • @user-qi3yz6pf4e
    @user-qi3yz6pf4e10 күн бұрын

    Dear Mr. John, I really enjoyed watching this tutorial. However, when I try to follow it, I get an error. It seems that Access does not recognize what F_Productlist is

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan10 күн бұрын

    That's the name of the form. You can set your own name.

  • @Dev.Tutorials
    @Dev.Tutorials10 күн бұрын

    just wow

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan10 күн бұрын

    Thanks for watching.

  • @danadan7553
    @danadan755312 күн бұрын

    Wery good thanks lot

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan11 күн бұрын

    Thanks for watching.

  • @jopaz3780
    @jopaz378012 күн бұрын

    Error po yung .Addattachment Me.Attachment ko pa help tanx

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan11 күн бұрын

    What's the error message?

  • @jopaz3780
    @jopaz378010 күн бұрын

    @@EdcelleJohnGulfan Supported pa po ba yung SMTP sa msaccess today sir?

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan7 күн бұрын

    Yes sir. Im still using it and lots of my clients are still using also. Watch my latest video on how to generate App password in Gmail.

  • @giordanocarbajalblas104
    @giordanocarbajalblas10413 күн бұрын

    The method seems great, but how to apply it if the front end must distribute it to several users? I understand that the shortcut can not be distributed as a total but should send the base file, and if I do this then I should create the shortcut on all users computers manually? I appreciate your answer

  • @serikmirmanov5680
    @serikmirmanov568014 күн бұрын

    how create automate filing the field with next data ID 00001-2024 (current year), 00002-2024 etc?

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan13 күн бұрын

    kzread.info/dash/bejne/imF8x85_l7qbj84.html

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan13 күн бұрын

    Another kzread.info/dash/bejne/p6xsq9CdfdinZrA.html

  • @maharlikanophirian7952
    @maharlikanophirian795214 күн бұрын

    Hi sir, I was enjoying watching your educational videos. Can you make video specifically on price update without affecting historical price.

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan13 күн бұрын

    Sure I will.

  • @danvertolones8182
    @danvertolones818214 күн бұрын

    Boss may ibang way kapa po ba kase ang need kong i import almost 9995 ang na import lang 9694

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan14 күн бұрын

    Check mo data type nyan boss bakit di na export lahat.

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan14 күн бұрын

    Pinakamabilis is to export in ms access din export to mysql. Less than 2 minutes.

  • @youngminchoi4098
    @youngminchoi409814 күн бұрын

    Thanks. Fought against ChatGPT for hours

  • @dlaw4251
    @dlaw425115 күн бұрын

    Thanks. You saved me

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan14 күн бұрын

    I'm glad it helps.

  • @wimschiphorst8541
    @wimschiphorst854115 күн бұрын

    One more ad. To clean the fields when the form opens. I now made a button for this at the form

  • @wimschiphorst8541
    @wimschiphorst854115 күн бұрын

    Hi, Good Video. One question. After a Set Command here opening a recordset I thought you always must close it. like rs.close set rs = Nothing.

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan14 күн бұрын

    Well, Not really necessary although you can bypass setting the recordset to nothing and will not encounter any error. It is the best practice to set the recorset to nothing after you closed it especially when you have no use to that recordset or you will not going to access the same recordset again.

  • @farhansharifofficial5315
    @farhansharifofficial531515 күн бұрын

    What if i want to do this in google sheets?

  • @Jojosmith342
    @Jojosmith34215 күн бұрын

    all thumbs up to the best teacher. already subscribed. thanks for the great tutorial

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan15 күн бұрын

    Thanks for watching.

  • @aidanazihahabdullah
    @aidanazihahabdullah16 күн бұрын

    Thank you so much for this tutorial !

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan15 күн бұрын

    You are welcome. Thanks also for watching!

  • @akokohjoel9854
    @akokohjoel985416 күн бұрын

    Thanks 🙏 for the video

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan16 күн бұрын

    Thanks for watching brother.

  • @abdulhamidalhaddadi2255
    @abdulhamidalhaddadi225519 күн бұрын

    GREAT, I WILL TRY SOON

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan18 күн бұрын

    Thanks for watching Abdul.

  • @RodMcClaskey
    @RodMcClaskey19 күн бұрын

    Hi Edcelle, I'm getting a -2147220982 The SMTP server name is required and was not found in the configuration source, error. Also, how do I get a copy of your code for testing. Thanks Rod

  • @tauqirabbas27
    @tauqirabbas2719 күн бұрын

    Hi, thank you for a fantastic insight. Can you make a search while you type with an option of choosing between two date range? And also export to excel, PDF etc or print list.

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan15 күн бұрын

    Ok soon

  • @timothyassam8098
    @timothyassam809820 күн бұрын

    Nice Thank You..

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan14 күн бұрын

    You are welcome.

  • @AB-qk7yw
    @AB-qk7yw20 күн бұрын

    This worked! Thank you, I would recommend using the names of fields; I had to keep pausing to see what you were referring to.

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan20 күн бұрын

    Thanks for watching. I'm glad it helps.

  • @MohdKarim1977
    @MohdKarim197721 күн бұрын

    Dear Sir, how can i get the VBA codes for this menu

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan21 күн бұрын

    You can download this sample database. The download link is in the description of the video.

  • @MohdKarim1977
    @MohdKarim197720 күн бұрын

    @@EdcelleJohnGulfan it's not working properly

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan14 күн бұрын

    What's the error?

  • @fontie38
    @fontie3821 күн бұрын

    Sir what is the VtrSelectItem?

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan21 күн бұрын

    That's a Temporary Variable for Selected item or item to select. The value of that variable will appear in the file dialog box after selecting a file.

  • @richtercastanares740
    @richtercastanares74023 күн бұрын

    Sir good day. Thank you for this tutorial videos. it helps me a lot. Sir I created ad multi-field search form using the union query. I want to open the specific record in a form but the problem is it will open all the records with the same ID. how can i change the numbering in ID field so that it will no longer duplicate?

  • @andrispikarevskis5513
    @andrispikarevskis551324 күн бұрын

    Perfect! I spent half day to make this with GPT4 but after 5 minutes it is done!

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan23 күн бұрын

    Thank you for watching. Your comment is highly appreciated.

  • @CAME-ALONE2114
    @CAME-ALONE211424 күн бұрын

    Please how to create two table with different topics

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan24 күн бұрын

    Table with sub table?

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan24 күн бұрын

    kzread.info/dash/bejne/no14lLt_fZa5m5M.html

  • @CAME-ALONE2114
    @CAME-ALONE211423 күн бұрын

    @@EdcelleJohnGulfanyes please with different tittles

  • @HusnaSadat-fo4zt
    @HusnaSadat-fo4zt25 күн бұрын

    Please, dear teacher, I need it. Can you give us a tutorial on how to make a great menu in Access? Please, I am waiting for your answer. I tried a lot but I couldn't.

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan24 күн бұрын

    My available video for menu. kzread.info/head/PLxBRM3hoV3nPV4DSHkZCZXvzgOr3cyOzf&si=ZWTWsPcZCt-heXkY

  • @RupeshSahu-vz7qj
    @RupeshSahu-vz7qj25 күн бұрын

    Alt + =

  • @gilbertquaye1571
    @gilbertquaye157126 күн бұрын

    Thank you

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan24 күн бұрын

    You're welcome

  • @mrtrader3661
    @mrtrader366126 күн бұрын

    how to highlight specific record (last record in the table) on page load?

  • @EdcelleJohnGulfan
    @EdcelleJohnGulfan23 күн бұрын

    I'll create a video on this.

  • @HusnaSadat-fo4zt
    @HusnaSadat-fo4zt27 күн бұрын

    Can you teach us how to make this type of minnow in a supplementary form? Dear teacher, thank you