Recent content by sdempsey

Hi, Thanks for your reply. I will try to be a bit more clear. I have over 100 employees in a database and I would like the query return 100 employees with a First Date and Last Date. The first date we have for each employee tends to have little data attached to it and would only want to use...

Hi, I am trying to compare dates. So for example I could have the following dates:- Person A 09/09/2006 09/10/2007 09/10/2007 09/10/2008 Person B or I could have the following 09/10/2007 09/10/2008 If ther are only 2 dates present for a person I would like 09/10/2007 to be taken as the...

Hi all, I have 3 columns with dates in them for the same record and I would like to create a new column in the database that would hold the maximum date (of the 3 other dates). For example date 1 23/09/2005 date 2 25/09/2005 date 3 27/10/2005 New column - I would like 27/10/2005 for each row...

Sorry about this. I posted this orginally on the Outlook forum and had no response. So thought this is perhaps a better forum. I am trying to automatically save an attachment after it enters the inbox.I thought I would create a rule doing the following:- Automatically run a script via a rule...

Hi, I am having a problem running a script in Outlook. When I go to 'run script' there are no scripts there to run. I have tried to create a marco and put my code inside there however the procedure name is not there. how do you make your script name appear there? Thanks in advance.

I have the following line of SQL:- set @sqltxt = 'INSERT INTO ' + @lookup_table + '([Description],[Code],[Entered_By]) Values('''+@description+''','''+@code+''','''+@person+''')' The probelm is that the descriptions may contain single quotes and cause the compiler to complain that I have not...

I have established that I am already passing the username and password using the sendusername and sendpassword methods. However I am getting the following error:- The server rejected one or more recipient addresses. The server response was: 550 5.7.1 Unable to relay for <email address> Any ideas

I use the following line of code to send an email:- exec sp_cdo_sendmail @rec, @sender @subject ,@body This has stopped working as the recipent has to be authenticated by the mail server before it can send the email out. Do you know if this is possible to adapt the sp_cdo_sendmail procedure...

I have removed my parameter fields and now only have one parameter on the main report. The code now works in the above form and a report is produced from the DTS package. Thanks for you help. It stopped me going mad.

Hi, I was just wondering if anyone can help me. i cant seem to find any info out there. i have created a report with one subreport. The 1st page of the report the parameter values are displayed however on the second (sub report) they are not. Indicating that the parameter values is not being...

I have successfully got a report to work without any subreports. The parameter value is passed and data is successfully added to the report. My question now is how will I get the whole report to work. I have 8 subreports - all refer to the same 2 database tables and some also refer to...

Hi, I have been looking around the internet and cant seem to find any help. If anyone has an idea -- I would be very grateful. report.ParameterFields.Item(1).AddCurrentValue (currentpractice) There is nothing being added to the Parameter fields. Am I perhaps missing a dll? Are these...

I am using Crystal Reports 10 and SQL Server 2000. I have added the following code to a DTS package and is contained within an ActiveX script. The code seems to work and a report is produced however it does not contain any database values from the tables. The report has a number of different...

Hi, I have had a good look through the forum and the below seems to be the solution:- Select FR.no, FR.date, FR.pat_id, FR.run_date, FR.entry_number From #first_report as FR Where run_date = (Select MIN(run_date) FROM #first_report as FR2 Where FR2.pat_id = FR.pat_id and...

The above situation may happen with a number of different rows. The above code would only pull out 1 row from the whole table? So a pat_id may have 3 records or may just have 1. I would like 1 record returned for each pat .