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

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

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

Hi Everyone, I would like to know how to get the Program Icon from an exe. My manager asked me to build a little app that will launch other apps like Notepad along with other apps. What I want to do is assign the program Icon to the Picture property of a command button. Thanks for any info that...

Hi Everyone, I have a need to convert an int field to a string. For example, if the int field contains 39, I need to the output to look like "NF00039". Actually what I'm doing is using a support table to get the next Key value and that returns an Int. Then I need to take that value and convert...

Hi All, I have recently converted a access database to SQL Server 2000. Everything has been going well, but I can't get one query I need to work. I suspect I need to do it another way. I hope You all can help. Here is what I'm trying to do. I have 3 queries, the top level one uses the other two...

Hi Everyone, I'm having a slight problem with a query I'm inporting from MS Access to SQL Server. One problem is that when I run the query in SQL Query Analyzer I get no results, but is I run it in Access with the tables attached (dbo_ in the query) I get the results I expect. Can you look at...

Hi I have a need to make every other row Gray to make it easier for the users to read this report. I figured I would have to use the OnPrint or OnFormat event/Property to do thisd, but not sure how. Any ideas. Thanks. Michael

Hi Everyone, I've searched the forums here and have not found a solution that works yet. I hope you all can help. I'm working with Crystal Reports 9 and "SQL Server 2000". I'm getting the following error when trying to load a report in VB: Error from the Crystal Report viewer. Logon Failed...

Hi Everyone, I have a challenge for you all. I was wondering if there are any articles/code/samples of getting the text inout and output from in outside window. I beleive this will have to be done with windows api. I have started to research this, but wanted to get your opitions. I'm looking at...

Hi Everyone. I know that if the recordcount is -1, it suppose to mean that this property is not supported. I'm using Microsoft SQL Server 2000 - 8.00.760 (Build 2195: Service Pack 3). Here is the code: Set mCommand = New ADODB.Command mCommand.CommandType = adCmdStoredProc...

Hi Everyone, Today I installed an app that also installed the MSDE and every since then, I have not been able to load up any forms from any project. Actually, if I start a new project, and open an empty form, it seems to be ok. But once I start adding controls, I get the following error: The...