question

Kennyqui-0889 avatar image
0 Votes"
Kennyqui-0889 asked Viorel-1 answered

Index was outside the bounds of the array

How to fix this?
201856-image.png


office-vba-devoffice-access-dev
image.png (217.5 KiB)
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Viorel-1 avatar image
0 Votes"
Viorel-1 answered

Check a fix:

 . . .
 cmd.CommandText = "SELECT 1 FROM logininfo WHERE username = ? and StrComp([password], ?, 0) = 0"
 . . .
 If rd.Read
    MessageBox.Show("Logged In Successfully")
    Users.Show
 Else
    MessageBox.Show("Invalid username or password!")
 End

5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.