Search results

I want to requery my table with UPDATE instead of INSERT INTO. I get a syntax error. What is wrong do you see my failure?

Thank you :)

I spoke to my boss. Now he agreed to the decision to deal with a query instead of a report. But i get again a syntax error because of the FROM clausel Dim SQLInsert As String SQLInsert = " INSERT INTO Tabelle1(bla) " _ & "SELECT Projekt-Auswertung.PS_P_NAME_LANG " _ & " FROM...

Can you give me an example

Yes it is a report. I don't know 😅 I have to pull data from this report. My superior ruled it.

Yes GEWICHT_KG is a number field. And below is my code which doesn't work. F_Projekt is the name of my report

It seems like this. But it isn't the same

Hello together, i have to export certain cells in an Access table. When i deal just with tables or query than i work with this code: Dim SQLInsert As String SQLInsert = " INSERT INTO Table3(P_NAME) " _ & " SELECT F_Projekt.P_NAME" _ & " FROM F_Projekt" _ & " WHERE GEWICHT_KG <> '0' "...

I tried it for my Report but it does not work. I get a syntax error : syntax error in FROM clausel..

No it is a report :)

Now i have to do the same with a Report. My source is now a Report. Here it does not work. Do you see where the failure is ? Dim SQLInsert As String SQLInsert = " INSERT INTO Table3(P_NAME) " _ & "SELECT F_Projekt.P_NAME " _ & " FROM F_Projekt" _ & " WHERE GEWICHT_KG <> '0' "...

tank you :)

Is this part correct?[/code]

Dim SQLInsert As String SQLInsert = " INSERT INTO Table1 " _ & "SELECT Me!Table2.P_NAME_L " _ & " FROM Table2;" CurrentDb.Execute SQLInsert I get a run-tim-error 3061.To few parameters. Expected 1..

Hallo together, few months ago you helped me a lot. Now i need help again. Now i want to fill my Acces Table with an other Acces Table. I tried it with INSERT INTO.. SELECT.. , but it does not work. Maybe you have a better solution or you can find my failure. I chose this option becauce, i want...

Hello together, i had to add a query and sort it in it. I used Order By. Thank you very much :)

Hello again and a Happy New Year, today i have an other problem. I have an Access table and now i would like to sort it numerical. MyTable seems like: ID POSITION NAME 78 0 Mueller 79 2 Baecker 80 1 Scholz It is important by sorting it, to take the whole row like: ID...

Thank you all :) DB.Execute "INSERT INTO ProjekteNam(POSITION,PS_P_NAME) Values ('" & varr & "' , '" & Wert & "')"

Hello from Germany, i got so many helpful advices yesterday and now i have an other problem. I think you can help me also. It is possible to fill one cell bye using INSERT INTO with the following code: DB.Execute "INSERT INTO ProjekteNam(PS_P_NAME)SELECT (''" & Wert & "')" But now i have to...

Yes exactly wert was my problem. I solved the problem like this : wert = Ctl0.Column(1) But here i can just choose one element. Now i will try it like your suggestion.