How to Create a Login System in Excel Using VBA

แชร์
ฝัง
  • เผยแพร่เมื่อ 26 พ.ย. 2024

ความคิดเห็น • 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

    • @DJOamen
      @DJOamen  3 ปีที่แล้ว

      👍

  • @xcb689
    @xcb689 2 ปีที่แล้ว

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

    • @DJOamen
      @DJOamen  2 ปีที่แล้ว

      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  2 ปีที่แล้ว

      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

  • @hossenahammed
    @hossenahammed 5 ปีที่แล้ว

    thank you.

    • @DJOamen
      @DJOamen  3 ปีที่แล้ว

      👍

  • @u_s_khan7618
    @u_s_khan7618 5 ปีที่แล้ว

    superb

    • @DJOamen
      @DJOamen  5 ปีที่แล้ว

      Thks

  • @缺口-q2z
    @缺口-q2z 3 ปีที่แล้ว

    is the cancel button redundant?

    • @DJOamen
      @DJOamen  3 ปีที่แล้ว

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

    • @缺口-q2z
      @缺口-q2z 3 ปีที่แล้ว

      @@DJOamen Thanks I see now.

  • @tiganiageed2458
    @tiganiageed2458 5 ปีที่แล้ว

    Excuse me which excel version has devoloper

    • @DJOamen
      @DJOamen  3 ปีที่แล้ว

      👍

  • @abdulrahmansac6693
    @abdulrahmansac6693 ปีที่แล้ว

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

    • @DJOamen
      @DJOamen  ปีที่แล้ว

      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.

  • @IamEffiom
    @IamEffiom 5 ปีที่แล้ว

    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  5 ปีที่แล้ว

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

    • @IamEffiom
      @IamEffiom 5 ปีที่แล้ว

      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

  • @JohnsonKongor
    @JohnsonKongor 5 ปีที่แล้ว

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

    • @DJOamen
      @DJOamen  5 ปีที่แล้ว

      Type in DJ Oamen on the TH-cam search or you can enter Captain Paul Oamen and it will take you to my TH-cam channels. Have a nice one bro. See the links below.
      th-cam.com/users/LANDCARZYfeatured
      th-cam.com/users/LANDCARZYvideos

  • @kirtankpatel
    @kirtankpatel 5 ปีที่แล้ว

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

    • @DJOamen
      @DJOamen  3 ปีที่แล้ว

      👍

  • @aswadelkindy8464
    @aswadelkindy8464 3 ปีที่แล้ว

    hi, can i get your email thanks

    • @DJOamen
      @DJOamen  3 ปีที่แล้ว +1

      Only, if is for business and you pay up front