Search results

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

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

Hello, how can I make a pivot query in SQL server 2008? This is the select query where an employee can hace more than 1 function. It would be nice to display all the functions of this employee on 1 line. SELECT Employee.Employeenumber, Employeefunction.FunctionID FROM Employee...

Hello, is it possible to make a query that insert 2 counts into a tabel. This is the insert: INSERTINTO TempGraph(departmentname, CountEmpl, MaxEmpl) this is the first count: SELECT department.departmentname,COUNT(department.departmentname)As countEmpl FROM Courses GROUPBY...

Hello, what is wrong in the following syntax: WHERE (DATEDIFF(m, MIN(Wachtlijstdeelnemers.Inschrijvingsdatum), CurDate) > 3) I want to select the dates that are older than 3 months --> starting from the current date. Thanks in advance, Sven.

Hello, can somebody tell me what is wrong in this query ... strSQL = " INSERT INTO Opleidingsaanvraag (Personeelsnummer, Status, date) " strSQL = strSQL & " SELECT '" & [Forms]![FrmOpleidingsaanvraag]![txtstatus] & "' AS Status, " strSQL = strSQL & "'" &...

Hello, I have a problem to connect an access adp project to a dedicated server. when I click file - connection I put in the following: servername: IPadres\SQLExpress specific username and password When i hit the connect test button I get an error like: acces to the server is denied...

Hello, is it possible to calculate a field in the reportfooter? The field is build like this: Controle = Case Personeels_evaluaties2.eindevaluatie WHEN 'J' THEN 0 ELSE 1 END " But when I try the fomula in the SQL: Sum(Controle) I get an error that controle is not a column. Thanks in...

Hello, how can I connect an adp database with SQL server Express on a SQL server 2008. For the moment I have a project (adp) database using access 2007. I'm able to create an ODBC connection and I can access the remote server without any problem. When I open in access the server...

Hello, is it possible to import an xml file into a table? Below an example of the xml file: - <SMDATA> - <EMPLOYEE PCODE="27AB003"> <IDENTITY LastName="test" Firstname="testname" Language="N" Birth="22/08/1961" Sex="M" Employ="01/01/1997" Out="" Level="A" Category="A" Communic1=""...

Hello, can somebody help me with the following issue: how can I make connection with a sql server 2005 using the internet? I am working with access 2003 and it is an adp project. Thanks in advance, Sven

Hello, when somebody start my database the first time on there computer access install vba automatically. Is there a way to prevent this. The reason why I ask this is because some of the users have no adminstrator rights and because of this the installation of vba goes wrong. So I want to...

Hello, I am working with an access 2003 project and a SQL server 2005. After I have restored a database I can't open the tables anymore in access. It is normal that I can't make changes in tables because SQL server 2005 doesn't work with access 2003 but normally I can open the tables. Now it...

Hello, when I try to make a backup from my sql database I get the following error:</SPAN> TITLE: Microsoft SQL Server Management Studio Express ------------------------------ Backup failed for Server 'PPBE01-133\SQLEXPRESS'. ------------------------------ ADDITIONAL INFORMATION...