How to Create a Login System in Excel Using VBA

Поделиться
HTML-код
  • Опубликовано: 14 июн 2019
  • How to Create a Login System in Excel Using VBA, with a link to Excel Data Entry System, see link below:
    Join this channel to get access to codes, and perks, and see more interesting videos. / @djoamen
    To support more videos from DJ Oamen, visit POamen Paypal
    www.paypal.me/POamen
    To Become a Channel member click on the link below to JOIN:
    / @djoamen
    For more interesting video tutorials, visit my second channel: / pauloamen
    Channel Members can Download the Login System in Excel Using VBA source code, and modify it for their own personal use. Plus one other source code per month. Total - 2 Source codes Per Month, only:
    docs.google.com/spreadsheets/...
    • How To Create An Excel...
    See Links to other SQLite Database Tutorials below:
    How to Create Student Database Management Systems using SQLite in Visual Basic.Net
    • How to Create Student ...
    How to Create Student Database Management Systems using SQLite in Java NetBeans
    • How to Create Student ...
    How to Create an Employee Database Management Systems using SQLite in Java NetBeans
    • How to Create an Emplo...
    How to Create Student Database Management System using SQLite in python
    • How to Create Student ...
    How to Create a Library Database Management Systems with GUI in Python
    • How to Create Library ...

Комментарии • 34

  • @ashrafabdallaattyaelfeky2639
    @ashrafabdallaattyaelfeky2639 5 лет назад +2

    This work is wonderful and very interesting I hope you attended to be a number of users and able to change the password ... Thank you very much sir for all the offers of new projects and codes

  • @hossenahammed
    @hossenahammed 5 лет назад

    thank you.

  • @u_s_khan7618
    @u_s_khan7618 5 лет назад

    superb

  • @xcb689
    @xcb689 Год назад

    Hi capt, can you share the full tutorial? Im one of your subscriber. Thanks a lot.

    • @DJOamen
      @DJOamen  Год назад

      4th of Sep 2022, Excel_VBA_Loan was shared with you, which means you are only entitled to one more source code, but you have clicked on over ten projects. You will have to decide which one of those projects you would like me to share with you. See note below
      Channel Members can Download one project source code and modify it for their own personal use. Plus one other source code per month.
      Total - 2 Source codes Per Month, only:

    • @DJOamen
      @DJOamen  Год назад

      Sent, check your email.
      Channel Members can Download one project source code and modify it for their own personal use. Plus one other source code per month.
      Total - 2 Source codes Per Month, only:
      You now have a total of TWO project source codes sent to you for this month.
      Joined • 28 days ago

  • @IamEffiom
    @IamEffiom 4 года назад

    Hello
    Pls I have a problem which needs a solution
    I want to know how to load multiple excel sheets as tables in SSIS
    In such a way that the sheets in an excel file becomes SQL table
    Examples an excel file named Customer with sub sheets with names credentials and products
    They will be loaded to SQL Server as different tables with names dbo.credentials and dbo.products
    A video would be well appreciated
    Thanks

    • @DJOamen
      @DJOamen  4 года назад

      Try Microsoft Power App, it may be a solution to your problem, good luck.

    • @IamEffiom
      @IamEffiom 4 года назад

      Actually I am using SQL Server Data Management software and Visual Studio
      I have seen much videos but they don't point to what I want

  • @tiganiageed2458
    @tiganiageed2458 5 лет назад

    Excuse me which excel version has devoloper

  • @JohnsonKongor
    @JohnsonKongor 4 года назад

    I want to take some courses from your training site. Please send me the URL to register.

    • @DJOamen
      @DJOamen  4 года назад

      Type in DJ Oamen on the RUclips search or you can enter Captain Paul Oamen and it will take you to my RUclips channels. Have a nice one bro. See the links below.
      ruclips.net/user/LANDCARZYfeatured
      ruclips.net/user/LANDCARZYvideos

  • @abdulrahmansac6693
    @abdulrahmansac6693 9 месяцев назад

    Suppose I open normal excell page means log in page automatically log out,what is the solution

    • @DJOamen
      @DJOamen  8 месяцев назад

      If you're experiencing an issue where you open a normal Excel workbook and it automatically logs you out, there could be a few reasons for this behavior. Here are some common causes and potential solutions:
      1. **Workbook Contains Macros**: If the Excel workbook contains macros or VBA code that is set to run automatically when the workbook is opened, it may be performing actions that log you out. Check the workbook for macros and VBA code, and review their functionality. You can disable macros or modify the code if necessary.
      2. **Workbook Contains External Connections**: If the workbook is linked to external data sources (e.g., databases, web services) and the connection settings are incorrect or require authentication, it could cause you to be logged out. Check the workbook's data connections and ensure they are properly configured.
      3. **Add-Ins or COM Add-Ins**: Certain add-ins or COM add-ins can affect the behavior of Excel and potentially cause issues with automatic logouts. Try disabling any add-ins one by one and see if the problem persists. You can do this by going to `File` > `Options` > `Add-Ins`.
      4. **Windows Security Policies**: In some cases, Windows security policies or group policies may be configured to automatically log out users after a certain period of inactivity. This is typically a system-level setting and not specific to Excel. Check with your IT department to see if any such policies are in place.
      5. **Network or VPN Issues**: If you are accessing Excel files over a network or through a VPN, network disruptions or authentication issues could lead to automatic logouts. Ensure your network connection is stable and properly authenticated.
      6. **Excel Version or Updates**: Outdated versions of Excel or missing updates may have known issues that can cause unexpected behavior. Ensure you are using the latest version of Excel and have installed all available updates.
      7. **Shared Workbook Settings**: If the workbook is shared among multiple users, the shared workbook settings might be configured in a way that causes automatic logouts. Check the sharing settings and review them as needed.
      8. **Check for Automatic Logout Scripts**: If you are in a corporate environment, administrators may have implemented scripts or policies that log users out of Excel or other applications automatically. Consult your IT department to rule out this possibility.
      9. **Corrupted Workbook**: In rare cases, a corrupted Excel workbook could exhibit unusual behavior, including automatic logouts. Try opening other Excel workbooks to see if the issue is specific to one file. If it is, you may need to recover or recreate that particular workbook.
      10. **User Account Issues**: Verify that your user account is properly configured and does not have any restrictions or settings that would cause automatic logouts.
      If you've ruled out the above possibilities and the issue persists, it may be helpful to provide more specific information about the circumstances of the automatic logout and any error messages encountered. This additional information can aid in diagnosing and resolving the problem.

  • @kirtankpatel
    @kirtankpatel 5 лет назад

    Could you make a baby medication reminder information system in java netbeans...it would help me soo much

  • @user-tp6bh1cd3v
    @user-tp6bh1cd3v 2 года назад

    is the cancel button redundant?

    • @DJOamen
      @DJOamen  2 года назад

      See 9 minutes into the video tutorial, you will see the function for the cancel button.

    • @user-tp6bh1cd3v
      @user-tp6bh1cd3v 2 года назад

      @@DJOamen Thanks I see now.

  • @aswadelkindy8464
    @aswadelkindy8464 2 года назад

    hi, can i get your email thanks

    • @DJOamen
      @DJOamen  2 года назад +1

      Only, if is for business and you pay up front