Why am I getting this Missing Operator in my insert into statement?

[DerekAwesome]

So the system I'm coding right now is for account creation. The code I'm using to append the new account information is as follows:

CurrentDb.Execute "INSERT INTO AcctInfo (Username, Password, AcctOwner, Email, CreationDate) VALUES (" & TextUsername.Value & "," & TextPassword.Value & "," & TextName.Value & "," & TextEmail.Value & "," & Date & ")"

I'm getting an error when it gets to the email field. If I have an @ in the text box (which I have to to enter the email), I get a Missing operator, and the error message displays the text in the email text box. If it doesn't have an @, I get a too few parameters (and either an expecting 3 or expecting 2)

Are there syntax errors in this statement? Is there something wrong with using an @ symbol in the text field?

Any help would be greatly appreciated.

Edit: FIXED Missing Operator with Chr(39) delimiters around TextEmail.Value. New Code:

CurrentDb.Execute "INSERT INTO AcctInfo (Username, Password, AcctOwner, Email, CreationDate) VALUES (" & TextUsername.Value & "," & TextPassword.Value & "," & TextName.Value & "," & Chr$(39) & TextEmail.Value & Chr$(39) & "," & Date & ")"

I'm still getting a too few parameters error (expecting 2). Why is this?
It's also important to note I had previously opened the database as a DAO.Recordset earlier, but I still closed it before running this line. Could this be the issue?

[June7]

Values for text fields require apostrophe delimiters. Date fields require # delimiters. Value is default property and do not have to type it. Good idea to qualify reference to controls with form name. Can use the Me alias.

CurrentDb.Execute "INSERT INTO AcctInfo (Username, Password, AcctOwner, Email, CreationDate) VALUES ('" & Me.TextUsername & "', '" & Me.TextPassword & "', '" & Me.TextName & "', '" & Me.TextEmail & "', #" & Date() & "#)"

[DerekAwesome]

Thanks for the info, I made an update to the original post after figuring that out (I had yet to see your reply). Guess I should have read some other posts before throwing one up.

Anyway, the issue now remains that I have a too few parameters (expecting 2) errors. What could this be caused by? If you need to see more of my code, let me know.

EDIT: I threw in the commas and hashtags and it works PERFECTLY! thanks June7!

[June7]

You haven't use delimiters on all the fields as shown in my suggestion. I assume the fields are all text except for CreationDate.

[DerekAwesome]

Yeah, I re-did it the way you suggested and it worked perfectly