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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by MichaelaLee

  1. MichaelaLee

    VS.NET Help not working

    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...
  2. MichaelaLee

    How set date field to NULL in code

    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 =...
  3. MichaelaLee

    Finding Dupes across multiple fields

    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...
  4. MichaelaLee

    Finding Dupes across multiple fields

    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...
  5. MichaelaLee

    two subqueiries in main query

    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...
  6. MichaelaLee

    two subqueiries in main query

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

    A Lookup value for saving data

    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...
  8. MichaelaLee

    Current Recordset does not support updating

    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
  9. MichaelaLee

    Current Recordset does not support updating

    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...
  10. MichaelaLee

    Current Recordset does not support updating

    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...
  11. MichaelaLee

    Current Recordset does not support updating

    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...
  12. MichaelaLee

    Comparing Dates, but only the Month/Year parts.

    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...
  13. MichaelaLee

    Using User-Defined Column name in where clause

    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...
  14. MichaelaLee

    Using User-Defined Column name in where clause

    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...
  15. MichaelaLee

    Return a Value from a Stored Procedure

    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...
See more

Part and Inventory Search

Back
Top