Search results

Hello, who can help me with a wrong SQL? I am trying all day to get this to work without any result ... I have two working SQL query's with an union and now I want to build a the last query and this doesn't work. It goes wrong when I want to define the OR statement: "' OR '" &...

Hello, I have some trouble with creating a pivot view in my project database. So far I created tge SQL to get my data but I can't fihure out how to make it a pivot view. I am working with FE access - BE SQL tables My SQL so far: strSQL = " SELECT TblMoederrollen.Moederrolnummer...

Hello Wayne, code works just fine. Thanks a lot. Sven.

Hello, I want to copy some values into a table (kwaliteitswaarde) with a query. The fields that need to be filled are moederrolnummer, kwaliteitid, kwaliteitswaarde. So what do I have so far: First of all I have a query that gives all the ID's and the values that need to be copied (see...

Hello, I get it to work with the str function ... Thanks Sven.

Hello, I think it doesn't work because I am working on SQL tables and not on access tables. So the error that I get is that Cstr is not a defined function! So it is my mistake because I had to mention this in my first message ... Sorry ... So I need the function for SQL tables ... Best...

Hello, I'm back again because I can't get it to work ... Where Do I put this Cstr ??? I tried it like this: strSQL = " SELECT DISTINCT Cstr([Gramgewicht]) " & _ " FROM TblPapiersoorten " & _ " UNION SELECT 'ALLE GRAMGEWICHTEN' AS Gramgewicht " & _ " FROM...

Why do this? Because this is a list to choose from that is used for a query and I want to have the possibility to select "all gramgewichten" Best regards, Sven.

Hello, I have a problem with an SQL statement. The thing is that I want to use a union on a tinyinteger field with text. Something like this: strSQL = " SELECT DISTINCT Gramgewicht " & _ " FROM TblPapiersoorten " & _ " UNION SELECT 'ALLE GRAMGEWICHTEN' AS Gramgewicht " & _...

Hello, how can I do the following: I have 2 query's with the same field kwaliteitsgegevens.kwaliteitsnaam Now it should be so that in query 1 all the results from query 2 are excluded. Is this possible? Query1: strSQL = " SELECT Kwaliteitsnaam, FrequentieID, MachineID, Eenheid " & _...

Hello, who can help me with the following problem: when I open a form with a subform I get an error (number 2455). WhenI take a look to the code the error is in the following SQL: Private Sub BronSubformulier1() Dim strSQL As String strSQL = " SELECT...

Hello, I have made a crosstab query to organize the data for the report. What I can't do is use this query as recordsource for a report. The query look like this: PARAMETERS [Forms]![FrmRapportering]![cbopapiersoort] Text ( 255 ), [Forms]![Frmrapportering]![cbogramgewicht] Text ( 255 )...

Hello, I understand that making a crosstab is possible but not easy to do. The Query of my report looks like this: SELECT TblMoederrollen.Moederrolnummer, TblMoederrollen.Papiersoort, TblMoederrollen.Gramgewicht, TblMoederrollen.Datum, TblKwaliteitgegevens.Kwaliteitsnaam...

Hello, How can I make a report in landscape? I have a table like this: number name value 1 test1 45,3 1 test2 12 1 test3 11,4 2 test1 3,6 2 test5 8,88 Now I want to create a report like this: 1 test1 test2 test3 45,3...

Hello, about my problem I try to do it like this: Dim teller As Integer Dim rs As Recordset Dim VarItem As Variant Set rs = CurrentDb.OpenRecordset("TblKwaliteitswaarde") For teller = 0 To lstvorigemoederrol.ListCount - 1 rs.AddNew rs!Moederrolnummer = Me.Txtmoederrolnr...

Hello, how can I copy values in a viewlist to a table with a different number? I have a listview with a recordsource like this: SELECT TblKwaliteitgegevens.Kwaliteitsnaam, TblKwaliteitswaarde.Kwaliteitswaarde, TblKwaliteitgegevens.Eenheid, TblKwaliteitgegevens.KwaliteitID FROM (TblMachine...

Hello, I apologize about the wrong attachement. This is a new version. Thanks, Sven.

Hello, i have made the changes in my relationships like cpremo did, but when I use this relations in my subfoms I get a multiplicationfactor on the "kwaliteitsnaam". As attachment there is an example of this form. In this form, the user has to be able to check, change and add values for each...

Hello, there are T tables: TblMachine --> table with all the machines there are in the factory TblKwaliteitsgegevens --> measurements that are to be registrated on the product TblMoederrollen --> product that is made on these machines TblMachineonderdeel --> machineparts TblFreqentie --> the...

Hello, I have changed my relationships but it is still not working. When I run a query with a conection between tblkwaliteitswaarde - tbl machine - tbl kwaliteitsgegevens the records are multiplied with a factor x. So there is still something wrong with my relationships and I haven't got any...