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' "...
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 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...
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...
Hello together,
i need help again :) A couple of weeks ago, i got so many advices.
I have two listboxes. The first one is filled with data and the other one is empty. Now the User wants to fill the second Listbox by using the first Listbox and a button. The User has to choose one element in the...
Hello together,
I am the first time here. I have a huge problem, maybe you can help me. I have a listbox and two buttons. I would like to move a selected element in the listbox up with the UP-BUTTON. With the DOWN-BUTTON, i would like to move the selected element down.
The data which you can...