Search results

Hello, I 've a form with most textbox and one button to search and one button to find the next record. My code search perfectly the first record because i use with my recordset FindFirst. My problem is when i have double and i want to display the next record and the next record... . I can use...

Hello, I want to help you about my base. I have a table with 2 fields. In this table, I would like to separate ma data in two parties. I 'm looking for just the double in the field call number. 1/ First sorter For the same CallNumber, if i have a line with the Activities like "primary...

Hello, In the Table DataBase1, i have the field "CallNumber". In this field, i can find most recording with the same "CallNumber". I must to keep just one record. In the field Activities, i have "REPARATION" or "Primary Assign" or other but for me, i look only "REPARATION" or "Primary Assign"...

Hello, I would like your help about a code wich sent a E-mail. I would like to insert in the body of my e-mail, a table from access like this. I have do this to sent the message but i don't know how can i insert in the body a query. Private Sub cmdSendEmail() On Error GoTo Error_Handler...

Hello, I have a problem with my query which name “Query One”. In the field “Call_Number”, I have most double and I want keep just one record. My problem is in two fields, “Block” and “Out Of Delay 1”. If I hide these fields, I can use GROUP BY but I would like see these fields. In the query...

I would like delete all the tables in other database hello, I would like your help about my problem. I would like to delete all the tables in other database. I have try this but it doesn't work. I have two tables in ma database outwards the system tables and my code is block on the line...

Hello, I would like to ask you several question about the crossTab query. - I wanted to make a total of my lines of my crosstab query. On the advice of Pat, I have to make a report with in footer, the line for my total. I would like to know this. In my files attached, I have two picures of...

Hello, I have several questions concerning the crosstab query. I created a crosstab query which take data since a table (I have a form with several listbox and independent fields and I send my selections to a table by a query). I replaced in my crosstab query the fields null by zeros and I...