Search results

Well actually the query is based on both tables and the field in common is the FileNO.

Thanks. I have attached the sample. Very simple.

Hello friends, My db has two main tables (table1 and table2). Table1 gets its records periodically from a text file that I import and that I cannot change. Table2 is used to store new data, like changes in phone number, email, addresses, etc. I use this table like an historical log and need...

Thank you for your reply. But will I be able to create a report based on unbound fields?

Hello, I have a form with two tab pages. One picks data from a table, the second one has unbound fields that once updated are saved into a different table. I am having problems in printing this second page. I have tried two options: 1) The following command: DoCmd.PrintOut acSelection...

Thank you. Sorry but where should I write it. Not very familiar with it. Should I create a query and how can I refer to the unbound fields?

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...