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?

...= CreateObject("ADODB.Recordset") Conn.Open "Provider=SQLOLEDB.1;Initial Catalog=E_Audit_Database;App=Crystal Export;Data Source=(local)", "**", "*****" 'Comm.ActiveConnection = Conn final = "final_reports_last_generated" Rcdset.Open final, Conn, adOpenStatic, , adCmdTable While (NOT...

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

...Rcdset = CreateObject("ADODB.Recordset") Conn.Open "Provider=SQLOLEDB.1;Initial Catalog=Audit_Database;App=Crystal Export;Data Source=(local)", "**", "****" 'You're database connection Comm.ActiveConnection = Conn Comm.CommandText = "SELECT * from final_reports_last_generated" Set...

...= CreateObject("ADODB.Recordset") Conn.Open "Provider=SQLOLEDB.1;Initial Catalog=E_Audit_Database;App=Crystal Export;Data Source=(local)", "**", "*****" 'You're database connection Comm.ActiveConnection = Conn Comm.CommandText = "SELECT * from final_reports_last_generated" 'Your...

...Export;Data Source=(local)","sa", "" 'You're database connection Comm.ActiveConnection = Conn Comm.CommandText = "SELECT * from final_reports_last_generated" 'Your sql string or SP. Set Rcdset = Comm.Execute ' Process for no records to be exported. If Rcdset.EOF Then '...

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?