Member Avatar for sorin123

Hi, want to ask the following

if rs.fields(0).value=text1.text and rs.fields(1).value=text2.text then
mainform.show
loginform.hide

As you know, above code is part of Login processing. There are two text boxes for user name and password entry. Number (0) and (1) (in above code) refers to access database fields that user names and passwords are stored there. above code works fine for one user only.

Wondering, how to set for more users and how to extend this code so that anyone whose name,pass is in db, can access to main form. I tried adding fields in db for more usernames but from login form could not refer to them either by field number or data type so, not responding positively.
Thanks in advance

  • 2 Contributors
  • 1 Reply
  • 70 Views
  • 20 Minutes Discussion Span
  • Latest Post Latest Post by rproffitt
Syed Zubair commented: Add fields into your database namely username and its password, and simple add and save buttons. if you want to add user and its password it will add. +0
Member Avatar for rproffitt

It's now 23 years ago that VB6 rolled out. Last year we closed the books on this system for good. It's a pain to install and get working on Windows 10 and then there are issues with the SQL connection.

My advice is to move on.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.