Recent content by Gizem

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