validating textboxes before opening database

I need an advanced validation to validate entries in textboxes even before it opens the database to check entries or input in database

I am creating a database which should allow no empty names or not valid email addresses but my program validates alright but opens the database and inputs the wrong data even after collecting errors

Any help would be much appreciated

What have you done so far?

should i post the the whole code here pls ???

Whatever code or problem you are struggling with, please post it with proper explanation

Without seeing your validation code and the code that goes on to save the data there is no way to be sure exactly what you have done but it sounds like you are using some conditional checks to see if the data is empty and perhaps valid but then continue on to the save regardless of that result. One simple solution may be to use a flag [i.e. a boolean var at the top of the routine] make sure that it is false at the top of the routine then if any of the validation fails set the flag to true.

When you get to the code that would save the data wrap that in a conditional statement that checks the state of the flag and saves only if the flag is still false at that point.

Code:

---

dim Failed as Boolean
    If Text1.Text=vbnullstring then
        failed=true
        'display message if desired
    End If
    If Text2.Text=vbnullstring then
        failed=true
        'display message if desired
    End If
    ' continue with whatever validations are needed.

If Not Failed then
    'save your data
End If

---

Now of course this assumes that all the validation and the save code are in the same routine. If they are in different routines then the boolean var needs to be defined at the top of the code for the form or in a module and if in a module may need to be public.
Also if the boolean is defined outside the routine then the first thing that needs to happen is to set the boolean to false before you begin the validations

Thank you very much