Search results

It worked perfect! The first problem is solved, thanks a lot!! Now I'll write code to clear the selections or use the not in list event to try to fix the other issue. Thanks a again, you've helped me a lot!!

Hello!, I need some help (I have attached an example) I have 2 dependant comboboxes Year that dependens on Partner and Partners that depends on Country that is independant. The problem is that when you select a year, the selection overwrites the year (1990 for example) with it's ID (5 for...

A little update (and an example) Now the filter works only when I select at least one partner, one from each listbox. But if I select only one or more partners from one of the listboxes (leaving the other blank) the filter shows me all the possible partners. How can i correct this? I think that...

Thanks a lot! I'm still working on it XD

Hi!, I need some help please: I have 4 listboxes that filter a report, 2 (ListboxPartner and ListboxPartnerN) of them are supposed to filter the same field (Partner) (I needed to split this field into this 2 listboxes for practical purpouses). Everything is working, but when I make a selection...

Hi, I need a a little help please: I need one data entry form that has all the months and a value for each year. So you got: January [value ] February [ value ] March [ value ] Etc... but, the problem is that the table format is flat, so each record is like this: ID / Year / Month /...

Sorry, here is formatted: ' Build criteria string from lstYear listbox For Each varItem In Me.lstYear.ItemsSelected strYear = strYear & ",'" & Me.lstYear.ItemData(varItem) _ & "'" Next varItem If Len(strYear) = 0 Then strYear = "Like '*'" Else...

Hi!, I need a little help please, here is my problem: I've created a report and Its composed by 3 sub-strings that generate a final string that filter a report. 2 of these sub-strings are text, and they work fine, but the other sub-string is a number and when I try to use this string (to sort...