Search results for query: *

Hi I am having the problem in a Web Application. In the mean time I created a windows app and used the following code. XConnection() Dim arParams(1) As SqlParameter arParams(0) = New SqlParameter("@SESSIONID", TextBox1.Text) arParams(1) = New SqlParameter("@CLIENTID", CLng(TextBox2.Text))...

Hi All I have a piece of code that on a monthly basis creates emails to distinct email addresses with attachments and writes these into the Drafts folder in Outlook. I usually need to hold these for a few days before sending them. We I need to send these 800 or so emails I have open each one...

Hi I would like to use the look and functionality of the outlook control but not to read emails. I would like to attach this to a data set and populate it with my own data and headings. Can this be done ?

Hi All The code below works and creates an email with all my recipients in the "To" area of the message. How can I write these email addresses to the "BCC" area rather. --- Set golApp = New Outlook.Application Set objNewMail = golApp.CreateItem(olMailItem) With objNewMail...

Hi As an input file I have a list of times(durations) in the format hh:mm:ss . I created a table with a column of datetime and have written these in the format '1900/01/01 hh:mm:ss'. I am trying to get an avearge of these durations. I would also like to calculate the total in days, hours and...

Hi All I have paged through all the previous entries for this kind of thing but still can't get my code right. I am trying to change the SQL Server for the report. CrystalReportPath = "S:\CrystalReports\" + strENVRptNme Set CrystalApplication = New CRAXDDRT.Application Set...

Hi I am developing a system and using Crystal 8.5 with VB 6. I connect my report to the SQL Server database by selecting a datalink file from the explorer style box presented. My problem is that when I develop using a test server and then need to point these reports to the production machine...

Hi All Even though the use of cursors is not popular I would like to query a multi level structure. The level count will define how many cursors I will need. If I replace STR(@CNT) with for example C1 this works fine. DECLARE @CNT INT DECLARE @LVL INT SET @LVL = 3 SET @CNT = 1 WHILE (@CNT...