Search results

hello.. thanks for help Wayne. filter is working.. and not =( it is working, but not showing any data (form is blank). maybe you can't filter a subform?? what i need is finding data in a subform connected with main form. when i have one company, and loads of news i need to find news from...

hi.. i have a problem with subform filter.. i have 2 tables: called 'comp' with companies info, and subform 'news' with news about this company. company has ID as a primary key, and some others. news has ID_NEWS as PK and ID_COMP as foraign key from company, DATE of news and others. then i...

one more question.. i would like to cancel this sorting.. i was thinking about somethink like this. Me.Orderby=null or Me.orderby="" but this doesn't work.. :(

wow..!! i didn't know about that. that did the trick!! thanks a lot!! i've been fighting it for 2-3 days now. Mateusz Zawada. P.S. thank you one more time :D

hello.. i have a strange problem.. i posted it here because its more general than a querry question. i created a button, that would sort a form: Private Sub sortZa_Click() Me.OrderByOn = True Me.OrderBy = "[updated] DESC" Me.Requery End Sub the problem i have is that sorting was...

hello.. thanks for you comment. that's what i was trying to do useing this code: Private Function GetCriteria() As String Dim filterCriteria As String Dim VarItm As Variant For Each VarItm In ListFilter.ItemsSelected filterCriteria = filterCriteria & "[region] = " &...

Hello.. I'm trying to do this for 3 days and nothing.. this is what i have: 2 tables: Company and Region 1 form: mainForm a multi selection list box (Regions in it) a button: filterBut i would like to select fiew regions and by pressing a button (filterBut) filter all companys in selected...