Search results

Hi All and Merry Christmas, I have a this subform that is based on the query;One filter is sourced on the combo box on the main form and it refreshes the subform after change. The other filter is on the column in the query that has two values, Y and N. I am trying to set the criteria through...

Hi Everybody, I am trying to create a text box on the form that would show subtotal of the specific column on the subform above it. The subform is based on the query that runs each time a combo box is changed and it refreshes the subform. I have tried sourcing the text box as Sum([Query...

Hi could someone tell me what does this do by the way this question is also posted in the Excel section since it is from the spreadsheet) Dim data2(500, 20) count2 = 0 Sheets("volume").Select For w = 6 To 500 If Cells(w, 4) = "" Then GoTo 30 count2 = count2 + 1 data2(count2, 1) = Cells(w, 4)...

Hey...not to worry. I found the Like function that works like a charm. Thanx for reading the message though. Twin

Hi everybody, does anyone know how to translate or adjust the Excel filter command Contains (="=*VALUE*") into Access so that is acceptable as the criteria field? thanx in advance

Not to my knowledge, but if you click on the number 9 it will display the rest of the open windows.