Please help

[Alvin Hansen]

I'm not so good in access - using normally Excel

What i want:
When I start my access database i want a input box
in this input box I want t write my name - this name
shall down into a table in my access database.
like a logg.
Hope some one can help

Best regards alvin

 

[Rick B]

Why?

Access has built in security if you are trying to sign in and validate them.

What specifically are you trying to do? Why would you want the users to
have to type intheir name and store it?

Give us more details.

Rick B

 

[Alvin Hansen]

Hi rick
Yes all i want is a input box where the user can enter
there name and then store it in a tabel
The input boc shall come when the try to enter the database.

Alvin


"Rick B" skrev:

 

[John Vinson]

I'm not so good in access - using normally Excel

What i want:
When I start my access database i want a input box
in this input box I want t write my name - this name
shall down into a table in my access database.
like a logg.
Hope some one can help

Best regards alvin

The simplest way to do this is to have a Form bound to the table into
which you wish to store the name; a textbox on the form would be bound
to this name field.

If you want to prevent the user from closing the form or going on to
anything else before entering something into the textbox (of course
you can't control WHAT they enter), make the form's Modal property
True and put code in its Close event such as:

Private Sub Form_Close(Cancel as Integer)
If Me!txtName & "" = "" Then
MsgBox "You must enter your name"
Cancel = True
End If
End Sub


John W. Vinson[MVP]