Search results

Hello maxmangion, I 'm agree with you but i would like use the VBA code in my Base. I can find the first record, I can find the second record with the method FindNext but I don't know how can I do if I have more two records. Whan i click on my button next, i can do it just one time. Is there...

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

Thanks you jon K for your help, Keawee

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

Thanks DaveUK for your answer. I have perhaps an idea about my problems but i would your opinion. I have a request and i can insert the records in a recordset. I have trying to create a table in my mail body in html and insert with my recordset the date in the table. I have do this like below...

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

Thanks for your answer maxmangion and jon k. I 'am progressing about my problem but i have a last question and i can't resolve it alone. In the field call number, i have this “SV0401270145@@1”. I have two lines and I want to extract only these two lines in a query but the field "Out Of Delay...

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

Thanks you Tim k for your advice and your help, Have a nice day or night !! ;-) Keawee

Hello Tim K and thank you for your answer. I have replace my code by your code like this For i = 0 To db.TableDefs.Count If db.TableDefs(i).Name Like "MSys*" Then Else db.TableDefs.Delete db.TableDefs(i).Name End If Next i Access launch me a code error, number 3265. The element is not find in...

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 Nobody has an idea Thanks for your help Keawee

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

Thanks for your help Pat, I just have one question about the code in the Microsoft Web Site. In window VBA, there is a document which names Report_EmployeeSales. I have a problem with a part of the code which I modified but in what relates to me, I do not have a form like in the example. I...

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