+ Reply to Thread
Results 1 to 2 of 2

VBA code for Login page

  1. #1
    Registered User
    Join Date
    09-17-2021
    Location
    Pune
    MS-Off Ver
    2108
    Posts
    2

    Exclamation VBA code for Login page

    Hi,

    I want to validate below two conditions below when the user is trying to log in. Please find attached the VBA table and the Form.
    (i) users not part of the department
    (ii) users not available in the system

    Access DB.png
    User Form.png

    Only users which are from the correct department must be able to log in. The Department dropdown value contains 5 departments as shown in the Access DB image.

    Please let me know if any additional information is required. Please help me with the code.


    Thanks
    Last edited by dalviaks1; 10-14-2021 at 01:03 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: VBA code for Login page

    You should be able to modify this tutorial to meet your needs

    https://www.youtube.com/watch?v=UO4HeWnuT3A
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Need help in login vba code to unhide specific sheets depends on login info
    By AlaaEddin95 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-12-2019, 08:19 PM
  2. Presentation login page
    By roofi in forum PowerPoint Formatting & General
    Replies: 1
    Last Post: 04-12-2016, 04:23 AM
  3. Web page - login code
    By keen2xl in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-10-2014, 12:59 AM
  4. [SOLVED] Page code appearing on login screen
    By Paul in forum Suggestions for Improvement
    Replies: 1
    Last Post: 06-12-2012, 04:45 AM
  5. Creating a login page with Excel
    By TammamD in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-13-2011, 03:18 AM
  6. how excel web query(*.iqy) handle the login page
    By sleepy_11 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-26-2008, 04:55 AM
  7. Login to Web Page and the Search Page for Text
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-19-2006, 10:55 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1