saving a text box entry to a table (1 Viewer)

[awse]

Hi
I have a form named "Main frame", it contains a text box called "password", i want the password entered by a user in the form saved in a field called "voter" in "password" table.
hope u help in this
thank u all

 

[John Big Booty]

Welcome to the forum.

You could do that with an Append Query, the SQL might look something like;

INSERT INTO TBL_Address ( voter)
SELECT [forms]![Main Form]![password] AS Expr1;

 

[awse]

thanx alot for reply but i really wish if u can give a vb code

 

[John Big Booty]

VBA code will look something like;

Dim strSQL As String

strSQL = "INSERT INTO TBL_Address ( voter) " & _
             "SELECT " & [forms]![Main Form]![password] & " AS Expr1;"

DoCmd.RunSQL strSQL

 

[awse]

unfortunately it doesn't work
i made the table i want to store the data into it contains one field only and called it "passwords"

and i place the code like this in the main frame

Private Sub f2_AfterUpdate()
Dim strSQL As String

strSQL = "INSERT INTO TBL_address (Passwords)" & "SELECT " & [Forms]![Main Form]![password] & " AS Expr1;"

DoCmd.RunSQL strSQL
End Sub

really need help in this one

 

[awse]

sorry for that , i should replace the password field name with "f2" instead of "password"
but there is another problem, when i enter the password a prompt pops up asking me for parameter value, in contrary what i need is just save the password i entered in the table
hope am not confusing u
thanx alot

 

[awse]

please notice that the main form does not have a table, it just contain unbound text fields

 

[pr2-eugin]

Try this code..

Private Sub f2_AfterUpdate()
    Dim strSQL As String
    strSQL = "INSERT INTO TBL_address (f2) VALUES ('" & [Forms]![Main Form]![password] & "');"
    DoCmd.RunSQL strSQL
End Sub

Why could this not be a BOUND FORM??

 

[awse]

thanx for reply
but also doesn't work
it's okay if i upload my work to see the problem?
it'a simple and easy to understand

 

[pr2-eugin]

Yes, please upload a copy of your DB..

 

[awse]

i have a problem in uploading

 

[pr2-eugin]

Did you look into the link on how to upload in post #10?

 

[awse]

http://www.4shared.com/file/w0cxOLMN/last.html?

 

[pr2-eugin]

http://www.4shared.com/file/w0cxOLMN/last.html?

Sorry to say this.. I would love to help, but I am not planning on register just to download the file.. Follow this link that will explain how to upload your DB here.. http://www.access-programmers.co.uk/forums/showthread.php?t=212125

Good Luck !

 

[awse]

any ideas?

 

[awse]

any ideas?