• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Login Form to access username ,Password & Type

Nitesh Khot

Member
Hi all.......

i am unable to get coding for attached file.
i want to create login form as per user type.
suppose i select admin and login then admin manager file open if not then it hide.
 

Attachments

  • Macros File.xlsx.xlsm
    23.4 KB · Views: 16
Hi,

To check if the data entered in the text box (user id or password) available in the database you need to use a find method

Also to combine to if statements you cannot use '&' instead you have to use And

I have done changes to your file

Check out and revert incase any further requirement
 

Attachments

  • Macros File.xlsm
    21.2 KB · Views: 14
Hi,

To check if the data entered in the text box (user id or password) available in the database you need to use a find method

Also to combine to if statements you cannot use '&' instead you have to use And

I have done changes to your file

Check out and revert incase any further requirement
 
hi...
Its working but i want code llike.
I have entered username and password ,type in admin manger file....admin manager file is hidden only open after admin login....and other login type is user...like HR pass...Hr@123 type,,USER.

IN SHORT AUTHORITY USER NOT HAVE AUTHORITY TO LOGIN AS ADMIN.
 
Hi,

Refer the attached file.

I have removed the access type combobox since it will be there in data base and user need not select it
 

Attachments

  • Macros File.xlsm
    26.6 KB · Views: 34
Back
Top