Search results for query: *

I have managed to fix the 1st problem, I was just missing (). The second one is confusing me - I have it working in visual basic 6 module. However when I transfer it to the activeX module I receive the error. Do I have to install anything?

Hi, I have been working on the piece of code below in a DTS package. The two lines highlighted are causing problems. The 1st one I am getting an error with is saying that their is a type mismatch. In the table currentpractice is a varchar - am I declaring it incorrectly? The second line says...

i have got it working, no need to create a connection just needed;- Report.Export False meaning no user interaction

Hi, I would like to export the files created by activeX script to be automatically saved to a predetermined location on the execution of a DTS package. I have checked the code using Visual Basic compiler and seems to work. When I put it into DTS package - the code executes however the file is...

Sorry if this is not directly related to this forum - was not sure which one to use. I am trying to get the code below to run, I am planning to hopefully get this running through a DTS package. However I keep reciveing an error 429 cannot create ActiveX component. I have tried installing...

Hi - I not quite sure what you mean? Is there a website. I have found the following code on the internet (http://www.sqlservercentral.com/forums/shwmessage.aspx?messageid=108832) i have put this into an ActiveX script object in the DTS package, however I am getting an error:- Set App =...

Hi, I have not used crystal reports before and dont really know where to start. I have a SQL Server database with a Stored Procedure which pulls out all the information needed for the reports which i would like to generate. I plan to run this each night based on a SQL Server scheduled job so...

I have now changed the IF statements to not be a set to a variable but an actual SELECT statements:- select Num_Months_A from #inforeporting)>=3 and (select Num_Months_A from #inforeporting)<6 ) This is the line causing an error as the temp table has two records in it. How can you re-iterate...

I have created the stored procedure below to create reports based on a number of months. This works fine when there is only one record inserted into the temp table. If there is more I get the following error:- Subquery returned more than 1 value. This is not permitted when the subquery follows...

Sorry - Realised that I did not change it to HTMLBody

I have a CDO stored procedure which works and send out emails. However I would now like the body of my email to be HTML so that I can apply formatting to the text. However I am unsure how to set up the HTML tags and where to put them. I have change the main SP to this:- EXEC @hr =...

i have decided to use a cursor as it is unlikey to be anymore than 10 records that the cursor will be looping through. Thanks

Thanks for that Will try that and post back results

I would like to run a store procedure for every record in a table. Go to the first record send an email Go to the second record and so on until every record has has an email sent. I was just wondering how you do this in a SP, currently the SP only does it for the one record Thanks in advance.

Thanks for that - do I create the file at runtime in the DTS package and if so how would I do it.

Do you mean that you can automate the deletion of the Excel file or that you manaully delete it??

I have created an macros in an adp project that does exactly what I would like it to do. Replaces a current Excel file with the new information. The problem is that this needs to be run each week and I would like some way of automating it.I have tried doing this all in SQL Server however you...

Hi, I have set up a DTS package which links to an Excel document. This document is going to be updated on a weekly basis. However the problem is that when I run the query, the rows just append to what is already there and I would like to replace them. I then tried to use an SQL Task in the...

I have tested for null fields ub BeforeUpdate, however the form still proceeds to close. I have used the following code:- ElseIf IsNull(StreetName) = True Then MsgBox ("Please fill in the STREET NAME") Me.StreetName.BackColor = vbCyan Cancel =...

I have pressed to close the form and then the error comes up. I therefore want to cancel the close command is this possible?