Recent content by sven2

Hello, when I want ot delete a record and there is a character like ' in the name I get an error in the following string: DoCmd.RunSQL " DELETE * " _ & " FROM Grade " _ & " WHERE Grade.Grade = ('" & Me.lstpapiersoort.Column(0) & "'); " I understand why the...

Hello, the syntax is ok but I have to replace the queryname QryBasicCrosstab to the name? of the first SQL and I don't know how. Best regards, Sven.

Hello, what is the right way to make a pivot query in vba based on another query. I have the following: 'strSQL = " SELECT CustomerGroup.Klantnaam, Grammages.Grammage, Grade.Grade, " 'strSQL = strSQL & " Widths.Width, Purchased.WidthNr " 'strSQL = strSQL & " FROM Widths INNER JOIN...

Hello, thank you very much for this information. I have solved the problem with this print utility.:):) Best regards, Sven.

Hello, for the moment I have a report that is showing for each customer a product. It look like this: customer a - product 1 customer a - product 3 customer a - product 4 customer b - product 1 customer b - product 2 I want to change this like: customer a - product 1, product...

Hello, I have report that I open in reportview. On this report there is a button wich would allow the user to print the report. I have put the following code behind the button: If MsgBox("Are you sure you want to print the report?", vbQuestion + vbYesNo) = vbYes Then DoCmd.RunCommand...

Hello, how can I define a remote desktop connection wich allow a friend to connect with my SQL server 2008 and only run 1 particular program? It should be so that when he start the remote connection the program starts automatically and when he close the program he should be logged off...

Hello, I have a database sitting in SQL server that i would like to mail merge. I use a combination of an Access front-end with an SQL database that keeps the tables and records. When I connect the word document to sql server express (test server) everything works fine. When I connect the...

indeed, that was the problem. Thank you ...

Hello, i have tried it also with a checkbox, the result is the same, it doesn't work. On the report there is a field named score. when I put a chackbox next to the field with the code like: =iff([score]=3;-1;0) the checkbox stays always false. Evan when the field has the value 3. I...

Hello, on my report there is a field named score. Next to this field there is a radiobutton. Now I want to make it so when the field has a value 3 the radiobutton is true else false. what for code do I put in the recordsource of the radiobutton? I tried iff([score])=3,true, false) but...

Hello, no, I don't want the scores on 1 line. I want the scores on serveral lines. So for employee 11 it should be: scoreID1: score scoreID2: scores scoreID3: score Best regards, Sven

Hello, the question is when I put a field score on a report and I have 9 scores with a different ID I get 9 lines! I want to put eacht score on a fixed position depending the ID. Sven.

Hello, I have made an example. As you can see, I want the scoreID on an fixed position and not underneath eachother. Best regards, Sven.

Hello, I want to build a report with fixed positions. I have a queryresult that gives personnumber, ID and results and it looks like: Pnr ID Result 11 1 A 11 2 AA 11 3 AC Now I want to place these result fixed on a report. It can be so that personnumber 12 only has ID 1 and...