Search results for query: *

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

I have the following fields in my database * Entry Number (unique for every record) * Company ID * Pat ID * Date Seen * Run Date All fields can be the same i.e. Company ID, Pat ID, Date Seen and Run Date may be the only one that varies.Entry number will be different every time. I would like...

Hi all, I am a bit confused over the dll that are needed to export to pdf/word. I currently have Version 10 of Crystal Reports installed. Previously we had version 8.5 and a Visual Basic application (module in Access) was written that exported word documents. Version 8.5 was removed from the...

Hello, I hope this is the best forum for this question. I have the following line in my Active X script:- Conn.Open "Provider=SQLOLEDB.1;Initial Catalog=Backup_Database;App=Crystal Export;Data Source=(local)", "dummy", "dummy" Dummy has standard login and is a dbo user within the...

I am wondering if someone could help me with the following INSERT statement. declare @sqltxt as varchar(200) select @sqltxt = 'INSERT INTO'+ @lookup_table+'('+[Description]+','+[Code]+')values('+@description+','+@code+')' print @sqltxtExec sp_executesql @sqltxt Am I right in the fact that...

I would like to change a date value I have into a varchar to allow me to join it to a table with a varchar value. I have looked through the forums come up with some ideas none of them seem to work. I would like yyyymmdd However at the moment 5th August 2005 is being returned as 200585. I need...

Hi, I had a DTS package which I saved as VBscript in the save as option box. I then went to my Access adp project and put the VB code against a button. I then included all references to the DTS package. If I click the button when I am a dbo - the DTS package runs however ever under different...

I have a table with stores the unique identifier for each customer that is to recieve an email. I then have a stored proc which sends out the emails. However there was an error is the SP and too many emails were sent out. I am abit unsure how to error check the stored procedure. WHILE...

Hi, I had a DTS package on a local server and successfully completed a bulk load transfer. By connecting to the file using the following code:- objXBulkLoad.ConnectionString = "PROVIDER=SQLOLEDB.1;SERVER=(local);Trusted_Connection=Yes;DATABASE=Project_Database;" I now need to move this over...

Hi, I have created a report in Cystal reports 10 and connected it to a SQL Server database. The report should be 20 pages long however when I preview/export the report it produces the report a number of times. I am not sure why this is happening I have created another report nearly the same...

I am having a problem with the dates. In my database the dates are stored as varchars in the format yyyyddmm and I would like them changed to yyyymmdd. However when I try to cast them to a date to allow me to do a convert operation. I am am getting an out of range error. Is there an other way...

I have 6 digit varchar's stored in a table such as 030405, these are always 6 characters. I have created a form and a combo list box. In the combo list box a person 6 digit number is displyed along with their name. New_Person has a data type of String Code New_Person =...

I am using Crystal Reports 10 and trying to produce same superscript text. I have created a formula with the following text included within it:- "<SUP>" + '1.2' + "</SUP>" i have then added it to my report and changed it to HTML interpretation. However it is just being displyed on the report...

I have created a cross tab based on the data held within a database table in the following structure. ID Population (1 or 2) Step (0-5) Sample data 1 2 0 1 2 1 1 1 3 So this identifier has at 1st population 1 person at step 3 and at population 1 patient at step 0 and another at 0...