I have a form which uses 4 unbound text boxes to add information to a table.
I use the following code.
DoCmd.RunSQL "INSERT INTO tblPasswords(UserPlace, UserName, Password, Website) VALUES(txtAddReason, txtUserName, txtPassword, txtWebsite);"
DoCmd.Requery
However, I would like the last unbound text box (txtWebsite) to save to tblPasswords.Website as a hyperlink - at the moment it doesn't! Is there a way to do this?
Thanks!
I use the following code.
DoCmd.RunSQL "INSERT INTO tblPasswords(UserPlace, UserName, Password, Website) VALUES(txtAddReason, txtUserName, txtPassword, txtWebsite);"
DoCmd.Requery
However, I would like the last unbound text box (txtWebsite) to save to tblPasswords.Website as a hyperlink - at the moment it doesn't! Is there a way to do this?
Thanks!