Search results for query: *

Hi Everyone, I've been having a little propblem lately that just got worse. I was having a problem with the help coming up in the develpment enviroment. It would say "downloading..." while it was looking, then it display the "Page not found" error page, but If I did it again it always came up...

Hi everyone. I wanted to know the best way to set a datetime field to null in VB code. We are using SQL Server. Take the following code Set mCommand = New ADODB.Command mCommand.CommandType = adCmdStoredProc mCommand.CommandText = "nf_UpdateTermination_Import" mCommand.ActiveConnection =...

Thank you SQLSister for your reply. That worked great. Now I have one more request. How do you change it so that it will delete the dupes without deleting all the records. Meaning, I would like to delete all the dupes but one. I had the following but it deleted all the dupes: DELETE PatientID...

Hi Everyone, I have a need to find dupes across multiple fields in a few tables and the queries I've used so far are not working for me. Here are exapmle of fields in the table: PatientID AdmissionDate Name Relationship Age How would I go about finding dupes across the first 4 fields. Thanks...

Hi checkai, Thank you for the reply. I tried your sample and it worked great with a few minor name changes, but I now need to add one more table to the query. I have the following table Admission: PatientId /* Link to Patients table */ Fee AddThisField Ect... Say I need to add AddThisField to...

Hi All, I have the following tables: Patients: PatientId Name DoctorId TheripistId ect... DoctorLookUp KeyId DoctorName The doctor lookup table contains all doctors and Theripist in one table. Now I need to run a query that will display the name of the Doctor and Theripist when I...

Hi Everyone, Was not sure how to name the subject, but here is what I need to do. I have the followinf stored proc: INSERT INTO BillingSupport ( PatientId, ServiceDate, Diagnostic, Program, AttendedGroup ) SELECT ATTENDANCE.PatientID, ATTENDANCE.AttendDate, ATTENDANCE.Diagnostic...

Hi Roy, After taing a look at the KB that I found. I tried the following. I replaced the line: Set rsInsurance = mCommand.Execute with rsInsurance.open mCommand And it seems to work fine. Thanks again for the help. Michael Lee

Hi Roy, I just found a KB from Microsoft (KB188857) that talks to that some. This is a mayjor problem. I need to pass parameters to the stored proc. Its either that or open the recordset and then use the filter property to filter the data. I was hoping I would not have to do that. All this is...

I have changed the above slightly but I'm getting the same results. I tried two things so far. 1. I changed the CursorType to adOpenKeyset. But the same problem. 2. I also tried getting rid of the uniqueidentifier field and I had the same problem. Question. Would ahaving 3 fields as the primary...

Hi everyone. I'm using SQL Server 2000, and I'm having a slight problem with a recordset from a stored procedure. When the query is first opened all settings indicate that the recordset is editable. As soon as I try to add/Modify a record I get the following error: Current Recordset does not...

Hi Everyone, I'm working on a UDF that will tell me if a date falls within a Date range. The catch is I can't look at the Day part of the date as a comparision. In other words, If I have the following: LookUpDate = 6/25/2004 StartDate = 2/1/2004 EndDate = 2/5/2005 The UDF should only look at...

Hi Guys, First off I want to thank you all for the replys. It has been helpful. Now I have another question. I have been doing some testing with a table I have. The table contains three fields that are calculated fields and I'm having a slight problem with them at this time. I have set the 3...

Hi Everyone, I'm using SQL Server 2000 and have a slight problem. In my query I use a User-Defined function to get the column value as follows: SELECT UserID, Max(Termination.DOA) AS LastAdmission, PATIENTS.LastName + ', ' + PATIENTS.FirstName as Name, DateAdd(m, 3, Max(Termination.DOA)) as...

Hi Everyone, I need to get a new Id from a stored procedure that just added a new record. How can I go about getting the returned value back. After this insert is done I need to use that ID for other procs in my procedure. Thanks Here is an example of what I doing without returning a value...

Hi bboffin, I did what you suggested as a test and still getting the same error message. Here is the code I changed to: Set mCommand = New ADODB.Command mCommand.ActiveConnection = ado mCommand.CommandType = adCmdStoredProc mCommand.CommandText = "nf_AddOrder"...

Hi bboffin, Thanks for the reply. I'm not sure which one is causing the error. The error is not specific anough. I also need to be able to pass a null value to these fields if possible. If nothing else I can pass a 1/1/1753 since this is the lowest value that SQL will store. For the parameters...

Hi Everyone, I'm having a little problem adding a record that contains 3 smalldatatime fields. I'm getting the following error: Error converting data type datetime to smalldatetime. Here is the code: Set mCommand = New ADODB.Command mCommand.CommandType = adCmdStoredProc...

Just a short note on above question above. I do have data in the database that should be returned with the studentid, and yet after the execute method is run, I get a recordcount of -1. Thanks again. Michael

Hi All, I'm having a slight problem trying to get a resultset back from an Access 2000 database. I have the following code: SQL Query: PARAMETERS [lStudentId] Long; SELECT StudentCourses.CourseID, Courses.CourseTitle, StudentCourses.StudentID, StudentCourses.StartDate...