Search results

Thank you

Hello, back for some advice and would appreciate your help. I have a form with a list box (List0), a text box (txtLName) used as query criteria and a cmd button which runs the query as record source of the list box. On the Click Event of a cmd button I have this code: If Len(List0) & "" > 0...

Thank you. This is exactly what I was trying to achieve.

Thanks George for your help. My idea is to redesign an existing db. Please note records are not added to the db but imported weekly. It's main function is merely to query data, print, run some stats and export to certain MS Word forms. The reason why I came up with un main unbound form...

Thank you for your help and time on this. I know better understand the concept of sub forms with unbound parent forms. Just one last question on your example and more specifically on the second combo (cboSearch). You indicate that it lists the values from the column selected in the first combo...

This code works fine. Thanks

Hello, sorry it was a typo. The FileNo field, should have been InsuranceNo. The idea was only to use cboCriteria and textsearch box as source criteria for 1 unique query (qryMaster) and display the results in the form. It looks like I am getting into something a bit too complex for me. I will...

Thank you for helping out of this topic. Sorry for not being too clear but the first column does not refer to a lstbox but to a subform. I am attaching a sample db. You will also notice the two controls (cbo box and text box) that I use as query criteria. Il looks like I am also having problems...

Hello, I am trying to find a way to show a selected a record in a specific field, from a subform to a text box. The main form (frmMenu) of my database has the following 4 object: - An unbound text box (txtInsuranceNo). - A combo box (cboCriteria) which is used to select the search criteria...

Good morning, I finally got it to work. I have used Edgar's code and adapted to my db. I appreciate everyone's help on this. There are lot of very useful tips which will be considering while redesigning my db. Thank you

Hello, Obviously I have tried the queries and they do work fine. No problem with them. I was referring to the records in the list box which does not appear to refresh. Thank you and sorry for not being more precise.

Hello Edgar, appreciate your help. Sorry for the typo. I now understand the code line Me.lstsearch.RowSource = "qry" & Me.cboQueries.Value I have tested your sample but still cannot display the results in the lstbox after typing the criteria in txtsearch and selecting the qry from...

Hello, I would appreciate your help in solving this issue. 1I was thinking to redesign a search form and remove the multiple search boxes and buttons and just leave one of each. My form will have: - 1 combo box (cboqueries) which will display the names of the queries - 1 search textbox...

Thank you

Perfect. Works great. Thanks

Hello, I have a form with a VBA code that export data to a MS Word template. After exporting I would like to give the user two options: 1) Open the MS Word document 2) Only print the document without opening it I am having problems with the second option as it always opens the document and...

Absolutely!!! No worries. It just made me have a good laugh!!

Actually year is Anno. Ano ........totally different meaning.....:)

Finally got it to work. Not sure if it's because I use an Italian language of Access. This is how I changed it. Expr1: Format([dailydate];"mm/aaaa") Thank you

The query has its record source to table1 and has the following fields: - DateCost - Amount Date cost has the format dd/mm/yyyy This is the code in the new column: DateMMYYYY: Format([DateCost], "mm/yyyy") Thank you