Search results

Hi all, I have a table that has a type of device linked to a crossroad street. There are 10 different devices and many streets. I want to make a query that has the type of device and the number of devices on all the streets. Thanks

Yea thats the problem :/ What is spin button and how can i get the event to fire when i just select the choice ?

I'm using a list box but i have to select the combo box choice and select something else to fill the box (query) . i can't scroll down the combo box and fill the list box every time... for example if i am searching for some details that the list box is showing me.

Thanks, that did it :) I thought that it needed to be that way :)

When I leave everything blank (in this new db I uploaded) – the Teren and MIN and MAX dates I get 1071 records and I have 3128 records in my IZVESTAJ table. That numbers should be equal. The IS NULL is for all the Terens? Maybe there is a problem with dates in IZVESTAJ table DATUM_IZVESTAJA...

Forms!FrmPrikazIzvestaja!Combo32) Is Null is the thing i don't understand in the query. There should be all the lines in the table IZVESTAJ that have the Streets in the specific Teren between two dates. Then i delete this he gives me only 1300 - and there is 1900 lines in the IZVESTAJ table...

I did... copy pasted it all but i get too little results for my query... i have 3000 lines in my table and i get 50 in my query... there is some problem... i can't see it... i will try again.

Its not working again... i don't know if i did something – FrmPrikazIzvestaja is the form and QryIZVESTAJ is the Query if you don’t remember.

I cant make my combo box into a search box :( so i made a button for opening a different form where a made a list box controlled by a text box.

Maybe if i could make the arrows on the keyboard chose different choices....

Yes mouse over or when i scroll down the list in my combo box with arrows

Sorry for the delayed response, no filter is not what I want – I want to make possible to search the table in 2 or more fields but if possible I want to use the combo box for that search. Example: I have the street name corner (so it’s named by 2 or more names, old names etc.) : Yellow...

Hi all, My form has a combo box that triggers a query that is listed in that form. That query is triggered when I select and deselect that combo box (I select something else). I want that the query is triggered instantly while I go thru the different combo box choices. Thanks in advance

Please can you help me :(

The problem is that i don't want to add items to my combo box, just want to make possible to enter a value in the box that can be used as a search criteria for finding the right already existing item in my combo box.

How can i make my combo box be the search box. How can i make my combo box not limit to list so i can use it for my search query box, it calls some column widths problem...

Search query How can I make a query that a can put into my form that users can use to find specific records based on a few letters, based on two field names? I know how to link them from a form but how to make it so that the query selects all the lines that have, for example, “Dun” in all...

Thanks :) That did it

Can you explain what did you do? Thanks

Yes, if only second is clear then from the begging date(1.1.2011) to the date in the 3 box