Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DateAdd function
I am connecting with Access database through JetOLEDB. I have to select from employee table adding 3 years to the joineddate.The following code gives the error " No value given for one or more required parameters" -2147217904 Select dateadd(year,3,employee.joineddate) from Employee...- Solly
- Thread
- Replies: 2
- Forum: Visual Basic (Classic)
-
Crystal Report showing the fisrt time values always
I am having a list of EmpIDs. For the first time if I choose emp1,emp2 in the form they are displayed in the report. After closing the report and coming back to form and if I choose emp3 then the base recordset has the value emp3. But the report displays the first time values only. My code is...- Solly
- Thread
- Replies: 0
- Forum: Business Objects: Crystal Reports 4 Other topics
-
passing parameters to SQLserverstoredProcedure from VB(ADO)
Set prmExpenditure1 = cmdExpenditure.CreateParameter("allorsome", adVarChar, adParamInput, 1, gparam1) cmdExpenditure.Parameters.Append prmExpenditure1 Set prmExpenditure2 = cmdExpenditure.CreateParameter("ProjectIDs", adVarChar, adParamInput, 200, gparam2)...- Solly
- Thread
- Replies: 1
- Forum: Visual Basic (Classic)
