Search results

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.

Ok I do not receive the Error 2001 but I now receive a Invalid Use of Null Value (if the login doesn't exist, then it should be null, and the same with passwords). What am I doing wrong here?

I have a table with 2 Dates and an Integer. I want the Integer to be autoset to equal the amount of days between Date B and Date A. How do I do this? Max

I am getting an Error 2001 here and I can't seem to find what the error is: Here's the code: Private Sub cmdLogin_Click() Dim query As String Dim login As String Dim thepassword1 As String Dim thepassword2 As String Dim validLogin As String Dim correctPassword1 As String Dim correctPassword2...

Table Fields (tables named qryGameTimes - it shows all the available appointments for the laser tag games) Game ID (Auto-Number) & Primary Key Time (Date/Time) (all times that the arena is open - 10:00 AM to 12:00 AM) Room (Number) (the two rooms that we have for laser tag) Available (Yes/No)...

I am working on a laser tag database where I have to schedule laser tag games (each game is 15 minutes long or 30 minutes long). There is a group who wants to play a 30 minute game but each entry is 15 minutes long. I can use Visual Basic 6 to check a table and see if one 15 minute game is...