Recent content by xMax

My search is supposed to return EXACT Matches, not SIMILAR Matches.

Bump. Need. Help. Now.

I need a query, but I cannot use the like statement.

(A=Forms.frmMasterSearch.txtA Or A=Forms.frmMasterSearch.txtA2 Or A=Forms.frmMasterSearch.txtA3 Or A=Forms.frmMasterSearch.txtA4 Or A=Forms.frmMasterSearch.txtA5) And B=Forms.frmMasterSearch.txtB And C=Forms.frmMasterSearch.txtC And D=Forms.frmMasterSearch.txtD I want the query to look up...

I solved it; I am such an idiot. The fields in the table did not match the fields I was looking for.

SELECT * FROM Games WHERE Name=Forms!frmSearchByName!txtName;

Ok, I unbounded the form and textbox, but now it asks for the Parameter Game after I hit the search button.

Problem Solved!!! Thank You!!! Enjoy a little rep.

Here's the code: Dim login As Variant Dim thepassword1 As Variant Dim validLogin As Variant Dim correctPassword1 As Variant txtLogin.SetFocus login = txtLogin.Text txtPassword1.SetFocus thepassword1 = txtPassword1.Text txtLogin.SetFocus MsgBox thepassword1 //Displays ***** as password - this...

I am conducting a search for certain records in a table using a select query and a form. However, when I do the search, one of the rows in the table gets modified do whatever it is I am looking for, and of course, I don't want that to happen. Query Code: SELECT * FROM Games WHERE...

DLookup("password", "[tblLogin]", "LoginName = '" & txtLogin & "'")

not working. it still says the password is ******* when it is a bunch of characters and numbers. textboxes are unbound and input mask was set to password.

I have a password field for my database. When I enter the password, it uses the DLookUp screen to check and see if the password entered matches the correct password. However, when I use an input mask to make the password appear as astericks, it thinks the password is a bunch of astericks. When I...

When I open up a form the default value of the combo box is null but I need it to be set to the first value of a certain table. How do I do this? EX: Table HellMonsters: Satyr Demon Form AddAttack ComboBox Monster: (set to Satyr or something else if it comes before Satyr in the table)

There is a paint bucket icon on the toolbar in Access that allows you to change the color of your forms: click on your subform, and then click the drop down arrow next to the paint bucket. If the color doesn't change then click on the paint bucket itself and it should.