Search results

what i have is a form button event that dims the vars and opens another form, passes the openArgs and performs a search. The problem I'm having is the search is case sensitive so unless the case is correct i get no results. I have spent a bit of time on it and just can't work it out.. this is...

I have a report with a field called "status" The report only shows items with a status of "open" I want to be able to loop through the line items and change the status's to "closed" with a button click. I can do this with a form if needed. Thanks for your help.

Hello, So I want to be able to save prior search terms used to search our database so they can be called with, for example, a back button and re perform the search. I can work out how to save the data of one search but not sure how I would go about doing that for the last say 5 searched...

Hi everyone, I'm using this piece of code to remove any "zero's" at the start of whatever number a person puts into the text box (Text38), this works great. Dim RemZero As Integer For RemZero = 1 To Len(Text38) If Left(Text38, 1) = "0" Then Text38 = Right(Text38, Len(Text38) - 1) End If...

Hello guys, I have A filter that I use to filter a date range of orders, works ok if everything is all on one form. Much the same as the last filter problem I had. So I have a form with Tab Control, a datasheet of all orders in a subform on "Tab1". On "Tab1" (Main)I have the text boxes and...

Hello all, needing some help on this please. I made a form based on a products table query. Made a searchbox and button, works great. code for the search function is as follows. Private Sub Search_btn_Click() DoCmd.ApplyFilter "", "[PartNumber1] Like ""*"" &...