Search results

Hello friends, I am having some problems with a sub form which does not display data as I wish. My db refers to a small insurance company. Clients are identified with a number (similar to the SSN but it is not a SSN) ending with either one or two characters which indicate the type of clients...

Thank you for your advice. Don't worry. No violation.

Resolved. Just changed a few lines and got what I was looking for. Will share. Thank you SELECT mytable.[ssn], First(Left([ssn],9)) AS Expr1 FROM mytable GROUP BY mytable.[ssn] HAVING (((First(Left([ssn],9))) Like [forms]![myform]![ssnsearch]));

Hello, I have a table with a 9 digit SSN field. This number is followed by one or two additional characters (letters or numbers). It may happen that same records have the same 9 digits and will need to create a query that returns all those records with just the same first 9 digits. Query...

Hello, Recently I had a great help form you with a similar topic. I am now facing a new problem with a form on which I have placed a list box that I would like to populate with 4 different queries. These queries will get their criteria from different text boxes. A cmd button should then...

Thank you. Will follow your advise.

Hello friends, I have a list box populated by queries which get their criteria from the selection users make in a combo box. Simple criteria like "Hello" gives me no problem in the After Update event code of the combo: Me.mycombo = "Hello" Then Me.mylistbox.RowSource = "qryHello" I have...

Done. Thank you very much for your help.

Thank you. Could you please where I should put the code below in my query? Is it in the Field or criteria line?

Hello. My table (table1) has a field (RTN) which refers to bank codes made of 9 digits. The first two digits indicate the country in which clients have their account (Country Code). which can be in a Country different from where they live. Example: RTN 001111111 - RTN: 112222222 - RTN...

Solved. I just changed my code as follows and works. Thank you Form_Current() If Me.cbo1.Value = "Hello" Then Me.cbo2.Enabled = False If Me.cbo1.Value <> "Hello" Then Me.cbo2.Enabled = True End If End If cbo1_AfterUpdate() If Me.cbo1.Value = "Hello" Then Me.cbo2.Enabled = False...

Thank you. The combo (combo2) now does get disabled but if I chance my selection in combo1, it does not get enabled. Its stays grayed out.

hello and thank you for any help you can provide me. I have a form with multiple combo boxes. Each combo gets populated according to the selection of the other combo. I would like that when I select a specific record in combo1, combo 2 get's grayed out (locked) as an additional selection...

Since I use dynamic combos I would say less then 10.

Hello, I have a form with a combo that is used as criteria to a queries. I would like these queries to be used as record source of a standard reports which should then be attached to an email in pdf format. Users will select the query from the combo and the report generated into pdf. I...

Yes. Works great now. My mistake, just overlooked a simple but important detail. My I ask just one more thing? What is the reason of the & "*" after the criteria? Thanks Like [forms]![myform]![txt1] & "*"

Thank you for your help and sorry for the delay in getting back to you. I have looked through several threads and have found a "partial" solution to my problem. My form (frmMenu) has now an unbound list box (lstStudy) and 7 combo boxes used to populate and filter the list box as used as...

Hello, I have a form with a list box that gets populated according to the selection made in dynamic combo boxes. The list box is updated starting from the selection in the combo named cbofilterStudies. In my examples, please look at the selection “Age Study”. I am having a problem with the...

Yes. Thank you

Thank you all for your help. It works great. I will not add more queries. About the "1", that's just the criteria I need to sort the records in my query. Thanks