login form in visual basic 2005, no c#please

I have a login form that opens up after the user has installed the application with the following fields:

Create Account under the header:
username:
password:
        create         exit

when the user presses the "create" button the username and password are successfully stored within an access database and the main form opens.
What I would like to know is how after that login is created and the user re-launches the application again for another "Login Form" to open that will ask the user to login as the account is already created.

Please tell me what statement I need to put after the account is created so that this new form opens up asking the user to authenticate himself.
LVL 1
systems_axAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ScottParkerCommented:
Just a few quick thoughts on the basic concept of what I would do.
I would end up with 3 forms..

MainForm  - Have a Public field called _accountCreated
LoginForm
CreateAccountForm

In the OnLoad function of MainForm, show LoginForm.
The LoginForm would just have 2 text fields and 2 buttons.
 Username  and Password would be text fields.
  Submit and Cancel would be the buttons.
On Submit, I would check the database for that username/password.
If found and the password is right, then set the mainform._AccountCreated field to true,  Else if no record is found then set it to False.

Then, still in your mainforms onload sub...
do something like....
If not _AccountCreated then
  show CreateAccountForm
end
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
systems_axAuthor Commented:
ScottParker,
can you provide the sample code please.
thank you
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.