Search results

Hello friends, I am having a bit of problem in trying to create an append query to store data from unbound textboxes to a table. I know that it's not the correct way to manage my db and will give you some quick info. Once a week I get a txt file which I import in my table "Clients". During the...

Perfect. Exactly what I wanted. Thank you

Thank you. Unfortunately the Like Not will return in the Sub Form all the other records. What I need is restrict it to all other records, with the same insurance no but different ending characters (basically same first 9 digits but different last two characters). Thank you

Great. Got it working. Is there now a way to exclude from the sub the record the main records, meaning the one selected in the list box? Basically the sub form should display all other records. Thank you

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] & "*"