DanteEllis
Last Activity: Nov 18 '08, 06:22 PM
Joined: Nov 17 '08
Location:
-
Okay perfect, that worked. Thanks a lot for your help! -
clarification
Thanks Breezwell,
That worked and it was added to the table. Thanks!
Now, when it executed, the table field "user_type_text ", the text added was the number 6, as opposed to a the text Administrator.
txtLogonType is the unbound combo box on my form. It looks up data in another table (called "lookups), the number 6 is the ID that ids it as the number 6.
...Leave a comment:
-
Change Error Message
Breezewell,
Thanks.
I tried taking the "Me." out of each and I still get the Syntax error in INSERT INTO statement. I realize I didn't give the rest of the code. Here it goes (with the changes you said I should make.
I'm still getting the error.
Private Sub cmdSaveExit_Cli ck()
Dim strSQL As String
If Msgbox("Are...Leave a comment:
-
Help on INSERT SQL Statement
Hi,
I am using Microsoft Office 2003, but save my Databases in Access 2000 format.
I have a table for user verification. I have a login form which works well. I am trying to make a form to add users, so it doesn't have to be done via the table directly.
I have the following in an unbound form:
User Name (unbound text box)
User Password (unbound text box)
Confirm Password...
No activity results to display
Leave a comment: