Search results

Thank you very much Bob! I understand what you are doing and it works now perfect. I was totaly lost, but can now cary on. Thanks again!

I try to explain my problem better. When I open frmTestForm1 the I get 39 records grouped per area, year execution & year survey and the sum of small, medium, large & jumbo PUD. Then I select one of the areas using the combobox with the aim to see only 3 records of that area, but then I get the...

I have attached an update of the Test database. I hope one of you can help me with this problem.

I have attached the test where I'm working on and I can not find the error I'm making. frmTestForm is linked with qryTest and when I open the form I get all the data. When I select an area with the combobox I get all the data in this area. So far it is doing what I'm expecting. frmTestForm1 is...

Understood. strSQL is displayed in the immediate window as prepared in the code. strArea is now displaying [Area]='NEE' when NEE is typed in the txtbox. This seems to be ok now, but the Me.Recordsource still results in an empty string and access stops with an error message 3141 and states that...

Thanks for your swift reply Bob. The string that gets passed is empty. Area is indeed text, but I do not understand the single quotes. Is the format as follows: "[Area]='" & Me.txt.Area & "'", so a single and a double after = and double, single, double after Me.txtArea. Is this what you mean and...

I have a form with a chart and want via a txtbox look at a specific selection of the records. I get constantly an error when the after update event runs and I'm unable to find the problem. The error arises in the line printed bold. Maybe one of you can have a look at this: Private Sub...

It's all working now and I'm happy with the result. I believe things can be done more efficient by using 'function' and 'call' as you said, but I will change that after I have done my training in January. Thanks for your swift replies and very useful advise.

Yes I understand this Shaneman, but can I check the value of strWhere by typing ?strWhere in the immediate screen (Ctrl-G). I do not get any value (an empty line) and the chance is big I'm doing something wrong here. If this is possible it gives me the possibility to track the value and try to...

Thanks Shaneman. It's all working now apart from one thing I'm working on right now. After filtering the listbox using at least one of the textfields and clicking one of the headers to sort, then all records are back in view. I know the reason for this and try to research of the content of...

Thanks for your reply. ListCount? I'm working with access and have no background in VBA, but I'm learning every day. I've scheduled a training in January. The second txtbox was used for testing purposes only. I wanted to know at which record is the selector pointing during filtering when it was...

Listbox or form does not update Shane, looking at your revised code and form, I understand that the listbox is filtered and correctly shown, but now the form is not filtered. Underneath the area in the footer of the form where the searchtextboxes are two other fields are displayed. The left one...

Thanks for your swift reply an the listbox is finally doing what I wanted it to do. Thanks for your help. I will now study your code that made this possible and if I have questions I will come back to you via this forum. Okay?

Herewith the searchform of the database. Hope you can help me.

With help of this forum I'm close to the solution of my problem. I use in a form a listbox and 6 textboxes to to filter the form. This works now, but I do not understand why the listbox does not update and show the records that are filtered. The listbox does not filter at all and shows all...

Tim, I cannot open your attachment. Pls check.

Search within listbox Thanks for your reaction Shane. I do not see if one of the 2 links you send helps me with my problem. Maybe I was not clear enough in describing the problem. In my form Search I have a listbox showing 6 fields of each record. At this moment the list is about 1500 records...

I have a form with a listbox. This listbox shows all records of a database. With help of this forum I'm able to sort the listbox ascending and decending by clicking the individual fields in the header. Now I have put 6 controls(textboxes) in the footer of the form with a button to find records...

After filling text boxes a string "where" results and this string is used to filter records (found on this site) and displayed in a list box. Now my question is how to use this string in the listbox to filter and display the data. I hope my problem is clear and I thanks you in advance for...

Record Selector Thank you very much Chris. It works perfect. Only finetuning the final form and that's it. Great. Was suffering during the weekend to find a solution. Thanks again. Pieter.