Search results

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...

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)

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...

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...

I just need to know how to activate a query every time I type a character in a textbox.

I have a recordset and I'm trying to get it to select the last entry in a certain row in a table but it doesn't support the MoveLast command and getting MoveNext command in a loop causes EOF error.

I have to add a TreeView for a form. This treeview must have 3 nodes, and each node contains simple information based on a value selected from a combo box. The samples I have seen all have added features that I do not want or need. There are 4 tables involved. Let's say I work for a State's...

I have a text box and I am trying to count a certain number of rows. Suppose the textbox is called txtnumrows My SQL Statements are as follows: (the rest is probably unimportant) Dim sqlstring as String sql string = "SELECT COUNT (rowcount) FROM tbltable" DoCmd.RunSQL (string) I have tried...

I need to know how I can get code in Visual Basic to understand a Yes/No field in a table? I would prefer using booleans, but anything is fine.

I need to know how to make a command button on a toolbar open a form. The code has to work for each and every form I have.