Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
turning a combo box into a search field
I tried doing this, and it works when I search for a primary key value, but it doesn't work when searching for a match in the "lastname" field. This first sub below works (the primary key one), but the second one doesn't. Below is the search function that performs the actual search...- Nkuha
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
Marking a record based on data in it's "Many" relationships.
I have a one to many relationship. I want to count all instances of "true" in a field in the "Many" table, and if any are found I want to mark another binary field "true" in the "One" table. If none are found, I want to mark the field in the...- Nkuha
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Programming
-
Adding a variable in the middle of a Query
Anyone know how to correct this code? rst.Open "update cases SET cases.flag = 0 WHERE" & DateDiff("h", rst!datein, Now) > threshold, CurrentProject.Connection, adOpenKeyset, adLockOptimistic- Nkuha
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
