Recent content by Alkemac

I have a VB6 Application, using Crystal Reports 10 and SQL Svr 2000. In the Crystal Report (GH3A) Group header, I have a formula (@FinancialSummary), which calculates a date string based on a field in the table. However, I'd like to pass it the value from my code. The code I use to call the...

Hi.. checked that out and the user has ownership rights on the folder... Thanks

We have a WAN in our corporate environment. Each of our 6 branches has its own Exchange server. Our Exchange server in head office replicates every 10 or so minutes to these branch Exchange servers. I've developed a VB6 application, which places an email in our Head Office Exchange server in a...

Thanks Andrew... I'll have a look at it..

Hi.. How different would it be trying to place the email in a default folder in a public folder ? Thanks

Hi..I have been scouting around to find something to help me and came across the following if it is of some help to you.... Example This example demonstrates how to use to set some of the properties of the MicrosoftMailDestinationOptions class. [Visual Basic] Public Sub ExportToMSMail(ByVal...

Hi.. am new to Vb.Net... Problem is, I have an exisiting report that I wish to call programatically, pass it two parameters and then email. Can someone please help ??? PS - Not for school project or any other nefarious reason!

Thanks a mill... I'll give it a try...

Hi - Unfortunately, no one helped. I tried this URL www.dimastr.com and looked at the OutlookSpy option.. To be honest, I didn't explore it further. If you dont come right, let me know and I'll try and help you.

Does ExportOptions support the ability to send an email via MAPI and VB6 using another email address instead of my own deafult ? Thanks

Thanks Dr....

Will this help ? Option Explicit 'Connections Public PCis As New ADODB.Connection Private Command1.click dim SQL as string SQL = " Exec PCis.dbo.portcis_getbdastatement_statementsdb '200312'" 'StatementHistory.Execute SQL PCis.Execute SQL end sub Private Sub Form_Load() Set...

Just along similar lines, I've got a stored proc sitting in SQL svr 2000 and when I run it from my VB6 code, it pulls 365 records from the tables and then hits the timeout expired error. Anyway I can get around this as I am not using a recordset where I can set the timeout ? Thanks

I tried using the following code to send an email from VB6, containing a Crystal report and it came up with the error "missing or out of date dll". Anyone know of a solution please ?

Thanks for the quick reply... Just in closing, how do I suppress the dialogue box from appearing, is that just a false. Only need one copy and no collation. How do I supply those ? Thanks!